Online Test for Mysql

  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 level of Abstraction describes what data are stored in the Database?
    Physical Level
    View Level
    Abstraction Level
    Logical Level


  1. Drop Table cannot be used to drop a table referenced by a ______________ constraint.
    Primary Key
    Sub Key
    Super Key
    Foreign Key

  1. If there is more than one key for relation schema in DBMS then each key in relation schema is classified as
    Prime key
    Super key
    Candidate key
    Primary key

  1. Which is the right statement to fetch all tables start with "a"?
    SHOW TABLES LIKE 'a%';
    SHOW TABLES LIKE 'a';
    SHOW ALL TABLES LIKE 'a%';
    All the above

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


  1. Which of the following is true?
    A relation in BCNF is always in 3NF.
    A relation in 3NF is always in BCNF.
    BCNF and 3NF are same.
    A relation in BCNF is not in 3NF

  1. Which statement is used to change database?
    USE db_name;
    WANT db_name;
    CHANGE db_name;
    None of the above

  1. Which of the following statements is NOT true for views in SQL?
    Select statement used in the view definition cannot include ORDER BY clause.
    A view drives its data from the base tables(s)
    A view is updatable if it has been defined from a single relation
    A view contains a copy of the data

Post Your Question
Social Sharing
Search