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- 1z1-051





Question ID 4830

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
You issue the following SQL statement: Exhibit:
 
Which statement is true regarding the execution of the above query?

Option A

A.    It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT or AMT_SPENT is null
 

Option B

B.    It produces an error because the AMT_SPENT column contains a null value
 

Option C

C.    It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function
 

Option D

D.    It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT
 

Correct Answer A
Explanation


Question ID 4831

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
There is only one customer with the CUST_LAST_NAME column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?

Option A

A.    INSERT INTO orders VALUES( 1,'10-mar-2007','direct', (SELECT customer_id FROM customers
WHERE cust_last_name ='Roberts' AND
credit_limit =600) ,1000 );
 

Option B

B.    INSERT INTO orders ( order_id ,order _date,order_mode , (SELECT customer_id FROM customers
WHERE cust_last_name ='Roberts' AND
credit_limit =600) , order _total )
VALUES (1,'10-mar-2007','direct' ,& &customer_id,1000);
 

Option C

C.    INSERT INTO( SELECT o.order_id,o.order,o.order_mode,c.customer_id,o.order_total
FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name
='Roberts' and c.credit_limit =600)
VALUES (1,'10-mar-2007','direct' ,& &customer_id,1000);
FROM customers
WHERE cust_last_name ='Roberts' AND
credit_limit =600) ,1000 );
 

Option D

D.    INSERT INTO orders ( order_id ,order _date,order_mode , (SELECT customer_id FROM
customers
WHERE cust_last_name ='Roberts' AND
credit_limit =600) , order _total )
VALUES (1,'10-mar-2007','direct' ,& customer_id,1000);
 

Correct Answer A
Explanation

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