Online Test for Mysql

  1. Source command is used to import data in MySQL.

  1. USE, QUIT, EXIT does not require a semicolon.

  1. DML is used for _______?
    Control access to data stored in a database
    Defining database schema
    Inserting, Deleting and Updating data
    None of the above

  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. 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. What is Granularity?
    The size of data items
    The size of database
    The size of record
    The size of file

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

  1. Displaying query results vertically is not possible in MySQL.

  1. Drop table structure is
    DML Statement
    DDL Statement
    Query Statement
    None of the above

Post Your Question
Social Sharing