Online Test for Mysql

  1. Which clause is used to sort the result of SELECT statement?
    SORT BY
    ORDER BY
    ARRENGE BY
    None of the above

  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. The number of attributes in relation is called as its
    Cardinality
    Entity
    Tuples
    Degree

  1. In SQL, __________ is an Aggregate function.
    SELECT
    CREATE
    AVG
    MODIFY

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


  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 primary key is selected from the:
    composite keys.
    determinants
    foreign keys
    candidate keys

  1. A table that displays data redundancies yields ________ anomalies
    Insertion
    Deletion
    Update
    All of the above

Post Your Question
Social Sharing
Search