READ Free Dumps For Oracle- 1z1-051
| Question ID 4890 | Which two statements about creating constraints are true? (Choose two) |
| Option A | A. Constraint names must start with SYS_C. |
| Option B | B. All constraints must be defines at the column level. |
| Option C | C. Constraints can be created after the table is created. |
| Option D | D. Constraints can be created at the same time the table is created. |
| Option E | E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view. |
| Correct Answer | C,D |
| Question ID 4891 | Which two statements are true about WHERE and HAVING clauses? (Choose two) |
| Option A | A. A WHERE clause can be used to restrict both rows and groups. |
| Option B | B. A WHERE clause can be used to restrict rows only. |
| Option C | C. A HAVING clause can be used to restrict both rows and groups. |
| Option D | D. A HAVING clause can be used to restrict groups only. |
| Option E | E. A WHERE clause CANNOT be used in a query of the query uses a HAVING clause. |
| Option F | F. A HAVING clause CANNOT be used in sub queries. |
| Correct Answer | B,D |