Microsoft
98-364 · Question #67
Meryl works as a Database Designer for Klone Inc. She wants to create a table named Emp. She issues the following query: CREATE Table Emp (id Int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY name…
The correct answer is C. The query will fail because the id and name attributes must be separated by a comma. See the full explanation below for the reasoning.
Question
Meryl works as a Database Designer for Klone Inc. She wants to create a table named Emp. She issues the following query:
CREATE Table Emp (id Int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY name Char(10)) What will happen after executing this query?
Options
- AThe query will fail, as the id and name attributes are created in lowercase.
- BThe query will execute partially, as it will create the table but will fail to create the attributes.
- CThe query will fail because the id and name attributes must be separated by a comma.
- DThe query will create a table named Emp.
How the community answered
(36 responses)- A3% (1)
- B8% (3)
- C75% (27)
- D14% (5)
Community Discussion
No community discussion yet for this question.