MySQL mcq questions and answers | MySQL MCQs Page-3 section-9

Section 1 Section 2 Section 3 Section 4 Section 5 Section 6 Section 7 Section 8 Section 9 Section 10 Section 11 Section 12

21.
Which clause is used to "sort the rows of the final result set by one or more columns"?

A. HAVING

B. ORDER BY

C. WHERE

D. FROM

Answer & Solution Discuss in Board Save for Later

22.
Which option executes all SQL statements in a SQL script irrespective of the number of errors?

A. -ensure

B. -violent

C. -force

D. -run

Answer & Solution Discuss in Board Save for Later

23.
The name of the option file in Unix is . . . . . . . .

A. .my.cnf

B. .my.ini

C. .my.opt

D. .my.opc

Answer & Solution Discuss in Board Save for Later

24.
The facility that allows nesting one select statement into another is . . . . . . . .

A. nesting

B. binding

C. subquerying

D. encapsulating

Answer & Solution Discuss in Board Save for Later

25.
Which privilege is enabled to create of alter a stored function?

A. SUPER

B. PRIOR

C. TOP

D. SUPERIOR

Answer & Solution Discuss in Board Save for Later

26.
CROSS JOIN and JOIN are similar to . . . . . . . .

A. INNER JOIN

B. NATURAL JOIN

C. OUTER JOIN

D. CARTESIAN JOIN

Answer & Solution Discuss in Board Save for Later

27.
The statement that performs key distribution analysis and stores the distribution for the named tables is . . . . . . . .

A. CHECK TABLE

B. ANALYZE TABLE

C. CHECKSUM TABLE

D. OPTIMIZE TABLE

Answer & Solution Discuss in Board Save for Later

28.

How many of these can replace ‘level’ in ‘-myisam-recover = level’?

BACKUP, FORCE, QUICK

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

29.
Which option is used for specifying the executable name while compiling with gcc?

A. -e

B. -o

C. -a

D. -b

Answer & Solution Discuss in Board Save for Later

30.
Which mode tells the server to recognize || as the string concatenation operator?

A. PIPES_AS_CONCAT

B. ORS_AS_CONCAT

C. DOUBLE_PIPE_AS_CONCAT

D. LOGIC_OR_AS_CONCAT

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

21.
Which clause is used to "sort the rows of the final result set by one or more columns"?

Answer & Solution

22.
Which option executes all SQL statements in a SQL script irrespective of the number of errors?

Answer & Solution

23.
The name of the option file in Unix is . . . . . . . .

Answer & Solution

24.
The facility that allows nesting one select statement into another is . . . . . . . .

Answer & Solution

25.
Which privilege is enabled to create of alter a stored function?

Answer & Solution

26.
CROSS JOIN and JOIN are similar to . . . . . . . .

Answer & Solution

27.
The statement that performs key distribution analysis and stores the distribution for the named tables is . . . . . . . .

Answer & Solution

28.
How many of these can replace ‘level’ in ‘-myisam-recover = level’?

`BACKUP, FORCE, QUICK`

Answer & Solution

29.
Which option is used for specifying the executable name while compiling with gcc?

Answer & Solution

30.
Which mode tells the server to recognize || as the string concatenation operator?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

21. Which clause is used to "sort the rows of the final result set by one or more columns"?

Answer & Solution

22. Which option executes all SQL statements in a SQL script irrespective of the number of errors?

Answer & Solution

23. The name of the option file in Unix is . . . . . . . .

Answer & Solution

24. The facility that allows nesting one select statement into another is . . . . . . . .

Answer & Solution

25. Which privilege is enabled to create of alter a stored function?

Answer & Solution

26. CROSS JOIN and JOIN are similar to . . . . . . . .

Answer & Solution

27. The statement that performs key distribution analysis and stores the distribution for the named tables is . . . . . . . .

Answer & Solution

28. How many of these can replace ‘level’ in ‘-myisam-recover = level’? BACKUP, FORCE, QUICK

Answer & Solution

29. Which option is used for specifying the executable name while compiling with gcc?

Answer & Solution

30. Which mode tells the server to recognize || as the string concatenation operator?

Answer & Solution

Read More Section(MySQL Miscellaneous)

21.
Which clause is used to "sort the rows of the final result set by one or more columns"?

22.
Which option executes all SQL statements in a SQL script irrespective of the number of errors?

23.
The name of the option file in Unix is . . . . . . . .

24.
The facility that allows nesting one select statement into another is . . . . . . . .

25.
Which privilege is enabled to create of alter a stored function?

26.
CROSS JOIN and JOIN are similar to . . . . . . . .

27.
The statement that performs key distribution analysis and stores the distribution for the named tables is . . . . . . . .

28.
How many of these can replace ‘level’ in ‘-myisam-recover = level’?

`BACKUP, FORCE, QUICK`

29.
Which option is used for specifying the executable name while compiling with gcc?

30.
Which mode tells the server to recognize || as the string concatenation operator?