Mysql Multiple Choice Questions

  1. The data type BLOB stands for:
    1. Binary Large Object
    2. Big List Object
    3. Binary List Object
    4. None of the above
Answer :
A
Explanation:
Added By : Dikshant

  1. The student marks should not be greater than 100. This is
    1. Integrity constraint
    2. Referential constraint
    3. Over-defined constraint
    4. Feasible constraint
Answer :
A
Explanation:
Added By : Naresh


  1. BCNF Stands for _________.
    1. Binary Coded Normal Form
    2. Boyce - Codd Normal Form
    3. Bit Code Normal Form
    4. Boyce Codd Natural Form
Answer :
B
Explanation:
Added By : Asfak Parasara

  1. In an RDBMS relationship between tables are created by using
    1. Alternate Keys
    2. Foreign Keys
    3. Candidate Keys
    4. Composite Keys
Answer :
B
Explanation:
Added By : Kiran Kumar

  1. In order to add a new column to an existing table in SQL, we can use the command
    1. MODIFY TABLE
    2. EDIT TABLE
    3. ALTER TABLE
    4. ALTER COLUMNS
Answer :
C
Explanation:
Added By : Kiran Kumar

  1. Which of the following statements is NOT true for views in SQL?
    1. Select statement used in the view definition cannot include ORDER BY clause.
    2. A view drives its data from the base tables(s)
    3. A view is updatable if it has been defined from a single relation
    4. A view contains a copy of the data
Answer :
D
Explanation:
Added By : Kiran Kumar


  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

Social Sharing
Search