On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 2

Q1 | Which of the following is not Modification of the Database
  • updating
  • sorting
  • deletion
  • insertion
Q2 | Which of the following in not Outer join?
  • left outer join
  • full outer join
  • all of the options
  • right outer join
Q3 | Set of premitted values of each attribute is called
  • tuple
  • schema
  • domain
  • relation
Q4 | Which of the following is true regarding Null Value?
  • null<0
  • null=0
  • null<>0
  • null>0
Q5 | Logical design of database is called
  • all of the options
  • database schema
  • database instance
  • database snapshot
Q6 | Snapshot of the data in the database at a given instant of time is called
  • database instance
  • all of the options
  • database schema
  • database snapshot
Q7 | Which of the following is not Unary operation?
  • rename
  • union
  • select
  • project
Q8 | Which of the following is not binary operation?
  • union
  • set difference
  • cartesian product
  • project
Q9 | Which of the following is correct regarding Aggregate functions?
  • it takes a single value and returns a single value as result
  • 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
Q10 | The Primary key must be
  • non null
  • unique
  • option a or b
  • option a and b
Q11 | A command to remove a relation from an SQL database
  • delete table
  • erase table
  • alter table
  • drop table
Q12 | which of the following is not an Aggregate function?
  • select
  • avg
  • min
  • max
Q13 | The attribute that can be divided into other attributes is called
  • composite attribute
  • derived attribute
  • simple attribute
  • multi-valued attribute
Q14 | What is ACID properties of Transactions?
  • atomicity, consistency, isolation, database
  • automatically, concurrency, isolation, durability
  • atomicity, consistency, isolation, durability
  • atomicity, consistency, inconsistent, durability
Q15 | If every non-key attribute is functionally dependent on the primary key, the relation will be in
  • fourth formal form
  • third normal form
  • first normal form
  • second normal form
Q16 | Database locking concept is used to solve the problem of
  • inconsistent data
  • all of the options
  • lost update
  • uncommitted dependency
Q17 | UML is stands for
  • universal modeling language
  • united modeling language
  • uni modeling language
  • unified modeling language
Q18 | Data Manipulation Language (DML) is not to
  • insertion of new information into the database
  • modification of information in the database
  • create information table in the database
  • deletion of information in the database
Q19 | Which of the following in true regarding Referential Integrity?
  • every primary-key value must match a primary-key value in an associated table
  • every primary-key value must match a foreign-key value in an associated table
  • every foreign-key value must match a foreign-key value in an associated table
  • every foreign-key value must match a primary-key value in an associated table
Q20 | Which of the following option is use to retrieval of data?
  • stack
  • data structure
  • linked list
  • query
Q21 | ODBC stands for ______
  • none of above
  • open database connection
  • offline database connection
  • oriented database connection
Q22 | Which of the following is an unary operation?
  • selection operation
  • primitive operation
  • projection operation
  • generalized selection
Q23 | Which SQL Query is use to remove a table and all its data from the database?
  • none of these
  • drop table
  • create table
  • alter table
Q24 | In precedence of set operators the expression is evaluated from:
  • left to right
  • right to left
  • left to left
  • right to right
Q25 | In DBMS, FD stands for _______
  • facilitate data
  • functional data
  • facilitate dependency
  • functional dependency