READ Free Dumps For Oracle- 1z0-007
| Question ID 1746 | Which three statements correctly describe the functions and use of constraints? (Choose three.) |
| Option A | A. Constraints make complex queries easy. |
| Option B | B. Constraints provide data independence. |
| Option C | C. Constraints enforce rules at the table level. |
| Option D | D. Constraints enforce rules at the view level. |
| Option E | E. Constraints prevent the deletion of a table if there are dependencies. |
| Option F | F. Constraints prevent the deletion of an index if there are dependencies. |
| Correct Answer | C,D,E |
| Question ID 1747 | What is true of using group functions on columns that contain NULL values? |
| Option A | A. Group functions on columns ignore NULL values. |
| Option B | B. Group functions on columns cannot be accurately used on columns that contain NULL values. |
| Option C | C. Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS. |
| Option D | D. Group functions on columns returning dates include NULL values. |
| Correct Answer | A |