READ Free Dumps For Oracle- 1z0-007
| Question ID 7955 | Which two statements complete a transaction? (Choose two)
|
| Option A | DELETE employees;
|
| Option B | DESCRIBE employees;
|
| Option C | ROLLBACK TO SAVE POINT C;
|
| Option D | GRANT SELECT ON employees TO SCOTH
|
| Option E | ALTER TABLE employees SET UNUSED COLUMN sal;
|
| Option F | Select MAX(sal) FROM employees WHERE department _ id 20;
|
| Correct Answer | DE |
Explanation Explanation/Reference: Explanation: D: GRANT is a DML operation which will cause an implicit commit E: It is important to understand that an implicit COMMIT occurs on the database when a user exits SQL*Plus or issues a data-definition language (DDL) command such as a CREATE TABLE statement, used to create a database object, or an ALTER TABLE statement, used to alter a database object. Incorrect Answers A: The DELETE command is data-manipulation language (DML) command and it does not complete a transaction. B: The DESCRIBE command is internal SQL*Plus command and it has nothing to do with completion a transaction. C: ROLLBACK is not used to commit or complete a transaction, it is used to undo a transaction F: SELECT command is used to retrieve data. It does not complete a transaction. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 281-282 Chapter 3: Advanced Data Selection in Oracle
| Question ID 7956 | You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?
|
| Option A | SELECT* FROM customers;
|
| Option B | SELECT name, address FROM customers;
|
| Option C | SELECT id, name, address, phone FROM customers;
|
| Option D | SELECT cust_name, cust_address FROM customers;
|
| Option E | SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: This answer provides correct list of columns for the output. Incorrect Answers A: This answer does not provide correct list of columns for the output. It is not required to show all columns of the table. Symbol "*" is used in the SELECT command to substitute a list of all columns of the table. B: This answer does not provide correct list of columns for the output. There are not NAME and ADDRESS columns in the CUSTOMERS table. C: This answer does not provide correct list of columns for the output. There are not ID, NAME, ADDRESS or PHONE columns in the CUSTOMERS table. E: This answer does not provide correct list of columns for the output. It is not required to show all columns of the table. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 20-24 Chapter 1: Overview of Oracle Databases