MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 7 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. |
No erro? |
| A. | Error, Duplicate value |
| B. | Any other error |
| C. | None of the mentioned |
| Answer» B. Any other error | |
| 2. |
Which of the following are the valid “database datatypes” in Mysql?$ |
| A. | Numerical |
| B. | Temporal |
| C. | Text |
| D. | All of the mentioned |
| Answer» E. | |
| 3. |
Which is the correct format to store date in the SQL? |
| A. | DEC-01-1991 |
| B. | 01-1991-11 |
| C. | 01-DEC-12 |
| D. | 1991-11-01 |
| Answer» E. | |
| 4. |
Is duplicate entry of other attributes are allowed in SQL? |
| A. | Yes |
| B. | No |
| C. | Depends |
| D. | None of the mentioned |
| Answer» B. No | |
| 5. |
Is duplicate entry of primary key is allowed in SQL? |
| A. | Yes |
| B. | No |
| C. | Depends |
| D. | None of the mentioned |
| Answer» C. Depends | |
| 6. |
Which command is used to display all the existing tables in a database? |
| A. | SHOW TABLES |
| B. | SHOW TABLE |
| C. | SHOW |
| D. | None of the mentioned |
| Answer» B. SHOW TABLE | |
| 7. |
Which command is used to remove existing tables or database? |
| A. | DROP TABLE |
| B. | DELETE |
| C. | Either DROP TABLE or DELETE |
| D. | None of the mentioned |
| Answer» B. DELETE | |