MySQL Server, MySQL

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: ______ is a robust transactional stroge engine.
A
InnoDB

Note: Not available
1. Report
Question: The ______ storage engine stores table data in a comma-separated format similar to that supported by many applications.
A
CSV

Note: Not available
1. Report
Question: ______ storage engine as a basic template for understanding how these engines are created.
A
EXAMPLE

Note: Not available
1. Report
Question: How do I find out all databases starting with ‘test to which I have access to?
A
SHOW DATABASES LIKE ‘%test%’;

B
SHOW DATABASES LIKE ‘%test;

C
SHOW DATABASES LIKE ‘'test'%’;

D
SHOW DATABASES LIKE ‘test%’;

Note: Not available
1. Report
Question: When do we use a HAVING clause?
A
To limit the output of a query

B
To limit the output of a query using an aggregate function only

C
When GROUP by is used

D
all

Note: Not available
1. Report
Question: USE keyword is used to select a _____
A
Table

B
Column

C
Database

D
All

Note: Not available
1. Report

Question: To show databases we use the following command: