Database Management System Set 5
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
On This Page
This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 5
Q1 | Which of the following is Database Language?
- data definition language
- data manipulation language
- query language
- all of the above
Q2 | Which of the following in not a function of DBA?
- network maintenance
- routine maintenance
- schema definition
- authorization for data access
Q3 | Which of the following represents a relationship among a set of values.
- a row
- a table
- a field
- a column
Q4 | Column header is refer as
- table
- relation
- attributes
- domain
Q5 | A Relation is a
- subset of a cartesian product of a list of attributes
- subset of a cartesian product of a list of domains
- subset of a cartesian product of a list of tuple
- subset of a cartesian product of a list of relations
Q6 | In mathematical term Table is referred as
- relation
- attribute
- tuple
- domain
Q7 | In mathematical term Row is referred as
- relation
- attribute
- tuple
- domain
Q8 | _______ allow us to identify uniquely a tuple in the relation.
- superkey
- domain
- attribute
- schema
Q9 | Minimal Superkeys are called
- schema keys
- candidate keys
- domain keys
- attribute keys
Q10 | Which of the following is not Modification of the Database
- deletion
- insertion
- sorting
- updating
Q11 | Which of the following is Relation-algebra Operation
- select
- union
- rename
- all of the above
Q12 | Which of the following in not Outer join?
- left outer join
- right outer join
- full outer join
- all of the above
Q13 | Who proposed the relational model?
- bill gates
- e.f. codd
- herman hollerith
- charles babbage
Q14 | Set of premitted values of each attribute is called
- domain
- tuple
- relation
- schema
Q15 | Logical design of database is called
- database instance
- database snapshot
- database schema
- all of the above
Q16 | Snapshot of the dta in the database at a given instant of time is called
- database schema
- database instance
- database snapshot
- all of the above
Q17 | Which of the following is not Unary operation?
- select
- project
- rename
- union
Q18 | Which of the following is not binary operation?
- union
- project
- set difference
- cartesian product
Q19 | Which of the following is correct regarding Aggregate functions?
- it takes a list of values and return a single values as result
- it takes a list of values and return a list of values as result
- it takes a single value and returns a list of values as result
- it takes a single value and returns a single value as result
Q20 | A command to remove a relation from an SQL database
- delete table
- drop table
- erase table
- alter table
Q21 | which of the following is not an Aggregate function?
- min
- max
- select
- avg
Q22 | The attribute that can be divided into other attributes is called
- simple attribute
- composite attribute
- multi-valued attribute
- derived attribute
Q23 | In an Entity-Relationship Diagram “Ellipses” represents
- attributes
- weak entity set
- relationship sets
- multi-valued attributes
Q24 | In an Entity-Relationship Diagram “Diamonds” represents
- attributes
- multi-valued attributes
- weak entity set
- relationship sets
Q25 | Which of the following is a Data Model?
- entity-relationship model
- relational data model
- object-based data model
- all of the above