MySQL Client, MySQL

Question: To getting server statistics in MySQL we use ______ option.
A
status,\s

Note: Not available
1. Report
Question: To modify mysql prompt we use ______ option with -u, -p options from shell/command prompt using mysql client.
A
--prompt

Note: Not available
1. Report
Question: To stop error resulting beeping sound we use ______ option in MySQL.
A
--no-beep,-b

Note: Not available
1. Report
Question: To output query result in XML format in a file we use ______ option in MySQL.
A
--xml, -X

Note: Not available
1. Report
Question: You can execute multiple queries with ______ option by separating each with asemicolon using mysql client.
A
--execute,-e

Note: Not available
1. Report
Question: ______ mysql client option enables data compression when communicating between the client and server.
A
--compress, -C

Note: Not available
1. Report
Question: To backup table sturctures of all databases using mysqldump client, we use %>mysqldump -u root -p --all-database ______ > backup.sql
A
--no-data

Note: Not available
1. Report
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
Question: To backup both the structure and the data of two tables: book and user from test database to file "d:/backup.txt" we use %>mysqldump -u root -p ______ test book user>d:/backup.txt
A
--add-drop-table

Note: Not available
1. Report
Question: ______ utility offers a convenient means for determining which databases, tables, and columns exist on a given database server.
A
mysqlshow

Note: Not available
1. Report

First Prev 1 2 3 4 Next Last

Question: To getting server statistics in MySQL we use ______ option.

Question: To modify mysql prompt we use ______ option with -u, -p options from shell/command prompt using mysql client.

Question: To stop error resulting beeping sound we use ______ option in MySQL.

Question: To output query result in XML format in a file we use ______ option in MySQL.

Question: You can execute multiple queries with ______ option by separating each with asemicolon using mysql client.

Question: ______ mysql client option enables data compression when communicating between the client and server.

Question: To backup table sturctures of all databases using mysqldump client, we use %>mysqldump -u root -p --all-database ______ > backup.sql

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

Question: To backup both the structure and the data of two tables: book and user from test database to file "d:/backup.txt" we use %>mysqldump -u root -p ______ test book user>d:/backup.txt

Question: ______ utility offers a convenient means for determining which databases, tables, and columns exist on a given database server.