Online Test for Mysql

  1. Which is right statement to import data from text file in MySQL on shell editor?
    shell> mysql -host host_name -u user_name -p password db_name < text_file
    shell> mysql -host host_name -u user_name -p password db_name > text_file
    shell> mysql < text_file
    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. 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. Create table employee (name varchar ,id integer) What type of statement is this ?
    DML
    View
    DDL
    Integrity constraint

  1. Which of the following statements creates a new table temp instructor that has the same schema as instructor.
    create table temp_instructor;
    Create table temp_instructor like instructor;
    Create Table as temp_instructor;
    Create table like temp_instructor;

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


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

  1. How to set value of "query_cache_size" MYSQL system variable
    SET GLOBAL query_cache_size = 41980;
    SET GLOBAL VARIABLE query_cache_size = 41980;
    SET VARIABLE GLOBAL query_cache_size = 41980;
    None of the above

  1. "CREATE DATABASE db_name" statement is used to create database.
    True
    False

  1. Displaying query results vertically is not possible in MySQL.
    True
    False

Post Your Question
Social Sharing
Search