MySQL Mock Test 1 - Sanfoundry

10%

Question 1 of 10

1. Which statement is used to see the definition for an existing database?

SHOW CREATE DATABASE

SHOW DATABASE

SHOW CREATE

SHOW CREATE DATABASE TABLE

Question 1 of 10

Question 2 of 10

2. To create a database only if it doesn't already exist, which clause is used?

CREATE EXISTS

EXISTS IF

IF NOT EXISTS

IF EXISTS

Question 2 of 10

Question 3 of 10

3. Case sensitivity in SQL statements does not vary for different operating systems of the machine on which the server is running.

True

False

Question 3 of 10

Question 4 of 10

4. CROSS JOIN and JOIN are similar to __________

OUTER JOIN

CARTESIAN JOIN

NATURAL JOIN

INNER JOIN

Question 4 of 10

Question 5 of 10

5. In UNIX, the name of the option file is __________

.my.opt

.my.cnf

.my.opc

.my.ini

Question 5 of 10

Question 6 of 10

6. Which of the following clauses is used to display information that match a given pattern?

WHERE

SAME

Question 6 of 10

Question 7 of 10

7. The default storage engine used is ____________

NDB

MyISAM

ARCHIVE

EXAMPLE

Question 7 of 10

Question 8 of 10

8. Which table stores information about the threads executing within the server?

THREADSLIST

PROCESS

LIST

PROCESSLIST

Question 8 of 10

Question 9 of 10

9. Which storage engine enables to access tables from a MySQL server managed by another server?

FEDERATED

EXAMPLE

MyISAM

InnoDB

Question 9 of 10

Question 10 of 10

10. Which collations does this MySQL statement list?

	SHOW COLLATION LIKE 'utf8%'

names ending with utf8

names containing utf8% anywhere

names ending in utf8%

names beginning with utf8

Question 10 of 10