MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 23 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What does CGI stand for? |
| A. | Computer Gateway Interface |
| B. | Common Gateway Interface |
| C. | Computer Generated Interface |
| D. | Common Generated Interface |
| Answer» C. Computer Generated Interface | |
| 2. |
What is the number of attributes in the following SQL table? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 30 |
| Answer» C. 3 | |
| 3. |
How many of the following do not return rows? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» B. 1 | |
| 4. |
How many among the following use NULL to indicate failure? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» D. 3 | |
| 5. |
What returns a string containing an error message? |
| A. | mysql_error() |
| B. | mysql_errno() |
| C. | mysql_sqlstate() |
| D. | mysql_close() |
| Answer» B. mysql_errno() | |
| 6. |
How many among the following does not return a value? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3 |
| Answer» C. 2 | |
| 7. |
The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» C. May be True or False | |
| 8. |
What does mysql_fetch_row() return? |
| A. | integer |
| B. | float |
| C. | structure |
| D. | pointer |
| Answer» E. | |
| 9. |
What does mysql_query() return on failure? |
| A. | 0 |
| B. | 1 |
| C. | -1 |
| D. | a non-zero |
| Answer» E. | |
| 10. |
The one that is more restrictive is __________ |
| A. | mysql_query() |
| B. | mysql_real_query() |
| C. | same |
| D. | machine dependent |
| Answer» B. mysql_real_query() | |
| 11. |
What is preferred when stored procedures are not being used? |
| A. | CLIENT_MULTI_STATEMENTS |
| B. | mysql_set_server_option() |
| C. | any of the two |
| D. | neither of the two |
| Answer» D. neither of the two | |
| 12. |
‘character_set_database’ represents the character set used by the default database. |
| A. | True |
| B. | False |
| C. | May be True or False |
| D. | Can't say |
| Answer» B. False | |
| 13. |
The permitted value type for the variable ‘character_set_client’ is _____________ |
| A. | integer |
| B. | float |
| C. | double |
| D. | string |
| Answer» E. | |
| 14. |
WHAT_IS_THE_PERL_DBI??$ |
| A. | database inheritance |
| B. | database integrity |
| C. | database interface |
| D. | database isolation |
| Answer» D. database isolation | |
| 15. |
What_is_the_default_path_to_perl_in_Unix?$ |
| A. | /usr/bin/perl |
| B. | /usr/bin |
| C. | /usr/perl |
| D. | /usr/perl/bin |
| Answer» B. /usr/bin | |
| 16. |
What is the shebang line? |
| A. | ! |
| B. | ! |
| C. | $ |
| D. | $ |
| Answer» B. ! | |
| 17. |
The line that is written at the top of the script to write a Perl script using CGI.pm is ___________ |
| A. | use this CGI |
| B. | put CGI |
| C. | use CGI |
| D. | include CGI |
| Answer» D. include CGI | |
| 18. |
What is the full form of CGI in System Variables? |
| A. | Computer Gateway Interface |
| B. | Common Gateway Interface |
| C. | Computer Generated Interface |
| D. | Common Generated Interface |
| Answer» C. Computer Generated Interface | |
| 19. |
Which module links DBI to the web? |
| A. | CGI.pn |
| B. | CGI.pem |
| C. | CGI.pm |
| D. | CGI.po |
| Answer» D. CGI.po | |
| 20. |
Which string function returns the index of the first occurrence of substring? |
| A. | INSERT() |
| B. | INSTR() |
| C. | INSTRING() |
| D. | INFSTR() |
| Answer» C. INSTRING() | |
| 21. |
‘character_set_database’ represents the character set used by the default database.$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 22. |
The permitted value type for the variable ‘character_set_client’ is _____________$ |
| A. | integer |
| B. | float |
| C. | double |
| D. | string |
| Answer» E. | |
| 23. |
Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory? |
| A. | basedir |
| B. | back_log |
| C. | big_tables |
| D. | bind_address |
| Answer» D. bind_address | |