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 1641

Examine the structure of the STUDENT table:
Name Null? Type
STUD_ID NOT NULL NUMBER(3) NAME NOT NULL VARCHAR2(25) ADDRESS VARCHAR2(50)
GRADUATION DATE
Which statement adds a new column after the NAME column to hold phone numbers?
 

Option A

A.    ALTER TABLE student
ADD COLUMN3 (phone varchar2(9));

 

Option B

B.    ALTER TABLE student
ADD (phone varchar2(9)) AS COLUMN3;
 

Option C

C.    You cannot specify the position where a new column has to be added.
 

Option D

D.    ALTER TABLE student
ADD COLUMN phone varchar2(9) POSITION 3;

Correct Answer C
Explanation


Question ID 1642

Evaluate these two SQL commands:
1.SELECT DISTINCT object_type
FROM user_objects; 2.SELECT object_type FROM all_objects;
How will the results differ?
 

Option A

A.    Statement 1 will display the distinct object types that the user can access; statement 2 will display all the object types that the user owns.
 

Option B

B.    Statement 1 will display the distinct object types in the database; statement 2 will display all the object types in the database.

 

Option C

C.    Statement 1 will display the distinct object types owned by the user; statement 2 will display all the object types in the database.
 

Option D

D.    Statement 1 will display the distinct object types owned by the user; statement 2 will display all the object types the user can access.

Correct Answer D
Explanation

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