Mysql Multiple Choice Questions

  1. Which of the following is true?
    1. A relation in BCNF is always in 3NF.
    2. A relation in 3NF is always in BCNF.
    3. BCNF and 3NF are same.
    4. A relation in BCNF is not in 3NF
Answer :
A
Explanation:
Added By : Suchit

  1. Data Warehouse provides
    1. Transaction Responsiveness
    2. Demand and Supply Responsiveness
    3. Storage, Functionality Responsiveness to queries
    4. None of the above
Answer :
C
Explanation:
Added By : Rahul


  1. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
    1. Dirty Read Problem
    2. Temporary Modify Problem
    3. Temporary Select Problem
    4. None of the above
Answer :
A
Explanation:
Added By : Rahul

  1. Which level of Abstraction describes what data are stored in the Database?
    1. Physical Level
    2. View Level
    3. Abstraction Level
    4. Logical Level
Answer :
D
Explanation:
Added By : Rahul

  1. What is Granularity?
    1. The size of data items
    2. The size of database
    3. The size of record
    4. The size of file
Answer :
B
Explanation:
Added By : Rahul

  1. Storing same data in many places is called.
    1. Iteration
    2. Concurrency
    3. Redundancy
    4. Enumeration
Answer :
C
Explanation:
Added By : Sumit


  1. TCL is used for _______?
    1. Manage the changes made by DML statements
    2. Defining database schema
    3. Control access to data stored in a database
    4. None of the above
Answer :
A
Explanation:
Transaction Control Language (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions. eg. COMMIT, ROLLBACK, SAVEPOINT.
Added By : Amitosh

  1. DCL is used to _______?
    1. Manage the changes made by DML statements
    2. Inserting, Deleting and Updating data
    3. Control access to data stored in a database
    4. None of the above
Answer :
C
Explanation:
A Data Control Language (DCL) is used to control access to data stored in a database. eg. GRANT, REVOKE
Added By : Amitosh

Social Sharing
Search