Online Test for Mysql

  1. TCL is used for _______?
    Manage the changes made by DML statements
    Defining database schema
    Control access to data stored in a database
    None of the above

  1. What is IGNORE keyword in MySQL?
    Ignores Primary key or Unique key violations and continues processing with the next row
    Ignores Primary key or Unique key violations and leaves any remaining rows unprocessed.
    Do not ignores Primary key or Unique key violations
    None of the above


  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. 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 statement is used to find out what databases currently exist on the server?
    SHOW DATABASE
    SHOW DATABASES
    SHOW ALL DATABASES
    All the above

  1. Create table employee (name varchar ,id integer) What type of statement is this ?
    DML
    View
    DDL
    Integrity constraint


  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

  1. Which of the following is used to delete an entire MYSQL database?
    drop entiredb dbname
    drop database dbname
    drop db dbname
    drop dbase dbname

  1. The number of attributes in relation is called as its
    Cardinality
    Entity
    Tuples
    Degree

  1. Storing same data in many places is called.
    Iteration
    Concurrency
    Redundancy
    Enumeration

Post Your Question
Social Sharing
Search