Mysql Multiple Choice Questions

  1. _____ is process of extracting previously non known valid and actionable information from large data to make crucial business and strategic decisions.
    1. Data Management
    2. Database
    3. Data Mining
    4. Meta Data
Answer :
C
Explanation:
Added By : Virendra


  1. Referential integrity is directly related to
    1. Relation Key
    2. Primary Key
    3. Unique Key
    4. Foreign Key
Answer :
D
Explanation:
Added By : Virendra

  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

Post Your Question
Social Sharing
Search