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