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-007





Question ID 1657

 

Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)

 

Option A

A.    INTERVAL YEAR TO MONTH
 

 

 

Option B

B.    INTERVAL DAY TO SECOND
 

Option C

C.    TIMESTAMP
 

Option D

D.    INTERVAL MONTH TO DAY

 

Option E

E.    TIMESTAMP WITH DATABASE TIMEZONE

Correct Answer A,B,C
Explanation


Question ID 1659

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?

Option A

A.    SELECT ename, salary*12 'Annual Salary' FROM employees;

 

Option B

B.    SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
 

Option C

C.    SELECT ename, salary*12 "Annual Salary" FROM employees;
 

Option D

D.    SELECT ename, salary*12 AS Annual Salary FROM employees;

Correct Answer C
Explanation

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