READ Free Dumps For Oracle- 1z0-007
| Question ID 7899 | From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for __________. (Choose all that apply)
|
| Option A | Updating
|
| Option B | Viewing
|
| Option C | Deleting
|
| Option D | Inserting
|
| Option E | Truncating
|
| Correct Answer | BD |
Explanation Explanation/Reference: Explanation: You can use SELECT statement to display and to insert data into different table. Incorrect Answers A: You cannot update data with SELECT statement. Update command is used for this purpose. C: You cannot delete data with SELECT statement. Delete command is used for this purpose. E: You cannot truncate data with SELECT statement. Truncate command is used for this purpose. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 20-21 Chapter 1: Overview of Oracle Databases
| Question ID 7900 | You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?
|
| Option A | CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
|
| Option B | CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
|
| Option C | CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
|
| Option D | CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
|
| Option E | CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
|
| Correct Answer | C |
Explanation Explanation/Reference: Explanation: Tables that underlie views often have constraints that limit the data that can be added to those tables. Views cannot add data to the underlying table that would violate the table's constraints. However, you can also define a view to restrict the user's ability to change underlying table data even further, effectively placing a special constraint for data manipulation through the view. This additional constraint says that INSERT or UPDATE statements issued against the view are cannot create rows that the view cannot subsequently select. This constraint is configured when the view is defined by adding the WITH CHECK OPTION to the CREATE VIEW statement. Incorrect Answers A: This view does not provide correct semantic of question task. B: WITH READ ONLY clause is incorrect syntax in the CREATE VIEW command. D: This view does not provide correct semantic of question task. E: NO UPDATE clause is incorrect syntax in the CREATE VIEW command. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 301-303 Chapter 7: Creating Other Database Objects in Oracle