Mysql Multiple Choice Questions

  1. To remove a relation from an SQL database, we use the ______ command.
    1. Delete
    2. Purge
    3. Remove
    4. Drop table
Answer :
D
Explanation:
Added By : Prachi Gupta

  1. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
    1. Query
    2. DML
    3. Relational
    4. DDL
Answer :
B
Explanation:
Added By : Prachi Gupta


  1. The term attribute refers to a ___________ of a table.
    1. Record
    2. Column
    3. Tuple
    4. Key
Answer :
B
Explanation:
Added By : Prachi Gupta

  1. The number of attributes in relation is called as its
    1. Cardinality
    2. Entity
    3. Tuples
    4. Degree
Answer :
D
Explanation:
Added By : Prachi Gupta

  1. Which of the following is used to delete an entire MYSQL database?
    1. drop entiredb dbname
    2. drop database dbname
    3. drop db dbname
    4. drop dbase dbname
Answer :
B
Explanation:
Added By : Prachi Gupta

  1. Drop Table cannot be used to drop a table referenced by a ______________ constraint.
    1. Primary Key
    2. Sub Key
    3. Super Key
    4. Foreign Key
Answer :
D
Explanation:
Added By : Rahul


  1. Function which causes retrieval of any kind of data from database is considered as
    1. Interface or Signature
    2. User friendly signature
    3. Conceptual signature
    4. Logical signature
Answer :
B
Explanation:
Added By : Kartik

  1. Type data abstraction which allows conceptual representation of data in database management system is considered as
    1. Logical design model
    2. Data model
    3. Interface model
    4. User friendly model
Answer :
B
Explanation:
Added By : Kartik

Social Sharing
Search