QUESTION 14 Given table R(A,B,C) and S(C,D,E), which of the following SQL statem

Question

QUESTION 14

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table S?

a.   select * from R left outer join S where R.C = S.C;

b.     select * from R right outer join S where R.C = S.C;

c.   either a. or b.

d.   neither a. nor b.

QUESTION 37

The data manipulation language defines

a.   the schema or the structure of a database

b.   the set of operations in a database system

c.   both a. and b.

d.   neither a. nor b.

QUESTION 44

A key in a relational database table

a.   is a minimal set of attributes.

b.   uniquely identifies a tuple (record) in a relation table.

c.   both a. and b.

d.   neither a. nor b.

Explanation / Answer

1)

Given table R(A,B,C) and S(C,D,E), which of the following SQL statements would find the record(s) with null values on the column C in table S?

b) select * from R right outer join S where R.C = S.C;

2) The data manipulation language defines

b) the set of operations in a database system

3) A key in a relational database table

is a minimal set of attributes.

uniquely identifies a tuple (record) in a relation table.

c) both a. and b.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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