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

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

11.
What can be used to check for views that have been invalidated by DROP or ALTER operations?

A. CREATE TABLE

B. VERIFY TABLE

C. DETAILS TABLE

D. CHECK TABLE

Answer & Solution Discuss in Board Save for Later

12.

What will be the output of the following MySQL command?

SELECT *
FROM person
WHERE emp_id = NULL;

A. Only those columns whose emp_id is NULL

B. Only those columns whose emp_id is not NULL

C. No output

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

13.
The maximum collations a character set can have is . . . . . . . .

A. 0

B. 1

C. 2

D. more than 1

Answer & Solution Discuss in Board Save for Later

14.
Which option is necessary to compile a C program havin math functions?

A. -lm

B. -ln

C. -lp

D. -lq

Answer & Solution Discuss in Board Save for Later

15.

What will be the output of the following MySQL statement?

SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (fname, 1) =’F’;

A. Only those employees are selected whose first name started with 'F'

B. Only those employees are selected whose first name started with other than 'F'

C. All of the mentioned

D. None of the mentioned

Answer & Solution Discuss in Board Save for Later

16.

How many of the following shared tablespaces is bound by the OS file size limit?

MyISAM, InnoDB, TRANSACTION

A. 0

B. 1

C. 2

D. 3

Answer & Solution Discuss in Board Save for Later

17.
The command which lists databases managed by the server is . . . . . . . .

A. mysqld

B. mysqlshow

C. mysqllist

D. mysqldb

Answer & Solution Discuss in Board Save for Later

18.
What default value gets stored in columns of the table?

A. NULL

B. 0

C. 1

D. -1

Answer & Solution Discuss in Board Save for Later

19.
Which among the following tags belong to Data Manipulation language?

A. UPDATE

B. ALTER

C. MODIFY

D. All of the mentioned

Answer & Solution Discuss in Board Save for Later

20.
Triggers enable to enforce data integrity constraints.

A. True

B. False

Answer & Solution Discuss in Board Save for Later

1 2 3 4 5 6 7 8 9 10

11.
What can be used to check for views that have been invalidated by DROP or ALTER operations?

Answer & Solution

12.
What will be the output of the following MySQL command?

`SELECT * FROM person WHERE emp_id = NULL;`

Answer & Solution

13.
The maximum collations a character set can have is . . . . . . . .

Answer & Solution

14.
Which option is necessary to compile a C program havin math functions?

Answer & Solution

15.
What will be the output of the following MySQL statement?

`SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’;`

Answer & Solution

16.
How many of the following shared tablespaces is bound by the OS file size limit?

`MyISAM, InnoDB, TRANSACTION`

Answer & Solution

17.
The command which lists databases managed by the server is . . . . . . . .

Answer & Solution

18.
What default value gets stored in columns of the table?

Answer & Solution

19.
Which among the following tags belong to Data Manipulation language?

Answer & Solution

20.
Triggers enable to enforce data integrity constraints.

Answer & Solution

Read More Section(MySQL Miscellaneous)

MySQL mcq questions and answers | MySQL MCQs

11. What can be used to check for views that have been invalidated by DROP or ALTER operations?

Answer & Solution

12. What will be the output of the following MySQL command? SELECT * FROM person WHERE emp_id = NULL;

Answer & Solution

13. The maximum collations a character set can have is . . . . . . . .

Answer & Solution

14. Which option is necessary to compile a C program havin math functions?

Answer & Solution

15. What will be the output of the following MySQL statement? SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’;

Answer & Solution

16. How many of the following shared tablespaces is bound by the OS file size limit? MyISAM, InnoDB, TRANSACTION

Answer & Solution

17. The command which lists databases managed by the server is . . . . . . . .

Answer & Solution

18. What default value gets stored in columns of the table?

Answer & Solution

19. Which among the following tags belong to Data Manipulation language?

Answer & Solution

20. Triggers enable to enforce data integrity constraints.

Answer & Solution

Read More Section(MySQL Miscellaneous)

11.
What can be used to check for views that have been invalidated by DROP or ALTER operations?

12.
What will be the output of the following MySQL command?

`SELECT * FROM person WHERE emp_id = NULL;`

13.
The maximum collations a character set can have is . . . . . . . .

14.
Which option is necessary to compile a C program havin math functions?

15.
What will be the output of the following MySQL statement?

`SELECT emp_id, fname, lname FROM employee WHERE LEFT (fname, 1) =’F’;`

16.
How many of the following shared tablespaces is bound by the OS file size limit?

`MyISAM, InnoDB, TRANSACTION`

17.
The command which lists databases managed by the server is . . . . . . . .

18.
What default value gets stored in columns of the table?

19.
Which among the following tags belong to Data Manipulation language?

20.
Triggers enable to enforce data integrity constraints.