MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 65 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
For which table does REPAIR TABLE not work? |
| A. | InnoDB |
| B. | CSV |
| C. | ARCHIVE |
| D. | MyISAM |
| E. | None of these |
| Answer» B. CSV | |
| 52. |
The data directory subdirectory that corresponds to the nbdinfo database is ______________. |
| A. | performance_schema |
| B. | sys |
| C. | nbdinfo |
| D. | mysql |
| E. | None of these |
| Answer» B. sys | |
| 53. |
When relocating an individual table, the table to be relocated should be ______________. |
| A. | InnoDB |
| B. | ENGINE |
| C. | MyISAM |
| D. | TRANSACTION |
| E. | None of these |
| Answer» D. TRANSACTION | |
| 54. |
The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is __________. |
| A. | illegal |
| B. | fare |
| C. | good |
| D. | bad |
| E. | None of these |
| Answer» E. None of these | |
| 55. |
The best datatype for a column that is expected to store values up to 2 million is _________. |
| A. | BIGINT |
| B. | MEDIUMINT |
| C. | TINYINT |
| D. | SMALLINT |
| E. | None of these |
| Answer» B. MEDIUMINT | |
| 56. |
The library file that contains various portability macros and definitions is ______________. |
| A. | my_local.h |
| B. | mysql.h |
| C. | my_global.h |
| D. | my_sys.h |
| E. | None of these |
| Answer» E. None of these | |
| 57. |
Which of the following use NULL to indicate failure? |
| A. | 3 |
| B. | 2 |
| C. | 1 |
| D. | 0 |
| E. | None of these |
| Answer» C. 1 | |
| 58. |
The header that should be included first is ______________. |
| A. | my_sys.h |
| B. | my_local.h |
| C. | my_global.h |
| D. | mysql.h |
| E. | None of these |
| Answer» D. mysql.h | |
| 59. |
Encrypted connections can be established using ______________. |
| A. | exec_ssl_stmnt |
| B. | exec_stmnt_ssl |
| C. | exec_ssl_stmt |
| D. | exec_stmt_ssl |
| E. | None of these |
| Answer» E. None of these | |
| 60. |
The most restrictive among the following is ______________. |
| A. | same |
| B. | machine dependent |
| C. | mysql_real_query() |
| D. | mysql_query() |
| E. | None of these |
| Answer» E. None of these | |
| 61. |
The datadir variable value can be seen using ______________. |
| A. | SHOW VARIABLE |
| B. | SHOW VARIABLES |
| C. | DISP VARIABLES |
| D. | CONNECT VARIABLES |
| E. | None of these |
| Answer» C. DISP VARIABLES | |
| 62. |
The option that specifies the data directory location at server startup is ______________. |
| A. | datadir |
| B. | data-dir |
| C. | data_dir |
| D. | data |
| E. | None of these |
| Answer» B. data-dir | |
| 63. |
SBR replication is ______________. |
| A. | Row based |
| B. | Column based |
| C. | Table based |
| D. | Statement based |
| E. | None of these |
| Answer» E. None of these | |
| 64. |
To reload a delimited text data file use ______________. |
| A. | mysqlimport |
| B. | mysqlnaive |
| C. | mysqld |
| D. | mysqldump |
| E. | None of these |
| Answer» B. mysqlnaive | |
| 65. |
For InnoDB tables in mysqldump an online backup that takes no locks on tables can be performed by ______________. |
| A. | no-transaction |
| B. | double-transaction |
| C. | multiple-transaction |
| D. | single-transaction |
| E. | None of these |
| Answer» E. None of these | |