Unformatted text preview: user-managed backup
D. both image copy and backup set
E. only incremental image copy backup
Your alert log file has the following information:
Tue May 25 17:43:38 2004
ORA-00060: Deadlock detected. More info in file
What would you do to ensure that database is still running correctly?
A. examine the trace file and kill the session that caused the deadlock
B. examine the trace file and kill both the sessions responsible for the deadlock
C. examine the trace file for details and ask the user who caused the deadlock to roll back
D. examine the trace file for details and remember that deadlocks are resolved
automatically by Oracle database
E. examine the trace file for details and use the Undo Advisor to rollback the transaction
that caused the deadlock
Answer: D Actualtests.com - The Power of Knowing 1Z0-042
While creating a database using Database Configuration Assistant tool, you created
a database default temporary tablespace. Which activity would cause the default
temporary tablespace of the database to be used?
A. the CREATE TABLE .. command
B. sorting of the SYSTEM tablespace's data
C. sorting of data required by recursive SQL statements
D. the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
E. sorting of data if the users have not been allocated temporary tablespace explicitly
F. sorting of data if the users have been allocated temporary tablespace explicitly
While running the Oracle Universal Installer on a Unix platform to install Oracle
Database 10g software, you are prompted to run orainstRoot.sh script. What does
this script accomplish?
A. It creates the pointer file.
B. It creates the base directory.
C. It creates the Inventory pointer file.
D. It creates the Oracle user for installation.
E. It modifies the Unix kernel parameters to match Oracle's requirement.
Exhibit: View the Exhibit to see the information on exis...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09