Mysql Multiple Choice Questions

  1. Which symbol denotes derived attributes in the ER Model?
    1. Double ellipse
    2. Dashed ellipse
    3. Squared ellipse
    4. Ellipse with attribute name underlined
Answer :
B
Explanation:
Added By : Ritik


  1. ACID properties of a transactions are
    1. Atomicity, consistency, isolation, database
    2. Atomicity, consistency, isolation, durability
    3. Atomicity, consistency, integrity, durability
    4. Atomicity, consistency, integrity, database
Answer :
B
Explanation:
Added By : Prince

  1. Commit command is used for
    1. To restore the old values
    2. To save the current table
    3. To save the current transaction
    4. To recover the old table
Answer :
C
Explanation:
Added By : Lokesh Kumar


  1. A table that displays data redundancies yields ________ anomalies
    1. Insertion
    2. Deletion
    3. Update
    4. All of the above
Answer :
D
Explanation:
Added By : Aniket

  1. The value of Primary key
    1. can be duplicated
    2. can be null
    3. cannot be null
    4. none of these
Answer :
C
Explanation:
Added By : Tripti

  1. MVD is called as
    1. Many Value Dependency
    2. More Value Dependency
    3. Multi Value Dependency
    4. All of the Above
Answer :
C
Explanation:
Added By : Sumit


  1. Drop table structure is
    1. DML Statement
    2. DDL Statement
    3. Query Statement
    4. None of the above
Answer :
B
Explanation:
Added By : Tushar

  1. In SQL, __________ is an Aggregate function.
    1. SELECT
    2. CREATE
    3. AVG
    4. MODIFY
Answer :
C
Explanation:
Added By : Mahesh

Post Your Question
Social Sharing
Search