Online Test for Mysql

  1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
    Candidate key
    Sub key
    Super key
    Foreign key

  1. Data Warehouse provides
    Transaction Responsiveness
    Demand and Supply Responsiveness
    Storage, Functionality Responsiveness to queries
    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. To remove a relation from an SQL database, we use the ______ command.
    Delete
    Purge
    Remove
    Drop table

  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 term attribute refers to a ___________ of a table.
    Record
    Column
    Tuple
    Key


  1. Which statement is used to displays information about the columns in a table.
    SHOW COLUMNS FROM tbl_job;
    EXPLAIN tbl_job;
    DESCRIBE tbl_job;
    All the above

  1. Which clause is used to sort the result of SELECT statement?
    SORT BY
    ORDER BY
    ARRENGE BY
    None of the above

  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. The data type BLOB stands for:
    Binary Large Object
    Big List Object
    Binary List Object
    None of the above

Social Sharing
Search