Online Test for Mysql

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


  1. How to see currently running queries in MySQL?
    SHOW PROCESSLIST;
    SHOW FULL PROCESSLIST;
    SHOW PROCESSLIST\G
    All the above

  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

  1. Insert into instructor values (10211, 'Smith', 'Biology', 66000); What type of statement is this?
    Query
    DML
    Relational
    DDL

  1. Which command is used to import data form text file in MySQL on MySQL editor?
    mysql> source text_file_path;
    mysql> \. text_file_path
    None of the above
    A and B Both


  1. Type data abstraction which allows conceptual representation of data in database management system is considered as
    Logical design model
    Data model
    Interface model
    User friendly model

  1. Mysql is ____ ?
    Object Oriented Database
    XML Database
    Relational Database Management System (RDBMS)
    NoSQL Database

  1. In order to add a new column to an existing table in SQL, we can use the command
    MODIFY TABLE
    EDIT TABLE
    ALTER TABLE
    ALTER COLUMNS

  1. A relational database consists of a collection of
    Table
    Fields
    Records
    Keys

Post Your Question
Social Sharing
Search