READ Free Dumps For Oracle- 1z1-051
| Question ID 4747 | Which two statements are true regarding views? (Choose two.) |
| Option A | A. A Data Manipulation Language (DML) operation can be performed on a view that is created with the sub query having all the NOT NULL columns of a table |
| Option B | B. A view is created with the sub query having the DISTINCT keyword can be updated |
| Option C | C. A sub query that defines a view cannot include the GROUP BY clause |
| Option D | D. A view that is created with the sub query having the pseudo column ROWNUM keyword cannot be updated |
| Correct Answer | A,D |
| Question ID 4748 | Evaluate the following SQL query; |
| Option A | A. 200 |
| Option B | B. 16 |
| Option C | C. 160 |
| Option D | D. 150 |
| Option E | E. 100 |
| Correct Answer | C |
