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. |
WHICH_AMONG_THE_FOLLOWING_IS_THE_CORRECT_SYNTAX_FOR_MODIFYING_THE_DEFINITION_OF_AN_EXISTING_TABLE??$ |
| A. | ALTER TABLE person MODIFY person_id SMALLINT UNSIGNED AUTO_INCREMENT; |
| B. | ALTER TABLE person person_id SMALLINT UNSIGNED AUTO_INCREMENT; |
| C. | ALTER TABLE person MODIFY person_id ; |
| D. | ALTER TABLE person |
| Answer» C. ALTER TABLE person MODIFY person_id ; | |
| 2. |
Which feature is used for automatic increment of the column? |
| A. | AUTO_INCREMENT |
| B. | AUTO |
| C. | INCREMENT |
| D. | All of the mentioned |
| Answer» B. AUTO | |
| 3. |
Which statement can be used for modifying the definition for an existing table? |
| A. | ALTER |
| B. | Modified |
| C. | SELECT |
| D. | FROM |
| Answer» B. Modified | |
| 4. |
Normal attribute of the table |
| A. | Super key |
| B. | Composite key |
| C. | Primary key |
| Answer» B. Composite key | |
| 5. |
Composite attributes |
| A. | Multivalued attributes |
| B. | Table name |
| C. | None of the mentioned |
| Answer» C. None of the mentioned | |
| 6. |
Is it necessary to insert the value in each column of the table? |
| A. | Yes |
| B. | No |
| C. | Depends on the server |
| D. | Depends on the usage of the table |
| Answer» C. Depends on the server | |
| 7. |
Which Statement is used to insert the values in the table? |
| A. | INSERT INTO |
| B. | Insert |
| C. | INSERT |
| D. | None of the mentioned |
| Answer» B. Insert | |