MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 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. |
Which data type is best suited to store currency values? |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 2. |
What are PHP variables preceded by? |
| A. | _ |
| B. | @ |
| C. | $ |
| D. | & |
| Answer» D. & | |
| 3. |
The place where the server stores its databases and status files are the database directory. |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine? |
| A. | –next-storage-engine |
| B. | –new-storage-engine |
| C. | –clear-storage-engine |
| D. | –get-storage-engine |
| Answer» C. –clear-storage-engine | |
| 5. |
REPAIR TABLE works with how many of the following? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» E. | |
| 6. |
CHECK TABLE works with how many of the following? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» E. | |
| 7. |
WHAT_ARE_PHP_VARIABLES_PRECEDED_BY??$ |
| A. | _ |
| B. | @ |
| C. | $ |
| D. | & |
| Answer» D. & | |
| 8. |
Which data type is best suited to store currency values?$ |
| A. | INT |
| B. | FLOAT |
| C. | DOUBLE |
| D. | DECIMAL |
| Answer» E. | |
| 9. |
What is the output from PHP? |
| A. | statically generated |
| B. | dynamically generated |
| C. | not generated |
| D. | no output |
| Answer» C. not generated | |
| 10. |
The place where the server stores its databases and status files is the database directory. |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
With only MyISAM tables, how many of the following are for use? |
| A. | |
| B. | 1 |
| C. | 2 |
| Answer» B. 1 | |
| 12. |
What is the hub of a MySQL installation? |
| A. | mysqla |
| B. | mysqlb |
| C. | mysqlc |
| D. | mysqld |
| Answer» E. | |
| 13. |
Which option is used in ‘mysqldump’ to make all tables in the destination databases to use a different storage engine?$ |
| A. | –next-storage-engine |
| B. | –new-storage-engine |
| C. | –clear-storage-engine |
| D. | –get-storage-engine |
| Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®clear-storage-engine | |
| 14. |
Which myisamchk variable represents the size of buffer used to hold index blocks? |
| A. | key_buffer_size |
| B. | read_buffer_size |
| C. | sort_buffer_size |
| D. | write_buffer_size |
| Answer» B. read_buffer_size | |