This preview shows page 1. Sign up to view the full content.
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
Exhibit Which statement regarding thedeptandemptables are true?
A.When you delete a row from theemptable, you would receive a constraint violation
B.When you delete a row from the dept table, you would receive a constraint violation
Actualtests.com - The Power of Knowing 1Z0-042
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.
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
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.
- Fall '09