MySQL

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: To view MySQL's configuration parameters with MySQL client we use command ______.
A
show variables;

Note: Not available
1. Report
Question: Default allowable simultaneous connections in MySQL is 100.
A
True

B
False

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 show databases we use the following command:
A
mysql>SHOW DATABASES;

B
mysql>SHOW DATABASES:

C
mysql>SHOW VARIABLES;

D
mysql>SHOW INFORMATION_SCHEMA;

Note: Not available
1. Report
Question: We can designate database as the default working database by "using" it, done with which of the the following command?
A
USE command

B
delete command

C
DROP command

D
CREATE command

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

First Prev 5 6 7 8 9 Next Last

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: To view MySQL's configuration parameters with MySQL client we use command ______.

Question: Default allowable simultaneous connections in MySQL is 100.

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 show databases we use the following command:

Question: We can designate database as the default working database by "using" it, done with which of the the following command?

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