READ Free Dumps For Oracle- 1z0-023
| Question ID 8906 | Information about employees and departments is stored in two tables. Which of these business rules CANNOT be enforces by means of declarative integrity constraints?
|
| Option A | Employees must be assigned to an existing department
|
| Option B | Employee hire dates must precede employee termination dates.
|
| Option C | Employee badge numbers are unique. Some employees do not have a badge number.
|
| Option D | When employee salaries are updates, the new salary cannot be less than the old salary.
|
| Option E | Employees are uniquely identified by their employee IDs. Every employee has an employee ID.
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation: Answer D is correct. To enforce this type of restriction triggers need to be used, not declarative integrity constraints. Incorrect Answers: A: This business rule can be enforced by means of declarative integrity constraints. FOREIGN KEY constraint will help in this case. B: This business rule can be enforced by means of declarative integrity constraints. CHECK constraint will help in this case. C: This business rule can be enforced by means of declarative integrity constraints. UNIQUE constraint works in this case. E: This business rule can be enforced by means of declarative integrity constraints. PRIMARY KEY constraint enforces these restrictions. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 431-433 Chapter 9: Managing Database Objects I
| Question ID 8907 | Which command is NOT a valid syntax?
|
| Option A | ALTER INDEX summit.orders_region_id_idx COALESCE
|
| Option B | ALTER INDEX summit.orders_region_id_idx RESIZE 500M
|
| Option C | ALTER INDEX summit.orders_region_id_idx REBUILD ONLINE
|
| Option D | ALTER INDEX summit.orders_region_id_idx REBUILD TABLESPACE indx02
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. You cannot resize index to particular value. This command is incorrect. Incorrect Answers: A: You can coalesce unused space in index by this command. C: It's possible to rebuild index online. D: It's possible to use this command to move index data into different tablespace. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 416-425 Chapter 9: Managing Database Objects II