SQL MCQ Quiz Hub

SQL MCQ SET 15

Choose a topic to test your knowledge and improve your SQL skills

1. Which MySQL statement is used to find out which character sets are available?




2. Which collations does this MySQL statement list?




3. Which statement is used to show the server’s current character set and collation settings?




4. What does UTF stand for int utf8?




5. Prior to MySQL 6.0, utf8 was ___________




6. Post MySQL 6.0, utf8 was ___________




7. What is generally used as a synonym for CHARACTER SET?




8. Which statement is used to select a default database?




9. Which keyword is the synonym for DATABASE?




10. Which keyword is used to create a database?




11. The file created by the server to store the database attributes is __________




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




13. MySQL stores the database character set and collation attributes in the file _________




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




15. Which statement makes changes to the database’s global attributes?




16. Which statement is used to remove indexes on tables?




17. Which storage engine is not available in MySQL 5.0?




18. The default storage engine used is ____________




19. What is the name of the format file for a table named my_tbl?




20. Which keyword is used to create a table as a temporary copy of itself?




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




22. The default index type for MEMORY tables is __________




23. The statement to change the table name is __________




24. The general term for information about databases and the objects in MySQL is _________




25. Which statement is used to determine the storage engine for individual tables?




26. Which disk data does FILES table in INFORMATION_SCHEMA store?




27. The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?




28. Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?




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




30. The command which lists databases managed by the server is _____________




31. The option in mysqlshow to show information about indexes in a table is _________




32. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?




33. The join where all possible row combinations are produced is called _________




34. The clause that filters JOIN results is called _________




35. CROSS JOIN and JOIN are similar to __________




36. The left and right joins are also known as __________




37. What is joining a table to itself called?




38. In which join all the rows from the left table appear in the output irrespective of the content of the other table?




39. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________




40. The facility that allows nesting one select statement into another is called __________




41. Which subquery returns a single value?




42. Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?




43. The ALL subquery performs which operation?




44. Which of these operators perform similar operations like ALL and ANY?




45. Which operators test whether a subquery returns any rows?




46. Which subquery cannot be executed by itself as a separate statement?




47. Which of these operators does not perform relative-value comparisons?




48. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?




49. What is ‘xyz’ in the following SQL statement?




50. Which keyword used with UNION does not retain duplicate rows?