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 1748

Evaluate the SQL statement:
SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;
What will be displayed?
 

Option A

A.    0.00
 

Option B

B.    0
 

Option C

C.    1

 

Option D

D.    an error statement

Correct Answer B
Explanation


Question ID 1749

Click the Exhibit button and examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers
and refers to the EMPLOYEE_ ID. The JOB_ ID column is a NOT NULL column. Evaluate this DELETE statement:
DELETE employee_id, salary, job_id FROM employees
WHERE dept_id = 90;
Why does the DELETE statement fail when you execute it?

Option A

A.    There is no row with dept_id 90 in the EMPLOYEES table.

 

Option B

B.    You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
 

Option C

C.    You cannot delete the JOB_ID column because it is a NOT NULL column.
 

Option D

D.    You cannot specify column names in the DELETE clause of the DELETE statement.

Correct Answer D
Explanation

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