MySQL

Question: Which options are same?
A
%>mysqladmin -u root -p variables

B
mysql>SHOW VARIABLES;

C
MYSQLadmin>show databases;

D
mysql>SHOW Tables;

Note: Not available
1. Report
Question: The max_connections parameter determines
A
the maximum permitted number of simultaneous database connections.

B
the minimum permitted number of simultaneous database connections.

C
Each time that query execution time surpasses this limit

D
None

Note: Not available
1. Report
Question: MySQL’s storage engines, namely
A
ARCHIVE

B
InnoDB

C
MyISAM

D
XLS

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: MySQL’s supported data types. To facilitate later reference, these data types are broken into three categories:
A
date and time

B
numeric

C
textual

D
all

Note: Not available
1. Report
Question: Three MyISAM formats are:
A
static

B
dynamic

C
compressed

D
only static and dynamic

Note: Not available
1. Report
Question: InnoDB tables are ideal for the following scenarios, among others:
A
Transactions

B
Automated crash recovery

C
Transactions

D
All

Note: Not available
1. Report

First Prev 2 3 4 5 6 Next Last

Question: Which options are same?

Question: The max_connections parameter determines

Question: MySQL’s storage engines, namely

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: MySQL’s supported data types. To facilitate later reference, these data types are broken into three categories:

Question: Three MyISAM formats are:

Question: InnoDB tables are ideal for the following scenarios, among others: