Online Test for Mysql

  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. Which statement is used to change database?
    USE db_name;
    WANT db_name;
    CHANGE db_name;
    None of the above


  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. 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. 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. DML is used for _______?
    Control access to data stored in a database
    Defining database schema
    Inserting, Deleting and Updating data
    None of the above


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

  1. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?
    DML(Data Manipulation Langauge)
    DDL(Data Definition Langauge)
    Query
    Relational Schema

  1. Drop table structure is
    DML Statement
    DDL Statement
    Query Statement
    None of the above

Post Your Question
Social Sharing
Search