MySQL Client, MySQL

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
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
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
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
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
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
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
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
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
Question: To disable logging at any time, we use ______ option in MySQL.
A
notee,\t

Note: Not available
1. Report

First Prev 1 2 3 Next Last

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

Question: The mysql clients is an extremely useful?

Question: Which command use to view all the tables?

Question: The syntex of connection options

Question: To Displaying Results Vertically we use

Question: To Logging Queries we use

Question: phpMyAdmin offers following options:

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

Question: To stop MySQL server with mysqladmin client we provide the following command from shell/command prompt: %>mysqladmin -u root -p stop

Question: To disable logging at any time, we use ______ option in MySQL.