MySQL Server, MySQL

Question: Which of the following are MySql Features?
A
Replication

B
Query Caching

C
Storage

D
Security

Note: Not available
1. Report
Question: What are the storage engine of MySql?
A
HDD

B
InnoDB

C
MyISM

D
Backup

Note: Not available
1. Report
Question: Where is the greatest use of mysql server?
A
Full text indexing and searching

B
Query caching

C
Replication

D
Security

Note: Not available
1. Report
Question: How to show MySQL variables?
A
show variables

B
view variables

C
save variables

D
All

Note: Not available
1. Report
Question: How to view databases from MySQL server?
A
view database

B
show databases

C
describe database

D
show database

Note: Not available
1. Report
Question: To view a list of all existing databases
A
View Databases

B
Show Databases

C
none

D
Display Databases

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: 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
Question: MySQL offers many types of mechanisms for managing data, known as ______ engines.
A
storage

Note: Not available
1. Report

Question: Which of the following are MySql Features?