Question 1.
You executed the following command to back up the control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

What do you find in the trace file?

A. Image of the control file
B. Location of the control file
C. Contents of the control file in text format
D. SQL command to re-create the database
E. SQL command to re-create the database
F. Contents of the control file in binary format

Answer: E

Question 2.
Your boss at ITCertKeys.com wants you to clarify Oracle 10g. 

Which two steps are performed the first time any UPDATE statement is issued after the instance is started? (Choose two)

A. Creating the parse tree of the statement
B. Writing the modified data blocks to the data files
C. Writing the modified data to the archived redo log files
D. Updating the control file to indicate the most recent checkpoint
E. Updating the data file header to indicate the most recent checkpoint
F. Reading the blocks to database buffer cache if they are not already there

Answer: C, D

Question 3.
You work as a database administrator for ITCertKeys.com. 

You have been asked to use a centralized administrative tool to administer your database servers and application servers. 

In order to achieve the objective, which component would you configure on each database server?

A. Database Control
B. Management Server
C. Management Repository
D. Application Server Control
E. Oracle Management Agent

Answer: E

Question 4.
The data file belonging to the SYSTEM table space is corrupted and no backup of the file is available. 

How do you recover the data file?

A. The data file cannot be recovered.
B. The date file can be restored from the SYSTEM auto backup.
C. Take the table space offline, drop,k and re-create it.
D. Recovery Manager (RMAN) is used to recover the data file.
E. The ALTER DATABSE CREATE DATAFILE command is used to recover the data file.

Answer: A

Question 5.
You work as a database administrator for ITCertKeys.com. You started the instance using the init.ora file. You have two control files and three redo log groups in your database. 

You decided to protect the database against failures by adding one more control file. 

Which file is the appropriate way to perform this task?

A. Shut down the instance, copy the control file to the third location and open the database.
B. Abort the instance, copy the control file to the third location, modify the CONTROL_FILES 
    parameter in the init.ora file and open the database.
C. Copy the control file to the third location, modify the CONTROL_FILES parameter in the 
    init.ora file, restart the instance and open the database.
D. Shut down the instance, copy the control file to the third location, modify the 
    CONTROL_FILES parameter in the init.ora file and open the database.
E. Shut down the instance, startup in the mount state, copy the control file to the third location, 
    modify the CONTROL_FILES parameter in init.ora and open the database.

Answer: D

Question 6.
You work as a database administrator for ITCertKeys.com. You find that the database performance degrades while you backup the ITCERTKEYS database using Recovery Manager (RMAN). The ITCERTKEYS database is running in shared server mode. The database instance is currently using 60% of total operating system memory. 

You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?

A. Configure Java Pool to cache the java objects.
B. Configure Streams Pool to enable parallel processing.
C. Increase Shared Pool size to cache more PL/SQL objects.
D. Increase Database Buffer Cache size to increase cache hits.
E. Configure Large Pool to be used by RMAN and shared server.
F. Increase the total System Global Area (SGA) size to increase memory hits.

Answer: E

Question 7.
You work as a database administrator for ITCertKeys.com. You decided to manage client and server connections using Local Naming method in ITCertKeys.com. 

When you try to connect to the database you get the following error:
ERROR:
ORA-12154: TNS:could not resolve service name

Which network configuration files would you look into to resolve this error? Choose two.

A. snmp.ora
B. names.ora
C. spfile.ora
D. sqlnet.ora
E. listener.ora
F. tnsnames.ora

Answer: D, F

Question 8.
You work as a database administrator for ITCertKeys.com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. 

At this is production database, you want to accomplish this task with no impact on the user’s connections. 

Which activity must you have completed before accomplishing this task?

A. You must have started the database instance in restricted mode.
B. You must have started the database instance in NORMAL mode.
C. You must have started the database instance with server parameter file.
D. You must have started the database instance but must not have mounted.
E. You must have started the database instance but must not have opened.

Answer: C

Question 9.
Your ITCertKeys.com database is in ARCHIVELOG mode. The data file that belongs to the
SYSTEM table space has become corrupted. Up to what point can you recover the database?

A. Until last commit
B. Until the time you perform recovery
C. Until the time the date file got corrupted
D. Until the point where the last transaction begun
E. You cannot recover the SYSTEM table space and must re-create the database.

Answer: A

Question 10.
You work as a database administrator for ITCertKeys.com. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. 

Which statement regarding retention of undo data is correct?

A. Undo data becomes obsolete after 1,000 seconds.
B. Undo data gets refreshed after 1,000 seconds.
C. Undo data will be stored permanently after 1,000 seconds.
D. Committed undo data would be retained for 1,000 seconds if free undo space is available.
E. Undo data will be retained in the UNDO table space for 1,000 seconds, then it gets moved
    moved to the TEMPORARY table space to provide read consistency.

Answer: D

	Web www.certsbraindumps.com