Quiz: Data Definition
Test your knowledge of DDL commands.
We'll cover the following...
We'll cover the following...
Technical Quiz
1.
(Select all that apply.) Consider the following code. Which statement below is true?
CREATE TABLE Dept.Department
(
DepartmentID INT PRIMARY KEY,
DepartmentName VARCHAR(30)
)
A.
The DepartmentID is a constraint name of PRIMARY KEY.
B.
The DepartmentName is a text field.
C.
The Dept is the table name.
D.
The DepartmentID cannot store floating point values.
1 / 4