My Report

MySQL Mock Test 8


Correct Answer: 2 points | Wrong: -1 point
Grades: A* (100% score) | A (80%-99%) | B (60%-80%) | C (40%-60%) | D (0%-40%)
advertisement
 10%

Question 1 of 10

1. What is the variable that is a handle to a database object?

Question 1 of 10

Question 2 of 10

2. The grant table scope columns that is case insensitive is _____________

Question 2 of 10

Question 3 of 10

3. The metadata log is _______________

Question 3 of 10

Question 4 of 10

4. MySQL Enterprise Backup records details of each backup in _____________

Question 4 of 10

Question 5 of 10

5. The statement that suspends the replication related activity of the slave server is _____________

Question 5 of 10

Question 6 of 10

6. Which of these grant table scope columns is case insensitive?

Question 6 of 10

Question 7 of 10

7. CHECK TABLE works with how many of the following?

MyISAM, ARCHIVE, CSV

Question 7 of 10

Question 8 of 10

8. Which table lists the accounts and the databases for which the privileges are provided?

Question 8 of 10

Question 9 of 10

9. Which program converts binary log files to statements in text form?

Question 9 of 10

Question 10 of 10

10. What is the best datatype for a column that is expected to store values up to 2 million?

Question 10 of 10


 

Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.