SQL MCQ Quiz Hub

SQL MCQ SET 4

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

1. The return value from operations returning a row count is ______




2. Which mode of search is the search string parsed into words and the search looks for rows?




3. The indicator of presence/absence of a word in search is used in the mode _____




4. The numbers that are prefixed with ‘0x’ are in base ______




5. What is the escape sequence for carriage return?




6. What is the datatype for single precision floating point number?




7. RTF refers to ________




8. The function returning an array of row values is ______________




9. The function returning reference to hash of row values is ______________




10. fetchrow_hashref() returns reference to hash of row values keyed by _____




11. The function returning reference to array of row values is ______




12. Illegal values converted to the appropriate ‘zero’ value for ________




13. The column attribute provides unique numbers for identification is _______




14. The module that links DBI to the web is ________




15. CGI stands for ________




16. Which line is written at the top of the script to write a Perl script using CGI.pm?




17. By default, the AUTO_INCREMENT sequences begin at __________




18. What does the expression ’12 DIV 5′ evaluate to?




19. What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is disabled?




20. The AUTO_INCREMENT column attribute is best used with ______________




21. The datatype best suited to store currency values is ______________




22. The output from PHP is __________




23. PHP variables are preceded by __________




24. The datatype best suited to store currency values is __________




25. What returns a result to the client?




26. What is defined to execute when the table is modified only?




27. Which statement is used to produce a stored function?




28. The number of values that can be returned from a given stored function is ______________




29. The statement used to create a trigger is ______________




30. In PHP, if $a represents an array with numeric indices, how is the first element accessed?




31. In PHP, which operator is used to access property of an object?




32. DBI scripts are located in the directory ______________




33. A stored program associated with a schedule is _____________




34. The line used to turn on the event scheduler is ______________




35. What is the creation of a stored program similar to?




36. When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________




37. What is the maximum number of indexes on MyISAM table?




38. The hub of a MySQL installation is _______




39. The tool for copying databases is _______




40. Which statement is used to check how MySQL would execute a SELECT query?




41. What is used to perform an analysis of key values by the server?




42. The function used to convert an int to string is ________




43. The function used to convert a string to an int is ____




44. Without LOCAL, LOAD DATA is ____




45. The log in which data changes received from a replication master server are written are ____




46. Which of these is the metadata log?




47. The max_binlog_cache_size system variable has default size _____




48. The system variable controls the size of the table cache _______




49. Which of these exports table definitions and contents?




50. MySQL uses security based on ACL which stands for ______