Online Test for Mysql

  1. Which level of Abstraction describes what data are stored in the Database?
    Physical Level
    View Level
    Abstraction Level
    Logical Level

  1. Which of the following is used to delete an entire MYSQL database?
    drop entiredb dbname
    drop database dbname
    drop db dbname
    drop dbase dbname


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

  1. The DISTINCT keyword used along with the SELECT keyword retrieves ______ ?
    Duplicate data depending on the column list
    Unique data depending on the column list
    Sorted data depending on the column list
    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. Which statement is used to load data form file to table?
    LOAD LOCAL INFILE '/path/student.txt' INTO TABLE student;
    LOAD DATA LOCAL INFILE '/path/student.txt' INTO TABLE student;
    LOAD DATA LOCAL '/path/student.txt' INTO TABLE student;
    All the above


  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. 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. Query to check value of MYSQL system variable
    SHOW VARIABLES
    SHOW VARIABLES GLOBAL
    SHOW GLOBAL VARIABLES
    A & C Both

  1. Which is right statement to kill process/thread in MySQL?
    KILL ALL thread_id/process_id
    KILL thread_id/process_id
    REMOVE thread_id/process_id
    None of the above

Post Your Question
Social Sharing
Search