Online Test for Mysql

  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. Which statement is used to connect with mysql server?
    mysql -h host_name -u user_name -p password
    mysql -u user_name -p password -h host_name
    mysql -p password -u user_name -h host_name
    All the above


  1. Which statement is used to count number of rows in table?
    SELECT COUNT(*) FROM placement_question;
    SELECT COUNT ALL(*) FROM placement_question;
    SELECT ROWS(*) FROM placement_question;
    All the above

  1. The primary key is selected from the:
    composite keys.
    determinants
    foreign keys
    candidate keys

  1. DCL is used to _______?
    Manage the changes made by DML statements
    Inserting, Deleting and Updating data
    Control access to data stored in a database
    None of the above

  1. Function which causes retrieval of any kind of data from database is considered as
    Interface or Signature
    User friendly signature
    Conceptual signature
    Logical signature


  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. BCNF Stands for _________.
    Binary Coded Normal Form
    Boyce - Codd Normal Form
    Bit Code Normal Form
    Boyce Codd Natural Form

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

  1. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
    Left outer join
    Full outer join
    Right outer join
    Half outer join

Post Your Question
Social Sharing
Search