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 header that should be included first? |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» B. my_sys.h | |
| 2. |
Which is the library file that contains various portability macros and definitions? |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» C. mysql.h | |
| 3. |
The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________ |
| A. | 1 |
| B. | 3 |
| C. | 5 |
| D. | 8 |
| Answer» D. 8 | |
| 4. |
WHICH_IS_THE_LIBRARY_FILE_THAT_CONTAINS_VARIOUS_PORTABILITY_MACROS_AND_DEFINITIONS??$ |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» C. mysql.h | |
| 5. |
Which_is_the_header_that_should_be_included_first?$ |
| A. | my_global.h |
| B. | my_sys.h |
| C. | mysql.h |
| D. | my_local.h |
| Answer» B. my_sys.h | |
| 6. |
What is SBR replication? |
| A. | Statement based |
| B. | Row based |
| C. | Column based |
| D. | Table based |
| Answer» B. Row based | |
| 7. |
Replication does not enable data from one MySQL database server to be copied to one or more MySQL database servers. |
| A. | True |
| B. | False |
| Answer» C. | |
| 8. |
What is used to reload a delimited text data file? |
| A. | mysqldump |
| B. | mysqld |
| C. | mysqlimport |
| D. | mysqlnaive |
| Answer» D. mysqlnaive | |
| 9. |
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by which option? |
| A. | –multiple-transaction |
| B. | –single-transaction |
| C. | –double-transaction |
| D. | –no-transaction |
| Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®double-transaction | |
| 10. |
What is the minimum value stored by signed TINYINT? |
| A. | -256 |
| B. | -128 |
| C. | 0 |
| D. | 128 |
| Answer» C. 0 | |
| 11. |
Which mode does not remove trailing spaces when CHAR values are retrieved? |
| A. | PAD_CHAR_TO_FULL_LENGTH |
| B. | TO_FULL_LENGTH_CHAR_PAD |
| C. | CHAR_PAD_TO_FULL_LENGTH |
| D. | PAD_CHAR_TO_LENGTH |
| Answer» B. TO_FULL_LENGTH_CHAR_PAD | |
| 12. |
The storage in bytes required for VARCHAR(4) type ‘abcd’ is _____________$ |
| A. | 1 |
| B. | 3 |
| C. | 5 |
| D. | 8 |
| Answer» D. 8 | |
| 13. |
The maximum value that can be specified to the size of VARCHAR is _____________ |
| A. | 0 |
| B. | 127 |
| C. | 1023 |
| D. | 65535 |
| Answer» E. | |