Home > Databases > Quizzes > MySQL Basics Practice Test: MySQL Programs Using Perl DBI
MySQL Basics Practice Test: MySQL Programs Using Perl DBI
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 81% Most missed: “What allows nesting one select statement into another?”

Quiz on Perl script characteristics, Perl DBI.

The DBI module offers two methods for extracting data from a MySQL database: fetchrow_array() and fetchrow_arrayref(). 
You can use the DBI module to interface with MySQL. 

MySQL Basics Practice Test: MySQL Programs Using Perl DBI
Time left 00:00
25 Questions

1. Which mode of search is the search string parsed into words and the search looks for rows?
2. The variable that is a handle to a database object is ______________
3. CGI.pm also supports an object oriented style of use.
4. RTF refers to ______________
5. Which of these operators does not perform relative value comparisons?
6. What does the expression ’12 DIV 5′ evaluate to?
7. The non handle array representing a row of values is ______________
8. The column attribute provides unique numbers for identification is ______________
9. Which variable returns code from operations that return true or false?
10. The generic handle whose meaning depends on context is ______________
11. The statement to remove indexes on tables is ______________
12. The default path to perl in Unix is ______________
13. Issuing ‘SELECT’ on a MERGE table is like _____________
14. The Perl DBI is ______________
15. What is the maximum non zero value for FLOAT?
16. The return value from operations returning a row count is ______________
17. CGI stands for ______________
18. Illegal values converted to the appropriate ‘zero’ value for ______________
19. The datatype best suited to store currency values is ______________
20. What is the datatype for single precision floating point number?
21. The AUTO_INCREMENT column attribute is best used with ______________
22. The numbers that are prefixed with ‘0x’ are in base __________
23. What is the escape sequence for carriage return?
24. Hexadecimal numbers can be used in scientific notation.
25. Foreign keys can handle deletes and updates.