MySQL
 

  1. Question: To Displaying Results Vertically

    A
    mysql>select * from (db name)\G

    B
    mysql>select * from (db name)\G;

    C
    mysql>select * from (db name)\g

    D
    mysql>select * from (db name)\g;

    Note: Not available
    1. Report

  2. Question: To delete a database we use:

    A
    mysql>DROP database (database name);

    B
    mysqladmin>DROP database (database name);

    C
    mysql>DROP database (database name)

    D
    mysql>DROP database (database name):

    Note: Not available
    1. Report

  3. Question: We can view a list of the tables made available to a database with the show TABLES staement:

    A
    mysql>SHOW TABLES;

    B
    mysql>OPEN TABLES;

    C
    mysql>SHOW TABLES:

    D
    mysql>SHOW TABLE;

    Note: Not available
    1. Report

  4. Question: What is the largest non-binary string representation?  

    A
    LONGBLOB

    B
    LONGTEXT

    C
    MEDIUMBLOB

    D
    MEDIUMTEXT

    Note: Not available
    1. Report

  5. Question: What is the second largest binary string representation?  

    A
    LONGBLOB

    B
    LONGTEXT

    C
    MEDIUMBLOB

    D
    MEDIUMTEXT

    Note: Not available
    1. Report

  6. Question: What is the second-largest non-binary string representation?

    A
    LONGTEXT

    B
    LONTBLOB

    C
    MEDIUMBLOB

    D
    MEDIUMTEXT

    Note: Not available
    1. Report

  7. Question: What is the third-largest binary representation?

    A
    TEXT

    B
    BLOB

    C
    LONG

    D
    MEDIUM

    Note: Not available
    1. Report

  8. Question: What is the third-largest non-binary representation?

    A
    TEXT

    B
    BLOB

    C
    LONGBLOB

    D
    MEDIUMBLOB

    Note: Not available
    1. Report

  9. Question: What is the smallest binary representation?

    A
    LONGBLOB

    B
    LONGTEXT

    C
    TINYBLOB

    D
    TINYTEXT

    Note: Not available
    1. Report

  10. Question: What is the smallest non-binary representation?

    A
    LONGNBLOB

    B
    LONGTEXT

    C
    TINYBLOB

    D
    TINYTEXT

    Note: Not available
    1. Report
First678910Last
/16
Copyright © 2025. Powered by Intellect Software Ltd