SQL MCQ Quiz Hub

SQL MCQ SET 11

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

1. What does mysql_fetch_row() return?




2. Hexadecimal values assigned to user variables are treated as _______




3. What is the type of Audit_log_events system variable?




4. The option that enables multiple-statement execution is ______




5. What does mysql_query() return on failure?




6. Which statement upgrades the database directory name encoding?




7. The statement that alters an existing event to have the given definition is ______




8. What sets up an association between one or more MyISAM tables and the named key cache?




9. Which statement can produce the same output as ‘SHOW COLUMNS’?




10. The option that executes all SQL statements in a SQL script irrespective of the number of errors is ______________




11. The clause that is used to display information that matches a given pattern is _____________




12. The header that should be included first is ________________




13. What does mysql_init() return?




14. The statement that constructs a branching flow-control construct is _____________




15. Which statement terminates the execution of a function?




16. Association between one or more MyISAM tables and the named key cache is set by _____________




17. Which statement exits a labeled flow-control construct?




18. What is the exec_stmt_ssl written in?




19. What does ‘mysql_query()’ return on failure?




20. What can be used in place of MYSQL_SERVER_VERSION?




21. What can be used interchangeably with MYSQL_VERSION_ID?




22. Which of these is not a comment specifying construct?




23. What sets the association between one or more MyISAM tables and the named key cache?




24. The statement that exits a labeled flow-control construct is _____________




25. The option that executes all SQL statements in a SQL script irrespective of the number of errors is _____________




26. The option that is necessary to compile a C program having math functions is _____________




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




28. The file that can be used to execute multiple compile statements is _________________




29. What is the meaning of “SELECT” clause in Mysql?




30. Which of the following clause is evaluated in the last by database server?




31. Can “SELECT” clause be used without the clause “FROM”?




32. Which clause is mandatory with clause “SELECT” in Mysql?




33. Which among the following can also be included with “SELECT” clause while writing query in Mysql?




34. What is the need of “column Aliases” in “SELECT” clause?




35. Which Keyword is used to remove duplicate rows in the result set?




36. Which among the following is an optional Keyword?




37. How can we define the clause “FROM” in Mysql?




38. Which of the following table exist in Mysql?




39. “CREATE TABLE …” command is used to create which type of table in Mysql?




40. “CREATE VIEW …” command is used to create which type of table in Mysql?




41. What is the meaning of “Temporary Tables” in Mysql?




42. “SELECT” clause cannot be used without which clause in Mysql?




43. Which of the following statements is/are correct with respect to “VIEW”?




44. Which command is used to create “Temporary tables” in MySQL?




45. What is the use of “VIEW” in Mysql?




46. What will be the output of the following MySQL statement “true AND Null”?




47. What will be the output of the following MySQL statement “false AND Null”?




48. What will be the output of the following MySQL statement “Null AND Null”?




49. What will be the output of the following MySQL statement “true OR Null”?




50. What will be the output of the following MySQL statement “false OR Null”?