MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 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 is the stored program associated with a schedule? |
| A. | Trigger |
| B. | Event |
| C. | Stored function |
| D. | Stored procedure |
| Answer» C. Stored function | |
| 2. |
In which directory are the DBI scripts located? |
| A. | cgi-inc |
| B. | cgi-bin |
| C. | cgi-usr |
| D. | cgi-perl |
| Answer» C. cgi-usr | |
| 3. |
PHP scripts are located in the web client document tree. |
| A. | True |
| B. | False |
| Answer» C. | |
| 4. |
How many of the following languages can interface to bind to the C API of MySQL? |
| A. | 0 |
| B. | 1 |
| C. | 2 |
| D. | 3View Answer |
| Answer» E. | |
| 5. |
In which context is the privilege ‘CREATE TABLESPACE’ applied? |
| A. | Server administration |
| B. | Tables |
| C. | Stored routines |
| D. | Views |
| Answer» B. Tables | |
| 6. |
IN_WHICH_DIRECTORY_ARE_THE_DBI_SCRIPTS_LOCATED??$ |
| A. | cgi-inc |
| B. | cgi-bin |
| C. | cgi-usr |
| D. | cgi-perl |
| Answer» C. cgi-usr | |
| 7. |
Which is the stored program associated with a schedule?$ |
| A. | Trigger |
| B. | Event |
| C. | Stored function |
| D. | Stored procedure |
| Answer» C. Stored function | |
| 8. |
PHP scripts are located in the web client document tree? |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
In which context is the privilege ‘CREATE TABLESPACE’ applied?$ |
| A. | Server administration |
| B. | Tables |
| C. | Stored routines |
| D. | Views |
| Answer» B. Tables | |
| 10. |
MySQL Enterprise Backup records details of each backup in _____________ |
| A. | history_backup |
| B. | backup_history |
| C. | backlog_history |
| D. | history_backlog |
| Answer» C. backlog_history | |
| 11. |
Which statement suspends the replication related activity of the slave server? |
| A. | RESUME SLAVE |
| B. | START SLAVE |
| C. | STOP SLAVE |
| D. | GET SLAVE |
| Answer» D. GET SLAVE | |
| 12. |
Which statement on the master expires binary log files? |
| A. | SHOW SLAVE STATUS |
| B. | PURGE MASTER |
| C. | PURGE SLAVE |
| D. | SHOW MASTER STATUS |
| Answer» C. PURGE SLAVE | |
| 13. |
The slave stores the CHANGE MASTER parameters in the file _____________ |
| A. | slave.info |
| B. | slave.inf |
| C. | master.info |
| D. | master.inf |
| Answer» D. master.inf | |