MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 14 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. |
What is AI in terms of database collation? |
| A. | Accent Insensitive |
| B. | Augment Insensitive |
| C. | Articulate Insensitive |
| D. | Addition Insensitive |
| Answer» B. Augment Insensitive | |
| 2. |
Which property determines whether a database object is a case sensitive? |
| A. | COLLATION |
| B. | ATOMICITY |
| C. | COLLABORATION |
| D. | NORMALIZATION |
| Answer» B. ATOMICITY | |
| 3. |
Which of the following is case sensitive in MySQL? |
| A. | Event names |
| B. | Logfile group names |
| C. | Column names |
| D. | Indexes |
| Answer» C. Column names | |
| 4. |
Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 5. |
What is true about the following SQL statement? |
| A. | invalid |
| B. | display contents of table_1 |
| C. | improper case being used |
| D. | display only column names in table_1View Answer |
| Answer» C. improper case being used | |
| 6. |
WHICH_PROPERTY_DETERMINES_WHETHER_A_DATABASE_OBJECT_IS_CASE_SENSITIVE??$ |
| A. | COLLATION |
| B. | ATOMICITY |
| C. | COLLABORATION |
| D. | NORMALIZATION |
| Answer» B. ATOMICITY | |
| 7. |
WHICH_OF_THE_FOLLOWING_IS_CASE_SENSITIVE_IN_MYSQL??$ |
| A. | Event names |
| B. | Logfile group names |
| C. | Column names |
| D. | Indexes |
| Answer» B. Logfile group names | |
| 8. |
Regardless of whether a database or table name is case sensitive on the system, i? |
| A. | |
| B. | True |
| Answer» C. | |
| 9. |
Which case does InnoDB store database names in? |
| A. | lower |
| B. | upper |
| C. | mixed |
| D. | random |
| Answer» B. upper | |
| 10. |
Which variable is used to set table alias names as non-case sensitive? |
| A. | lower_case_table_names |
| B. | lower_case_all |
| C. | lower_case_alias |
| D. | lower_case_aliases |
| Answer» B. lower_case_all | |
| 11. |
Which of the following is case sensitive? |
| A. | Stored function name |
| B. | Stored procedure name |
| C. | Trigger name |
| D. | Event name |
| Answer» B. Stored procedure name | |
| 12. |
The default case sensitivity of database and table names depends on ___________ |
| A. | SQL server |
| B. | Server SQL mode |
| C. | Operating system of machine |
| D. | Does not depend on anything |
| Answer» D. Does not depend on anything | |
| 13. |
invalid |
| A. | display contents of table_1 |
| B. | improper case being used |
| C. | display only column names in table_1 |
| Answer» D. | |
| 14. |
Case sensitivity in SQL statements does not vary for different operating systems of the machine on which the server is running. |
| A. | True |
| B. | False |
| Answer» C. | |