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 1524

Examine the structure of the STUDENT table:
Name Null? Type        
        

STUD_ID NOT NULL NUMBER(3) NAME NOT NULL VARCHAR2(25) PHONE NOT NULL VARCHAR2(9) ADDRESS VARCHAR2(50)
GRADUATION DATE
There are 100 records in the STUDENT table. You want to change the name of the GRADUATION column to GRAD_DATE.
Which statement is true?
 

Option A

A.    You cannot rename a column.
 

Option B

B.    You use the ALTER TABLE command with the RENAME COLUMN clause to rename the column.

 

Option C

C.    You use the ALTER TABLE command with the MODIFY COLUMN clause to rename the column.
 

Option D

D.    You use the ALTER TABLE command with the MODIFY clause to rename the column.

Correct Answer A
Explanation


Question ID 1525

The EMPLOYEE table contains these columns:
LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) DEPT_ID NUMBER(9)
You need to display the names of employees that are not assigned to a department.
Evaluate this SQL statement:
SELECT last_name, first_name FROM employee
WHEREdept_id = NULL;
Which change should you make to achieve the desired result?
 

Option A

A.    Change the operator in the WHERE condition.
 

Option B

B.    Create an outer join.

 

Option C

C.    Add a second condition to the WHERE condition.
 

Option D

D.    Change the column in the WHERE condition.

Correct Answer A
Explanation

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