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 4906

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?
 

Option A

A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
 

Option B

B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_ name IS NOT NULL;
NULL;
 

Option C

C.    ALTER TABLE    customers MODIFY customer_    name CONSTRAINT cust_name_nn NOT NULL;
 

Option D

D.    ALTER TABLE    customers MODIFY customer_    name CONSTRAINT cust_name_nn IS NOT
 

Option E

E.    ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
 

Option F

F.    ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL;
 

Correct Answer C
Explanation


Question ID 4907

Evaluate this SQL statement:
SELECT ename, sal, 12*sal+100 FROM emp;
The SAL column stores the monthly salary of the employee. Which change must be made to the above syntax to

Option A

calculate the annual compensation as "monthly salary plus a monthly bonus of $100, multiplied by 12"?
 

Option B

A.    No change is required to achieve the desired results.
 

Option C

B.    SELECT ename, sal, 12*(sal+100) FROM emp;
 

Option D

C.    SELECT ename, sal, (12*sal)+100 FROM emp;
 

Option E

D.    SELECT ename, sal+100,*12 FROM emp;
 

Correct Answer B
Explanation

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