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?
A.
The query will fail, as the id and name attributes are created in lowercase.
B.
The query will execute partially, as it will create the table but will fail to create the attributes.
C.
The query will fail because the id and name attributes must be separated by a comma.
D.
The query will create a table named Emp.
Explanation:
The query will fail because a comma must separate the the id and name attributes. Executing the
following query will accomplish the task:
CREATE Table Emp (id Int UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name Char(10))
Answer A is incorrect. The id and name attributes can be in lowercase.
The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows