MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 12 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. |
System variable in MySQL server that enables to configure the SQL mode is __________ |
| A. | sql_mode |
| B. | sql_config |
| C. | sql_server |
| D. | sql_enable |
| Answer» B. sql_config | |
| 2. |
The name of the option file in Unix is __________ |
| A. | .my.cnf |
| B. | .my.ini |
| C. | .my.opt |
| D. | .my.opc |
| Answer» B. .my.ini | |
| 3. |
THE_NAME_OF_THE_OPTION_FILE_IN_UNIX_IS___________?$ |
| A. | .my.cnf |
| B. | .my.ini |
| C. | .my.opt |
| D. | .my.opc |
| Answer» B. .my.ini | |
| 4. |
System variable in MySQL server that enables to configure the SQL mode is __________$ |
| A. | sql_mode |
| B. | sql_config |
| C. | sql_server |
| D. | sql_enable |
| Answer» B. sql_config | |
| 5. |
Which is the command to move the cursor to the beginning of line in mysql input editor? |
| A. | Ctrl-E |
| B. | Ctrl-D |
| C. | Esc-a |
| D. | Ctrl-A |
| Answer» E. | |
| 6. |
Comparing a known value with NULL results into _______________ |
| A. | null |
| B. | zero |
| C. | a positive value |
| D. | a negative value |
| Answer» B. zero | |
| 7. |
Which clause is used to display information that matches a given pattern? |
| A. | WHERE |
| B. | IS |
| C. | SAME |
| D. | LIKE |
| Answer» E. | |
| 8. |
Which of the options executes all SQL statements in a SQL script irrespective of the number of errors? |
| A. | –run |
| B. | –ensure |
| C. | –force |
| D. | –violent |
| Answer» D. ‚Äö√Ñ√∂‚àö√ë‚àö¬®violent | |
| 9. |
Converting a client/server application to embedded server is simpler. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
An embedded application includes the server side only. |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
When building from source, the embedded server library is enabled by _______________ |
| A. | –with-embedded-server |
| B. | –with-server-embedded |
| C. | –with-embedded-library |
| D. | –with-library-embedded |
| Answer» B. ‚Äö√Ñ√∂‚àö√ë‚àö¬®with-server-embedded | |
| 12. |
The embedded server library containing the MySQL server linkable into applications is _______________ |
| A. | libmysqla |
| B. | libmysqlb |
| C. | libmysqlc |
| D. | libmysqld |
| Answer» E. | |