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 4753

You work as a database administrator at ABC.com. You study the exhibit carefully.
Exhibit:
 
You want to update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement will accomplish the task?

Option A

A.    UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level = NULL;
 

Option B

B.    UPDATE customers
SET cust_credit_limit = NULL
WHERE cust_income_level IS NULL;
 

Option C

C.    UPDATE customers
SET cust_credit_limit = TO_NUMBER(NULL)
WHERE cust_income_level = TO_NUMBER(NULL);
 

Option D

D.    UPDATE customers
SET cust_credit_limit = TO_NUMBER(‘ ‘,9999)
WHERE cust_income_level IS NULL;
 

Correct Answer B
Explanation


Question ID 4754

Evaluate the following SQL statements:
Exhibit:
 
Which ORDER BY clauses are valid for the above query? (Choose all that apply.)

Option A

A.    ORDER BY 2,cust_id
 

Option B

B.    ORDER BY "Last Name"
 

Option C

C.    ORDER BY CUST_NO
 

Option D

D.    ORDER BY "CUST_NO"
 

Option E

E.    ORDER BY 2,1
 

Correct Answer A,B,E
Explanation

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