Question

Part A: MCQs and True/False i. The join that returns all records from the left table and matching records from right table in the result set is referred to as: a. Left outer join b. Right outer join c. Full outer join d. Cross outer join ii. A ____ clause is used to combine rows from two or more tables, based on a related column between them: a. Add b. Join c. Link d. None of the above iii. Which SQL keyword is used to change the structure, properties or constraints of a table? a. SET b. CREATE c. SELECT d. ALTER iv. An SQL virtual table is called a view. True/False v. Rows in a table can be changed by using the UPDATE statement. True/False vi. Projection is used to select the required rows of data from a relation. True/False

          Part A:
MCQs and True/False
i. The join that returns all records from the left table and
matching records from right table in the result set is
referred to as:
a. Left outer join
b. Right outer join
c. Full outer join
d. Cross outer join
ii. A ____ clause is used to combine rows from two or
more tables, based on a related column between them:
a. Add
b. Join
c. Link
d. None of the above
iii. Which SQL keyword is used to change the structure,
properties or constraints of a table?
a. SET
b. CREATE
c. SELECT
d. ALTER
iv. An SQL virtual table is called a view. True/False
v. Rows in a table can be changed by using the UPDATE
statement. True/False
vi. Projection is used to select the required rows of data from a
relation. True/False

Part A:
MCQs and True/False
i. The join that returns all records from the left table and
matching records from right table in the result set is
referred to as:
a. Left outer join
b. Right outer join
c. Full outer join
d. Cross outer join
ii. A clause is used to combine rows from two or
more tables, based on a related column between them:
a. Add
b. Join
c. Link
d. None of the above
iii. Which SQL keyword is used to change the structure,
properties or constraints of a table?
a. SET
b. CREATE
c. SELECT
d. ALTER
iv. An SQL virtual table is called a view. True/False
v. Rows in a table can be changed by using the UPDATE
statement. True/False
vi. Projection is used to select the required rows of data from a
relation. True/False

Added by Nathan H.

Question

Please give Ace some feedback