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 1552

You need to change the job title 'Clerk' to 'Administrative Clerk' for all clerks. Which statement does this?

Option A

A.    UPDATE emp
SET VALUES job = 'Administrative Clerk' WHERE UPPER(job) = 'CLERK';
 

Option B

B.    UPDATE emp
SET job = 'Administrative Clerk';

 

Option C

C.    UPDATE emp
job := 'Administrative Clerk'
WHERE UPPER(job) = 'CLERK';
 

Option D

D.    UPDATE emp
SET job = 'Administrative Clerk' WHERE UPPER(job) = 'CLERK';

Correct Answer D
Explanation


Question ID 1553

Examine the structure of the STUDENT table:
Name Null? Type
 
STUD_ID NOT NULL NUMBER(3) NAME VARCHAR2(25)
ADDRESS VARCHAR2(50)
GRADUATION DATE
Currently, the table is empty. You have decided that NULL values should not be allowed for NAME column.
Which statement restricts NULL values from being entered into the column?
 

Option A

A.    ALTER TABLE student
MODIFY (name varchar2(25) NOT NULL);
 

Option B

B.    ALTER TABLE student
ADD CONSTRAINT name(NOT NULL);
 

Option C

C.    ALTER TABLE student
ADD CONSTRAINT NOT NULL(name);
 

Option D

D.    ALTER TABLE student
MODIFY CONSTRAINT name(NOT NULL);
 

Correct Answer A
Explanation

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