PrepAway - Latest Free Exam Questions & Answers

Which of the following statements is true?

If the following SQL statements are executed:
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
name VARCHAR(25));
CREATE TABLE tab2 (empid SMALLINT,
weekno SMALLINT,
payamt DECIMAL(6,2),
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES taba(id) ON UPDATE NO ACTION);
Which of the following statements is true?

PrepAway - Latest Free Exam Questions & Answers

A.
Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID
column of table TAB2

B.
The updating of values in the ID column of table TAB1 is not allowed

C.
Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted
in the EMPID column of table TAB2

D.
When values that exist in the ID column of table TAB1 are updated, corresponding values in the
EMPID column of table TAB2 are updated as well

One Comment on “Which of the following statements is true?


Leave a Reply