READ Free Dumps For Oracle- 1z0-007
| Question ID 1734 | Which two statements about views are true? (Choose two.) |
| Option A | A. A view can be created as read only. |
| Option B | B. A view can be created as a join on two or more tables. |
| Option C | C. A view must have aliases defined for the column names in the SELECT statement. |
| Option D | D. A view cannot be created with a GROUP BY clause in the SELECT statement. |
| Option E | E. A view cannot have an ORDER BY clause in the SELECT statement. |
| Correct Answer | A,B |
| Question ID 1735 | Which iSQL*Plus feature can be used to replace values in the WHERE clause? |
| Option A | A. prompt variables |
| Option B | B. substitution variables |
| Option C | C. instead-of variables |
| Option D | D. This feature cannot be implemented through iSQL*Plus. |
| Option E | E. replacement variables |
| Correct Answer | B |