1. Question: Which of the following are true about MySqL Client?

    A
    capable of managing almost every conceivable aspect of a MySQL server, including creating, modifying, and deleting tables and databases

    B
    Capable of Database backup, Restore etc

    C
    Viewing Configuration Variables and System Status

    D
    none

    Note: Not available
    1. Report
  2. Question: The mysql clients is an extremely useful?

    A
    sql shell

    B
    mysql shell

    C
    programming shell

    D
    object shell

    Note: Not available
    1. Report
  3. Question: Which command use to view all the tables?

    A
    View Tables

    B
    Show Tables

    C
    Display Tables

    D
    data Tables

    Note: Not available
    1. Report
  4. Question: The syntex of connection options

    A
    %>mysql -h hostname -u username -p -D databasename

    B
    %>mysql -h hostname -p username -u -D databasename

    C
    %>mysql -D databasename -p username -u -h hostname

    D
    All

    Note: Not available
    1. Report
  5. Question: To Displaying Results Vertically we use

    A
    mysql>use mysql; mysql>select * from db\G

    B
    mysql>use mysql; mysql>select * from db\G;

    C
    mysql>use mysql; mysql>select * from db\g

    D
    mysql>use mysql; mysql>select * from db\g;

    Note: Not available
    1. Report
  6. Question: To Logging Queries we use

    A
    mysql>\T file name (text)

    B
    mysql>\t file name (text)

    C
    mysql>sourse drive name\ file name (text)

    D
    None

    Note: Not available
    1. Report
  7. Question: phpMyAdmin offers following options:

    A
    phpMyAdmin is browser based

    B
    Administrators can exercise complete control over user privileges, passwords, and resource usage, as well as create, delete, and even copy user accounts.

    C
    Real-time interfaces are available for viewing uptime information, query and server traffic statistics, server variables, and running processes.

    D
    phpMyAdmin offers a highly optimized point-and-click interface that greatly reduces the possibility of user-initiated errors.

    Note: Not available
    1. Report
  8. Question: mysqlslap allowing you to test performance by executing SQL queries while emulating a scenario where multiple clients are accessing the system.

    A
    True

    B
    False

    Note: Not available
    1. Report
  9. Question: To stop MySQL server with mysqladmin client we provide the following command from shell/command prompt: %>mysqladmin -u root -p stop

    A
    True

    B
    False

    Note: Not available
    1. Report
  10. Question: To disable logging at any time, we use ______ option in MySQL.

    A
    notee,\t

    Note: Not available
    1. Report