Help please! R is currently empty. Develop a test that determines whether an ins

Question

Help please!

R is currently empty. Develop a test that determines whether an insertion into R is currently legal. Then apply your test to determine which of the following INSERT statements is allowable.

INSERT INTO R(b,c) VALUES(3,4);

  CREATE TABLE R (      a INT PRIMARY KEY,      b INT DEFAULT 0,      c INT NOT NULL  );  

R is currently empty. Develop a test that determines whether an insertion into R is currently legal. Then apply your test to determine which of the following INSERT statements is allowable.

Explanation / Answer

In the given Relation schema, given that

a INT PRIMARY KEY, b INT DEFAULT 0, c INT NOT NULL. so, as b is given default 0 there will be no b value.

The correct answer is not in the given options. The correct one is:

INSERT INTO R (c,a) VALUES (3,4)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.