Which backup format can you use a backup set only b

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: user-managed backup D. both image copy and backup set E. only incremental image copy backup Answer: A QUESTION 169: Your alert log file has the following information: Tue May 25 17:43:38 2004 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. 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 the transaction 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 QUESTION 170: 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 Answer: E QUESTION 171: 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. Answer: C QUESTION 172: Exhibit: View the Exhibit to see the information on exis...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online