Mysql Multiple Choice Questions

  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


  1. The primary key is selected from the:
    1. composite keys.
    2. determinants
    3. foreign keys
    4. candidate keys
Answer :
D
Explanation:
Added By : Prachi Gupta

  1. If there is more than one key for relation schema in DBMS then each key in relation schema is classified as
    1. Prime key
    2. Super key
    3. Candidate key
    4. Primary key
Answer :
C
Explanation:
Added By : Prachi Gupta

Social Sharing
Search