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 1700

Evaluate the set of SQL statements:
CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13));
ROLLBACK;
DESCRIBE DEPT
What is true about the set?
 

Option A

A.    The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
 

Option B

B.    The DESCRIBE DEPT statement displays the structure of the DEPT table.
 

Option C

C.    The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

 

Option D

D.    The ROLLBACK statement frees the storage space occupied by the DEPT table.

Correct Answer B
Explanation


Question ID 1701

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25) HIRE_DATE DATE
You issue these statements:
CREATE table new_emp ( employee_id NUMBER, name VARCHAR2(30));
INSERT INTO new_emp SELECT employee_id , last_name from employees;
Savepoint s1;
UPDATE new_emp set name = UPPER(name);
Savepoint s2;
Delete from new_emp;
Rollback to s2;
Delete from new_emp where employee_id =180;
UPDATE new_emp set name = 'James';
Rollback to s2;
UPDATE new_emp set name = 'James' WHERE employee_id =180;
Rollback;
At the end of this transaction, what is true?
 

Option A

A.    Your last update fails to update any rows because employee ID 180 was already deleted.
 

Option B

B.    You have no rows in the table.
 

Option C

C.    You cannot roll back to the same savepoint more than once.

 

Option D

D.    You have an employee with the name of James.

Correct Answer B
Explanation

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