Database Management System Set 6
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 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