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

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.
The line that is not used to turn on the event scheduler is . . . . . . . .

A. event_scheduler = ON

B. eventscheduler = ON

C. event_scheduler_ON

D. events_scheduler_ON

Answer & Solution Discuss in Board Save for Later

22.
What will be the storage pattern for "float(4,2)" in Mysql?

A. Total of four digits, two to the left of decimal and two to the right of decimal

B. Total of six digits

C. Total of four digits, not distributed uniformly

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

23.

To how many of the following does the prepared-statement API apply to?

CREATE TABLE, DELETE, DO, INSERT

A. 1

B. 2

C. 3

D. 4

Answer & Solution Discuss in Board Save for Later

24.
Which program reads the statement from a binary log?

A. mysql_config

B. mysqlbinlog

C. mysqldump

D. mysqlimport

Answer & Solution Discuss in Board Save for Later

25.
The statement to change the table name is . . . . . . . .

A. CHANGE

B. CHANGENAME

C. CHANGENM

D. RENAME

Answer & Solution Discuss in Board Save for Later

26.
FULLTEXT indexes can be created only for . . . . . . . .

A. MyISAM

B. InnoDB

C. MEMORY

D. TRANSITION

Answer & Solution Discuss in Board Save for Later

27.

What will be the output of the following SQL statement?

SELECT  * FROM person
WHERE person_id=1;

A. Show all columns but only those rows which belongs to person_id=1

B. Show all columns and rows

C. Shows only columns person_id

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

28.
The statement used to select a default database is . . . . . . . .

A. USE

B. CREATE

C. DROP

D. SCHEMA

Answer & Solution Discuss in Board Save for Later

29.
Input can be validated in MySQL programs.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

30.
Keyword "ASC" and "DESC" cannot be used without which clause in Mysql?

A. ORDER BY

B. GROUP BY

C. SELECT

D. HAVING

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

21.
The line that is not used to turn on the event scheduler is . . . . . . . .

Answer & Solution

22.
What will be the storage pattern for "float(4,2)" in Mysql?

Answer & Solution

23.
To how many of the following does the prepared-statement API apply to?

`CREATE TABLE, DELETE, DO, INSERT`

Answer & Solution

24.
Which program reads the statement from a binary log?

Answer & Solution

25.
The statement to change the table name is . . . . . . . .

Answer & Solution

26.
FULLTEXT indexes can be created only for . . . . . . . .

Answer & Solution

27.
What will be the output of the following SQL statement?

`SELECT * FROM person WHERE person_id=1;`

Answer & Solution

28.
The statement used to select a default database is . . . . . . . .

Answer & Solution

29.
Input can be validated in MySQL programs.

Answer & Solution

30.
Keyword "ASC" and "DESC" cannot be used without which clause in Mysql?

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

21. The line that is not used to turn on the event scheduler is . . . . . . . .

Answer & Solution

22. What will be the storage pattern for "float(4,2)" in Mysql?

Answer & Solution

23. To how many of the following does the prepared-statement API apply to? CREATE TABLE, DELETE, DO, INSERT

Answer & Solution

24. Which program reads the statement from a binary log?

Answer & Solution

25. The statement to change the table name is . . . . . . . .

Answer & Solution

26. FULLTEXT indexes can be created only for . . . . . . . .

Answer & Solution

27. What will be the output of the following SQL statement? SELECT * FROM person WHERE person_id=1;

Answer & Solution

28. The statement used to select a default database is . . . . . . . .

Answer & Solution

29. Input can be validated in MySQL programs.

Answer & Solution

30. Keyword "ASC" and "DESC" cannot be used without which clause in Mysql?

Answer & Solution

Read More Section(MySQL Miscellaneous)

21.
The line that is not used to turn on the event scheduler is . . . . . . . .

22.
What will be the storage pattern for "float(4,2)" in Mysql?

23.
To how many of the following does the prepared-statement API apply to?

`CREATE TABLE, DELETE, DO, INSERT`

24.
Which program reads the statement from a binary log?

25.
The statement to change the table name is . . . . . . . .

26.
FULLTEXT indexes can be created only for . . . . . . . .

27.
What will be the output of the following SQL statement?

`SELECT * FROM person WHERE person_id=1;`

28.
The statement used to select a default database is . . . . . . . .

29.
Input can be validated in MySQL programs.

30.
Keyword "ASC" and "DESC" cannot be used without which clause in Mysql?