Menu
Home / CSE MCQs / MySQL Database MCQs :: MySQL Database Tables and Datatypes

CSE MCQs :: MySQL Database MCQs

MySQL Database MCQs - MySQL Database Query Clauses
MySQL Database MCQs - MySQL Database Query Clauses
MySQL Database MCQs - MySQL Database Select Statement
MySQL Database MCQs - MySQL Database Nulls and Conditions
MySQL Database MCQs - MySQL Database Tables and Datatypes
  1. The maximum length of the char columns is
    2. A.
    255 bytes
    B.
    65, 535 bytes
    C.
    256 bytes
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  2. Which data type is more suitable for storing "documents in Mysql?
    3. A.
    Varchar
    B.
    Longtext
    C.
    Mediumtext
    D.
    Either a or b

    View Answer

    Workspace

    Discuss Discuss in Forum

  3. Is "Datetime and "Timestamp are same data type?
    4. A.
    Yes
    B.
    No
    C.
    Depends
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  4. In the following query, what does "person_id stands for?

    CREATE TABLE person
       (person_ id SMALLINT UNSIGNED,
       fname VARCHAR(20),
       lname VARCHAR(20) ,
       CONSTRAINT pk_person PRIMARY KEY (person_id));
    5. A.
    Normal attribute of the table
    B.
    Super key
    C.
    Composite key
    D.
    Primary key

    View Answer

    Workspace

    Discuss Discuss in Forum

  5. Which Clause is used to select a particular row from the set of row in an existing table?
    6. A.
    WHERE
    B.
    FROM
    C.
    ALTER
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  6. In the following query "person_id can be

    SELECT person_id, fname,l name, Birth_data FROM person
       WHERE person_id=1;
    7. A.
    Only Primary Key
    B.
    Primary Key or any other Attribute
    C.
    Only Attribute but not a primary Key
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  7. "INSERT is same as "UPDATE ?
    8. A.
    NO
    B.
    YES
    C.
    May be
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  8. Which command is used for the table definition in Mysql?
    9. A.
    DESC table_name;
    B.
    DESC table_name
    C.
    DESC
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

  9. Which command is used on Mysql command line tool to return to window command shell?
    10. A.
    exit
    B.
    exit;
    C.
    exit()
    D.
    exit();

    View Answer

    Workspace

    Discuss Discuss in Forum

  10. Which command is used for taking "server side help in Mysql command line tool
    11. A.
    /h
    B.
    /c
    C.
    /e
    D.
    None of the mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum

Java Programming Questions and Answers Interview Questions and Answers