MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 15 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 statement makes changes to the database’s global attributes? |
| A. | CHANGE |
| B. | ALTER |
| C. | ALTERNATE |
| D. | UPDATE |
| Answer» C. ALTERNATE | |
| 2. |
Which statement is used to see the definition for an existing database? |
| A. | SHOW CREATE DATABASE |
| B. | SHOW DATABASE |
| C. | SHOW CREATE |
| D. | SHOW CREATE DATABASE TABLE |
| Answer» B. SHOW DATABASE | |
| 3. |
MySQL stores the database character set and collation attributes in the file _________ |
| A. | dp.opt |
| B. | db.opt |
| C. | db.sv |
| D. | db.zip |
| Answer» C. db.sv | |
| 4. |
To create a database only if it doesn’t already exist, which clause is used? |
| A. | IF EXISTS |
| B. | IF NOT EXISTS |
| C. | CREATE EXISTS |
| D. | EXISTS IF |
| Answer» C. CREATE EXISTS | |
| 5. |
It is not required to have an access privilege for a database before selecting it with ‘USE’. |
| A. | True |
| B. | False |
| Answer» C. | |
| 6. |
WHICH_STATEMENT_IS_USED_TO_SEE_THE_DEFINITION_FOR_AN_EXISTING_DATABASE??$ |
| A. | SHOW CREATE DATABASE |
| B. | SHOW DATABASE |
| C. | SHOW CREATE |
| D. | SHOW CREATE DATABASE TABLE |
| Answer» B. SHOW DATABASE | |
| 7. |
Which_statement_makes_changes_to_the_database’s_global_attributes?$# |
| A. | CHANGE |
| B. | ALTER |
| C. | ALTERNATE |
| D. | UPDATE |
| Answer» C. ALTERNATE | |
| 8. |
MySQL stores the database character set and collation attributes in the file ________? |
| A. | dp.opt |
| B. | db.opt |
| C. | db.sv |
| D. | db.zip |
| Answer» C. db.sv | |
| 9. |
If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set. |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
To create a database only if it doesn’t already exist, which clause is used?$ |
| A. | IF EXISTS |
| B. | IF NOT EXISTS |
| C. | CREATE EXISTS |
| D. | EXISTS IF |
| Answer» C. CREATE EXISTS | |
| 11. |
The file created by the server to store the database attributes is __________ |
| A. | db.otp |
| B. | dp.zip |
| C. | db.opt |
| D. | db.cls |
| Answer» D. db.cls | |
| 12. |
Which keyword is used to create a database? |
| A. | CREATE |
| B. | SET |
| C. | SETUP |
| D. | LINK |
| Answer» B. SET | |
| 13. |
It is not required to have an access privilege for a database before selecting it with ‘USE’.$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 14. |
Which keyword is the synonym for DATABASE? |
| A. | TABLE |
| B. | OBJECT |
| C. | DB |
| D. | SCHEMA |
| Answer» E. | |
| 15. |
Which statement is used to select a default database? |
| A. | USE |
| B. | CREATE |
| C. | DROP |
| D. | SCHEMA |
| Answer» B. CREATE | |