Com while loading data into the certkiller staff

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: ing data into the Certkiller STAFF table using Oracle Enterprise Manager 10g Database Control, you find the status of the job as failed. On further investigation, you find the following error message in the output log: ORA-01653 unable to extend table HR. Certkiller STAFF by 8 intablespaceUSERS Which task would you perform to load the data successfully without affecting the users who are accessing the table? A.Restart the database instance and run the job B.Truncate the Certkiller STAFF table and run the job C.Delete all rows from the Certkiller STAFF table and run the job D.Increase the size of the USERStablespacethe and run the job E.Increase the size of the database default permanenttablespaceand run the job Answer: D QUESTION 21: Exhibit Which statement regarding thedeptandemptables are true? A.When you delete a row from theemptable, you would receive a constraint violation error. B.When you delete a row from the dept table, you would receive a constraint violation Actualtests.com - The Power of Knowing 1Z0-042 error. C.When you delete a row from theemptable, automatically the corresponding rows are deleted from the dept table. D.When you delete a row from the dept table, automatically the corresponding rows are deleted from theemptable. E.When you delete a row from the dept table, automatically the corresponding rows are updated with null values in theemptable. F.When you delete a row from theemptable, automatically the corresponding rows are updated with null values in the dept table. Answer: D QUESTION 22: You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available, and undo retention has been set to zero. What would you do to overcome this problem? A.Increase the undo return B.Create more undo segments C.Create another undotablespace D.Increase the size of the undotablespace Answer: D QUESTION 23: You are working on a test database where instance recovery takes a considerable amount of time. How can reduce t...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online