A.The Oracle join syntax supports natural joins.

B.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

C.The Oracle join syntax performs less well than the SQL:1999 compliant ANSI Join Answer.

D.The SQL:1999 compliant ANSI join syntax supports natural joins.

E.The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables.

F.The Oracle join syntax only supports right outer joins,

G.The Oracle join syntax supports creation of a Cartesian product of two tables.

A.SELECT DISTINCT * FROM employees WHERE first_ name IS NOT NULL;

B.SELECT Distinct * FROM employees WHERE first_ name < > NULL;

C.SELECT first_ name, DISTNCT last_ name FROM employees WHERE first_ name IS NOT NULL;

D.SELECT first_ name, DISTINCT last_ name FROM employees WHERE first_ name < > NULL;

A.A many-to-many relationship can be implemented only by using foreign keys

B.A one-to-many relationship in one direction is a one-to-one relationship in the other direction

C.A one-to-one relationship is always a self-referencing relationship

D.A table name can be specified just once when selecting data from a table having a selfreferencing relationship

E.A Relationship can be mandatory for both entities

A.MERGE INTO new_prices n
USING(SELECT*FROM product WHERE cost>150) p
ON (n.prod_id=p.prod_id)
WHEN NATCHED THEN
DELETE WHERE(p.cost<200)
WHEN NOT MATCHED THEN
INSERT (n.prod_id,n.price)VALUES (p.prod_id,p.cost*.01);

B.MERGE INTO new_prices n
USING products p
WHEN NOT NATCHED THEN
INSERT (n.prod_id, n.price)VALUES (p.prod_id,cost*.01)
WHERE (p.cost <200);

C.MERGE INTO new_prices n
USING (SELECT * FROM products WHERE cost>150) p
ON (n.prod_id=p.prod_id)
WHEN NATCHED THEN
UPDATE SET n.price=p.cost*.01
DELETE WHERE (p.cost<200);

D.MERGE INTO new_prices n
USING(SELECT*FROM products)p
WHEN MATECHED THEN
UPDATE SET n.price=p.cost*.01
WHEN NOT MATCHED THEN
INSERT(n.prod_id,n.price)VALUES (p.prod_id,cost*01)
WHERE(p.cost<200);

A.It must be an equijoin.

B.The join key column must have an index.

C.It can be an inner join.

D.It can be a left outer join.

E.It must be a full outer join.