On This Page

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

Q1 | What is ACID properties of Transactions?
  • atomicity, consistency, isolation, database
  • atomicity, consistency, isolation, durability
  • atomicity, consistency, inconsistent, durability
  • automatically, concurrency, isolation, durability
Q2 | If every non-key attribute is functionally dependent on the primary key, the relation will be in
  • first normal form
  • second normal form
  • third normal form
  • fourth formal form
Q3 | Database locking concept is used to solve the problem of
  • lost update
  • uncommitted dependency
  • inconsistent data
  • all of the above
Q4 | UML is stands for
  • universal modeling language
  • unified modeling language
  • united modeling language
  • uni modeling language
Q5 | Data Manipulation Language (DML) is not to
  • create information table in the database
  • insertion of new information into the database
  • deletion of information in the database
  • modification of information in the database
Q6 | 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 primary-key value in an associated table
  • every foreign-key value must match a foreign-key value in an associated table
Q7 | ODBC stands for ______
  • offline database connection
  • oriented database connection
  • open database connection
  • none of above
Q8 | Which algebra is widely used in DBMS?
  • relational algebra
  • arithmetic algebra
  • both
  • none
Q9 | Which of the following is an unary operation?
  • selection operation
  • generalized selection
  • primitive operation
  • projection operation
Q10 | Which SQL Query is use to remove a table and all its data from the database?
  • create table
  • alter table
  • drop table
  • none of these
Q11 | In precedence of set operators the expression is evaluated from:
  • left to left
  • left to right
  • right to right
  • right to left
Q12 | In DBMS FD stands for _______
  • facilitate data
  • functional data
  • facilitate dependency
  • functional dependency
Q13 | How many types of keys in Database Design?
  • candidate key
  • primary key
  • foreign key
  • all of these
Q14 | Which of the following is based on Multi Valued Dependency?
  • first
  • second
  • third
  • fourth
Q15 | Which of the following is the structure of the Database?
  • table
  • schema
  • relation
  • none of these
Q16 | The minimal set of super key is called
  • primary key
  • secondary key
  • candidate key
  • foreign key
Q17 | A relation that has no partial dependencies is in which normal form
  • first
  • second
  • third
  • bcnf
Q18 | A functional dependency between two or more non-key attributes is called
  • transitive dependency
  • partial transitive dependency
  • functional dependency
  • partial functional dependency
Q19 | A logical description of some portion of database that is required by a user to perform task is called as
  • system view
  • user view
  • logical view
  • data view
Q20 | ______________ is a classical approach to database design?
  • left – right approach
  • right – left approach
  • top – down approach
  • bottom – up approach
Q21 | _____________ refers to the correctness and completeness of the data in a database?
  • data security
  • data integrity
  • data constraint
  • data independence
Q22 | A table that displays data redundancies yields ____________ anomalies
  • insertion
  • deletion
  • update
  • all of the above
Q23 | A lock that allows concurrent transactions to access different rows of the same table is known as a
  • field-level lock
  • row-level lock
  • table-level lock
  • database-level lock
Q24 | A type of query that is placed within a WHERE or HAVING clause of another query is called
  • super query
  • sub query
  • master query
  • multi-query
Q25 | A transaction completes its execution is said to be
  • saved
  • loaded
  • rolled
  • committed