1. | Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory? |
Answer: (c).big_tables
|
2. | The permitted value type for the variable ‘character_set_client’ is _____________ |
Answer: (d).string
|
3. | ‘character_set_database’ represents the character set used by the default database. |
Answer: (a).True
|
4. | Which string function returns the index of the first occurrence of substring? |
Answer: (b).INSTR()
|
5. | Which module links DBI to the web? |
Answer: (c).CGI.pm
|
6. | What does CGI stand for? |
Answer: (b).Common Gateway Interface
|
7. | The line that is written at the top of the script to write a Perl script using CGI.pm is ___________ |
Answer: (c).use CGI
|
8. | What is the shebang line? |
Answer: (a).#!
|
9. | Which of these is a read only variable? |
Answer: (a).error_count
|
10. | Which variable when set to 1 would enable foreign key checking for InnoDB tables? |
Answer: (c).foreign_key_checks
|