Online Test for Mysql

  1. Which statement is wrong to select particular columns from table?
    SELECT id, question FROM placement_question;
    SELECT id, question FROM placement_question WHERE id = '2';
    SELECT id, question FROM placement_question WHERE 1;
    All are right

  1. The number of attributes in relation is called as its
    Cardinality
    Entity
    Tuples
    Degree


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

  1. Which is right statement to import data from text file in MySQL on shell editor?
    shell> mysql -host host_name -u user_name -p password db_name < text_file
    shell> mysql -host host_name -u user_name -p password db_name > text_file
    shell> mysql < text_file
    All the above

  1. Which is the right statement to fetch all tables start with "a"?
    SHOW TABLES LIKE 'a%';
    SHOW TABLES LIKE 'a';
    SHOW ALL TABLES LIKE 'a%';
    All the above

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


  1. Which is not a valid comment style in MySQL?
    # comment
    /* comment */
    -- comment
    //

  1. Which is right statement to insert multiple records?
    INSERT INTO job_question VALUES ('col1', 'col2'), ('col1', 'col2'), ...
    INSERT INTO job_question VALUES ('col1', 'col2'), VALUES ('col1', 'col2'), ...
    A and B Both
    None of the above

  1. DROP TRIGGER Command is not used to drop the trigger.
    True
    False

  1. Which symbol denotes derived attributes in the ER Model?
    Double ellipse
    Dashed ellipse
    Squared ellipse
    Ellipse with attribute name underlined

Post Your Question
Social Sharing
Search