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 1518

Which statement about multiple column subqueries is true?

Option A

A.    In a pairwise subquery, the values returned from the subquery are compared individually to the values in the outer query.
 

Option B

B.    A non-pairwise comparison produces a cross product.
 

Option C

C.    In a non-pairwise subquery, the values returned from the subquery are compared as a group to the values in the outer query.

 

Option D

D.    A pairwise comparison produces a cross product.

Correct Answer B
Explanation


Question ID 1519

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 need to modify the PHONE column to hold only numeric values.
Which statement will modify the datatype of the PHONE column?
 

Option A

A.    ALTER TABLE student
MODIFY COLUMN phone NUMBER(9);
 

Option B

B.    ALTER TABLE student MODIFY phone NUMBER(9);
 

Option C

C.    You cannot modify the datatype of a column if there is data in the column.

 

Option D

D.    You cannot modify a VARCHAR2 datatype to a NUMBER datatype for a column.

Correct Answer C
Explanation

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