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

CSE MCQs :: MySQL Database MCQs

  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

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

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

  7. 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));
  8. A.
    Normal attribute of the table
    B.
    Super key
    C.
    Composite key
    D.
    Primary key

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

  11. In the following query "person_id can be

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

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

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

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

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