READ Free Dumps For Oracle- 1z0-001
| Question ID 8148 | Which data dictionary view contains the definition of a view?
|
| Option A | MY_VIEWS.
|
| Option B | USER_VIEWS.
|
| Option C | SYSTEM_VIEWS.
|
| Option D | USER_TAB_VIEWS.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct because the USER_VIEWS contains the definition of a view. Incorrect Answers: A: MY_VIEWS data dictionary view does not exist. C: SYSTEM_VIEWS data dictionary view does not exist. D: USER_TAB_VIEWS contains table names for user views, not the definition of a view. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 114-116 Chapter 3: Creating Oracle Database Objects
| Question ID 8149 | Employee Table exhibit:
***MISSING***
Click on the exhibit button and examine the employee table. You create a view with this command:
CREATE VIEW dept_salary_vu AS SELECT dept_no, salary, last_name FROM employeeWHERE
salary>45000.
WITH CHECK OPTION;
For which employee can you update the dept_no column using this view?
|
| Option A | Brown.
|
| Option B | Southall.
|
| Option C | Chiazza.
|
| Option D | None.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct because you cannot update the dept_no column because of WHERE clause and WITH CHECK OPTION clause. Incorrect Answers: A: Data cannot be changed by definition of WITH CHECK OPTION clause B: Data cannot be changed by definition of WITH CHECK OPTION clause C: Data cannot be changed by definition of WITH CHECK OPTION clause Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 167 Chapter 4: Creating Other Database Objects in Oracle