Online Test for Mysql

  1. Which command is used to import data form text file in MySQL on MySQL editor?
    mysql> source text_file_path;
    mysql> \. text_file_path
    None of the above
    A and B Both

  1. What will be the output of this query UPDATE tab_name SET col1 = col1 + 1, col2 = col1;
    col1 and col2 have different value
    col1 and col2 have same value
    col2 has original value of col1
    None of the above

  1. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
    Dirty Read Problem
    Temporary Modify Problem
    Temporary Select Problem
    None of the above

  1. The data type BLOB stands for:
    Binary Large Object
    Big List Object
    Binary List Object
    None of the above

  1. Query result can be displayed vertically by terminating the query____?
    With \V instead of a semicolon
    With \G instead of a semicolon
    With \M instead of a semicolon
    All the above

  1. Which of the following is true?
    A relation in BCNF is always in 3NF.
    A relation in 3NF is always in BCNF.
    BCNF and 3NF are same.
    A relation in BCNF is not in 3NF

  1. To remove a relation from an SQL database, we use the ______ command.
    Drop table

  1. DDL is used for _______?
    Manage the changes made by DML statements
    Defining database schema
    Control access to data stored in a database
    None of the above

  1. BCNF Stands for _________.
    Binary Coded Normal Form
    Boyce - Codd Normal Form
    Bit Code Normal Form
    Boyce Codd Natural Form

  1. A relational database consists of a collection of

Post Your Question
Social Sharing