PrepAway - Latest Free Exam Questions & Answers

Which of the following is true about the table below?

Which of the following is true about the table below?
CREATE TABLE EMPLOYEE (
ID INTEGER NOT NULL,
NAME VARCHAR(30) NOT NULL,
EXTENSION INTEGER NOT NULL,
MANAGER VARCHAR(30) NOT NULL
PRIMARY KEY (ID));
TERMINATE;
ID NAME EXTENSION MANAGER
1 John S 53412 Y
2 Susan P 54123 N

3 Jennifer L 51234 N

PrepAway - Latest Free Exam Questions & Answers

A.
ID is a value found in the EMPLOYEE table

B.
ID, 1, 2, 3 makes up a row in the EMPLOYEE table

C.
The MANAGER domain consists only of the value Y

D.
NAME, John S, Susan P, Jennifer L makes up a column in the EMPLOYEE table

Explanation:


Leave a Reply