AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


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

Send email to admin@getfreedumps for new dumps request!!!