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. |
The default case sensitivity of the database and table names depends on ___________ |
| A. | Server SQL mode |
| B. | Operating system of machine |
| C. | Does not depend on anything |
| D. | SQL server |
| Answer» C. Does not depend on anything | |
| 2. |
Which statement is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it? |
| A. | SELECT * FROM `sampledb.member` |
| B. | SELECT * FROM `sampledb`.`member` |
| C. | SELECT * FROM `member`.`sampledb` |
| D. | SELECT * FROM `member.sampledb` |
| Answer» C. SELECT * FROM `member`.`sampledb` | |
| 3. |
Which character is illegal in naming an unquoted identifier in SQL? |
| A. | . |
| B. | _ |
| C. | $ |
| D. | 2 |
| Answer» B. _ | |
| 4. |
To see the table structure which command is issued? |
| A. | VIEW tbl_name; |
| B. | SELECT TABLE tbl_name; |
| C. | SELECT tbl_name; |
| D. | DESCRIBE tbl_name; |
| Answer» E. | |
| 5. |
The number of attributes in the following SQL table is ______________ |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 30View Answer |
| Answer» C. 3 | |
| 6. |
Which of these is preferred when stored procedures are not being used? |
| A. | CLIENT_MULTI_STATEMENTS |
| B. | mysql_set_server_option() |
| C. | any of the two |
| D. | neither of the twoView Answer |
| Answer» D. neither of the twoView Answer | |
| 7. |
TO_SEE_THE_TABLE_STRUCTURE_WHICH_COMMAND_IS_ISSUED??$ |
| A. | VIEW tbl_name; |
| B. | SELECT TABLE tbl_name; |
| C. | SELECT tbl_name; |
| D. | DESCRIBE tbl_name; |
| Answer» C. SELECT tbl_name; | |
| 8. |
Which_character_is_illegal_in_naming_an_unquoted_identifier_in_SQL?$ |
| A. | . |
| B. | _ |
| C. | $ |
| D. | 2 |
| Answer» C. $ | |
| 9. |
Which option executes all SQL statements in a SQL script irrespective of the number of errors? |
| A. | –ensure |
| B. | –force |
| C. | –violent |
| D. | –run |
| Answer» C. ‚Äö√Ñ√∂‚àö√ë‚àö¬®violent | |
| 10. |
mysql_next_result() returns a status. |
| A. | True |
| B. | False |
| Answer» C. | |
| 11. |
CLIENT_MULTI_STATEMENTS |
| A. | mysql_set_server_option() |
| B. | any of the two |
| C. | neither of the two |
| Answer» B. any of the two | |
| 12. |
Which option enables multiple-statement execution? |
| A. | CLIENT_MULTI_STATEMENTS |
| B. | CLIENT_STATEMENTS_MULTI |
| C. | MULTI_STATEMENTS_CLIENT |
| D. | MULTI_CLIENTS_STATEMENTS |
| Answer» B. CLIENT_STATEMENTS_MULTI | |
| 13. |
Multiple statement execution is enabled by default. |
| A. | True |
| B. | False |
| Answer» C. | |