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 1706

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)
 

Option A

A.    You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table.
 

Option B

B.    You can roll back the deletion of rows after the statement executes.
 

Option C

C.    You can NOT roll back the deletion of rows after the statement executes.
 

Option D

D.    An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
 

Option E

E.    It does not release the storage space used by the table.

 

Option F

F.    It releases the storage space used by the table.

Correct Answer A,C,F
Explanation


Question ID 1707

The EMPLOYEES table has these columns:
LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2)
HIRE_DATE DATE
Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:
ALTER TABLE EMPLOYEES
MODIFY (SALARY DEFAULT 5000);
Which is true about your ALTER statement?
 

Option A

A.    A change to the DEFAULT value affects only subsequent insertions to the table.
 

Option B

B.    All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
 

Option C

C.    Column definitions cannot be altered to add DEFAULT values.

 

Option D

D.    Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.

Correct Answer A
Explanation

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