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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum


  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();

    View Answer

    Workspace

    Discuss Discuss in Forum


  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

    View Answer

    Workspace

    Discuss Discuss in Forum