READ Free Dumps For Oracle- 1z0-007

Question ID 7915	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 ( employe_id NUMBER, name VARCGAR2(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 sey name = 'James' Where employee_id=180; Rollback; At the end of this transaction, what is true?
Option A	You have no rows in the table.
Option B	You have an employee with the name of James.
Option C	You cannot roll back to the same savepoint more than once.
Option D	Your last update fails to update any rows because employee ID 180 was already deleted.
Correct Answer	A

Explanation Explanation/Reference: Explanation: At the end of this transaction you will not have rows in the table. Incorrect Answers B: All transactions will be roll backed, so it will be no rows in the table. C: It is possible to roll back to the same savepoint more than once. D: Your last update will not fail because there is employee with ID 180 in the table and transactions have been rolled back only to the savepoint s2 before issue this update. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 279-285 Chapter 6: Manipulating Oracle Data

Question ID 7916	Which two are attributes of iSQL*Plus? (Choose two)
Option A	/SQL*Plus commands cannot be abbreviated.
Option B	/SQL*Plus commands are accessed from a browser.
Option C	/SQL*Plus commands are used to manipulate data in tables.
Option D	/SQL*Plus commands manipulate table definitions in the database.
Option E	/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Correct Answer	CE

Explanation Explanation/Reference: Explanation: D: SQL*Plus commands can be used to manipulate data in tables. E: iSQL*Plus is a proprietary interface for executing SQL Statements Incorrect Answers A: SQL*Plus commands can be abbreviated. Like command DESCRIBE can be abbreviated as DESC, or SELECT as SELE. B: SQL*Plus commands are not accessed from a browser. C: SQL DML not SQL Plus is used to manipulate data defintions OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 38-48 Chapter 1: Overview of Oracle Databases

Previous-Page 1 2. . . 85 86 87 88 89 90 91. . . 160 161 Next-Page

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