Online Test for Mysql

  1. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.
    Rows
    Key
    Attribute
    Fields

  1. Which statement is used to find out what databases currently exist on the server?
    SHOW DATABASE
    SHOW DATABASES
    SHOW ALL DATABASES
    All the above


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

  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. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
    Dirty Read Problem
    Temporary Modify Problem
    Temporary Select Problem
    None of the above


  1. _____ is process of extracting previously non known valid and actionable information from large data to make crucial business and strategic decisions.
    Data Management
    Database
    Data Mining
    Meta Data

  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. Which statement is used to connect with mysql server?
    mysql -h host_name -u user_name -p password
    mysql -u user_name -p password -h host_name
    mysql -p password -u user_name -h host_name
    All the above

Post Your Question
Social Sharing
Search