Com the power of knowing 1z0 042 answer c question

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following command to delete rows from the DEPARTMENTS table: SQL>delete from DEPARTMENTS where DEPT_ID = 30; The command fails and displays the following error: ERROR at line 1: ORA-02292: integrity constraint (HR.SYS_C005374) violated - child record found Which two actions would you take to overcome this error? (Choose two.) A. alter the foreign key constraint to include the cascade option B. alter the foreign key constraint to include the on delete cascade option C. first, drop the EMPLOYEES table and then delete the rows from the DEPARTMENTS table D. first, drop the DEPARTMENTS table and then delete the rows from the EMPLOYEES table E. first, delete all of the rows from EMPLOYEES table and then delete the rows from the DEPARTMENTS table for department id 30 F. first, delete rows from the EMPLOYEES table for department id 30 and then delete the Actualtests.com - The Power of Knowing 1Z0-042 rows from the DEPARTMENTS table for department id 30 Answer: B,F QUESTION 123: As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead? A. Coalesce the application tables at a regular interval. B. Export and Import the application tables a regular interval. C. Drop and recreate the application tables at a regular interval. D. Move the application tables to a tablespace with less space usage. E. Distribute the application tables across multiple tablespaces depending on usage. F. Move the application tables to automatic segment space management tablespace. Answer: F QUESTION 124: On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.) A. data files B. control files C. tablespaces D. password file E. parameter...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online