MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 11 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. |
The line which 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 | |
| 2. |
Which of the following columns is not returned by ‘OPTIMIZE TABLE’? |
| A. | Table |
| B. | Op |
| C. | Msg_type |
| D. | Msg_txt |
| Answer» E. | |
| 3. |
CGI.PM_ALSO_SUPPORTS_AN_OBJECT_ORIENTED_STYLE_OF_USE.?$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
There_can_be_more_than_one_column_per_table_with_the_AUTO_INCREMENT_attribute.$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
The line which 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 | |
| 6. |
What is a synonym for CHARACTER SET? |
| A. | CSET |
| B. | CHSET |
| C. | CHARSET |
| D. | CHCSET |
| Answer» D. CHCSET | |
| 7. |
The binary protocol is easy to use. |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
REPAIR TABLE does not work for _____________ |
| A. | MyISAM |
| B. | ARCHIVE |
| C. | InnoDB |
| D. | CSV |
| Answer» D. CSV | |
| 9. |
Which of the following columns is not returned by ‘OPTIMIZE TABLE’?$ |
| A. | Table |
| B. | Op |
| C. | Msg_type |
| D. | Msg_txt |
| Answer» E. | |
| 10. |
What performs a key distribution analysis and stores the distribution for the named table or tables? |
| A. | ANALYZE TABLE |
| B. | CHECK TABLE |
| C. | CHECKSUM TABLE |
| D. | OPTIMIZE TABLE |
| Answer» B. CHECK TABLE | |
| 11. |
The recovery of data changes made since a given point in time is called _____________ |
| A. | decremental |
| B. | incremental |
| C. | close |
| D. | clear |
| Answer» C. close | |