AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-001





Question ID 1595

Which SELECT statement displays the order id, product id, and quantity of items in the ITEM table that match both the product id and quantity of an item in order 605? (Do not display the details for order 605.)

Option A

A.    SELECT ordid, prodid, qty
FROM item
WHERE (prodid, qty) IN
(SELECT prodid, qty
FROM item
WHERE ordid = 605)
AND ordid <> 605;
 

Option B

B.    SELECT ordid, prodid, qty
FROM item
WHERE (prodid, qty) =
(SELECT prodid, qty
FROM item
WHERE ordid = 605)
AND ordid <> 605;
 

Option C

C.    SELECT ordid, prodid, qty FROM item
WHERE (prodid, qty) IN (SELECT prodid, qty FROM item
WHERE ordid = 605);
 

Option D

D.    SELECT ordid, prodid, qty
FROM item
WHERE (prodid, qty) IN
(SELECT ordid, prodid, qty
FROM item
WHERE ordid = 605)
AND ordid <> 605;
 

Correct Answer A
Explanation


Question ID 1596

Evaluate this PL/SQL block:
BEGIN
FOR i IN 1..10 LOOP
IF i = 4 OR i = 6 THEN
null;
ELSE
INSERT INTO test(results)
VALUES (I);
END IF;
COMMIT;
END LOOP;
ROLLBACK;
END;
How many values will be inserted into the TEST table?
 

Option A

A.    8
 

Option B

B.    10
 

Option C

C.    4

 

Option D

D.    6
 

Option E

E.    0

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!