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 1583

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 inserts a new row into the STUDENT table?
 

Option A

A.    INSERT INTO student VALUES (101,'Smith');
 

Option B

B.    INSERT INTO student (stud_id, address, graduation) VALUES (101,'100 Main Street','17-JUN-99');
 

Option C

C.    INSERT INTO student (stud_id, address, name, graduation) VALUES (101,'100 Main Street','Smith','17-JUN-99');
 

Option D

D.    INSERT INTO student table
VALUES (101,'Smith','100 Main Street','17-JUN-99');

 

Option E

E.    INSERT INTO student
VALUES (101,'100 Main Street','17-JUN-99','Smith');

Correct Answer C
Explanation


Question ID 1584

You need to store currency data and you know that the data will always have two digits to the right of the decimal point. However, the number of digits to the left of the decimal place will vary greatly.
 
Which datatype would be most appropriate to store this data?
 

Option A

A.    LONG
 

Option B

B.    LONG RAW
 

Option C

C.    NUMBER(p)
 

Option D

D.    NUMBER
 

Correct Answer D
Explanation

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