CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Changed 1z0-071 Exam Questions

Page: 14 / 24
Total 324 questions
Get 1z0-071 Full Access Download 1z0-071 PDF

Oracle Database 12c SQL Questions and Answers

Question 53

Examine the description of the PRODUCTS table:

Which two statements execute without errors?

Options:

A.

MERGE INTO new_prices n

USING (SELECT * FROM products) p

WHEN MATCHED 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);

B.

MERGE INTO new_prices n

USING (SELECT * FROM products WHERE cost>150) p

ON (n.prod_id= p.prod_id)

WHEN MATCHED THEN

UPDATE SET n.price= p.cost*.01

DELETE WHERE (p.cost<200);

C.

MERGE INTO new_prices n

USING products p

ON (p.prod_id =n.prod_id)

WHEN NOT MATCHED THEN

INSERT (n.prod _id, n.price) VALUES (p.prod_id, cost*.01)

WHERE (p.cost<200);

D.

MERGE INTO new_prices n

USING (SELECT * FROM products WHERE cost>150) p

ON (n.prod_id= p.prod_id)

WHEN MATCHED THEN

DELETE WHERE (p.cost<200)

Question 54

Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

Options:

A.

SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

B.

SELECT join_ date + '20' EROM employees;

C.

SELECT join_ date丨丨‘’丨丨 salary FROM employees;

D.

SELECT join _ date FROM employees WHERE join date > *10-02-2018';

E.

SELECT salary + '120.50' FROM employees;

Question 55

Viev the Exhibit and examine the structure of the PRODUCT INFORMATION and INVENTORIEStables.

You have a requirement from the supplies department to give a list containing PRODUCT _ID,SUPPLIER ID, and QUANTITY_ON HAND for all the products where in QUANTITY ON HAND is lessthan five.

Which two SQL statements can accomplish the task? (Choose two)

Options:

A.

SELECT product id, quantity on hand, supplier id

FROM product information

NATURAL JOIN inventories AND quantity .on hand < 5;

B.

SELECT i. product id, i. quantity .on hand, pi. supplier_id

FROM product_information pi JOIN inventories i

ON (pi. product. id=i. product id) AND quantity on hand < 5;

C.

SELECT i. product_id, i. quantity_on hand, pi. supplier id

FROM product information pi JOIN inventories i USING (product id) AND quantity .on hand < 5;

D.

SELECT i.product id, i. quantity on hand, pi. supplier id

FROM product information pi JOIN inventories i

ON (pi.product id=i. product id)WHERE quantity on hand < 5;

Question 56

Which three are true about privileges?

Options:

A.

Schema owners can grant object privileges on objects in their schema to any other user or role.

B.

A combination of object and system privileges can be granted to a role.

C.

All types of schema objects have associated object privileges .

D.

Only users with the DBA role can create roles .

E.

Object privileges granted on a table automatically apply to all synonyms for that table.

F.

Only users with the GRANT ANY PRIVILEGE privilege can grant and revoke system privileges from other users.

Page: 14 / 24
Total 324 questions
Get 1z0-071 Full Access Download 1z0-071 PDF