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 place where the server stores its databases and status files are called the data directory. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 2. |
What is the hub of a MySQL installation? |
| A. | mysqla |
| B. | mysqlb |
| C. | mysqlc |
| D. | mysqld |
| Answer» E. | |
| 3. |
HOW_MANY_OF_THESE_ARE_FOR_USE_WITH_ONLY_MYISAM_TABLES??$ |
| A. | |
| B. | 1 |
| C. | 2 |
| Answer» B. 1 | |
| 4. |
The_place_where_the_server_stores_its_databases_and_status_files_is_called_the_data_directory.$ |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
The mode of search in which the search string is parsed into words and the search looks for rows is ________________ |
| A. | Boolean mode |
| B. | Natural language |
| C. | Query expansion |
| D. | Cross mode |
| Answer» C. Query expansion | |
| 6. |
Functions are called and pointers to structures are used while using DBI API. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 7. |
What is the return value from operations returning a row count? |
| A. | $rc |
| B. | $rv |
| C. | $rows |
| D. | $ary |
| Answer» D. $ary | |
| 8. |
The option that suppresses output unless there are errors in the table is _____________ |
| A. | –silent |
| B. | –wild |
| C. | –suppress |
| D. | –noout |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®wild | |
| 9. |
Which program performs logical backups? |
| A. | mysqlimport |
| B. | mysqldump |
| C. | myslqpit |
| D. | mysqllogic |
| Answer» C. myslqpit | |
| 10. |
How is a delimited-text data file reloaded? |
| A. | mysqlexport |
| B. | mysqlimport |
| C. | mysqlexpand |
| D. | mysqltransfer |
| Answer» C. mysqlexpand | |
| 11. |
How is the binary log rotated? |
| A. | FLUSH LOGS |
| B. | ROTATE LOGS |
| C. | FLUSH BINLOG |
| D. | ROTATE BINLOG |
| Answer» B. ROTATE LOGS | |