hai

---

1. What criterion does Oracle9i use to determine whether a database file is
an Oracle Managed File?
A. The filename format.
B. Information stored inside a data dictionary table.
C. Information stored in the ALERT.LOG file
for the corresponding instance.
D. Information stored inside the corresponding initialization parameter file for the
instance.
Answer: A
2.
Which statement correctly describes the function of Oracle9i Cache Fusion feature?
A. It provides each session with its own view of the database at
a different point in the
past.
B. It enables you to execute scalable applications on a clustered database without having
to partition the users
or the database tables.
C. It lets you dynamically reassign memory in your database buffer cache to different
block buffer sizes.
D. It allows
you to add new sites to multimaster replication environment without
quiescing the master definition site.
Answer: B
3. What is the new Oracle
Shared Server?
A. An improved version of multithreaded server configuration.
B. A connection pooling configuration where several clients are
connected to the same
server process.
C. Two more database servers, which share data by means of database links; the client
software is unaware
to which server it is connected.
D. A configuration of Real Application Cluster where the client connection is routed to
the least busy
instance.
Answer: A
4. The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process
a request for a server process, the following tasks are performed:
1. A shared server picks up the request from the request queue and processes
the
request.
2. The dispatcher retrieves the response from the response queue.
3. A user sends a request to its dispatcher.
4. The dispatcher
returns the response to the user.
5. The shared sever places the response on the calling dispatcher's response queue.
6. The dispatcher places
the request into the request queue in the SGA.
Put the above task in the order in which they are performed.
A. 3, 1, 6, 2, 5, 4
B. 3, 6, 1, 5, 2,
4
C. 3, 1, 2, 3, 4, 5
D. 6, 1, 3, 5, 2, 4
E. 6, 3, 1, 2, 4, 5
F. 6, 3, 1, 2, 5, 4
Answer: B
5. A user is running a long update batch file.
Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user
calls you, what should you do as DBA?
A. Do nothing, the PMON process handles everything.
B. Shut down the database and restore all the tables the
user was updating.
C. Log in as DBA, clean up the partial updates in those tables, and do another manual
backup.
D. Use LogMiner to find out
which records are changed based on the user's ID, then roll
back all those changes.
Answer: A
6. Media recovery can sometimes be stopped by the
inability to read past a certain point in the redo stream. This is often referred to as "stuck recovery". Before Oracle9i, the Database
Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source, then all transactions
that committed after the corrupt point in the redo steam would be lost. Oracle9i changes that with the Trial Recovery feature. Trial Recover is used
to test the application of the redo logs to the database. What are three other characteristics of Trial Recovery (Choose three)
A. Speeds up
subsequent media recover actions.
B. Writes any uncorrupted block to disk during the test recovery.
C. Can be invoked by adding the TEST option to
any RECOVER command.
D. Allows the Administrator to determine how many blocks are affected by corruption.
E. Marks blocks as corrupt in memory,
allowing the test recover to proceed to
completion.
Answer: A, D, E
7. Which three statements about direct path exports are true? (Choose
three)
A. You cannot export rows containing collection data types.
B. Direct path exports can be performed interactively using exp.
C. The export
client, exp, writes data to the dump file without any unnecessary data
conversion.
D. The format and column specifications are identical to those
found in conventional-path
exports.
E. The direct path export type is noted in the output to the screen, in the export log file,
and the export
dump file.
F. Direct path export is essentially a SELECT * FROM TABLE statement with a complex (but highly optimized) query predicate.
Answer: A,
C, E
8. Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby
database? (Choose three)
A. SYNC or ASYNC to identify the network transmission mode.
B. LGWR or ARCH to identify the primary database process
responsible for sending
redo information to the standby.
C. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to
be
performed synchronously or asynchronously.
D. PROTECTED or UNPROTECTED to control the degree of divergence and data loss
at the standby
database.
Answer: A, B, C
9. You experienced a loss of data files in your database. You did not lose any of your control files. You are going to
use RMAN to restore and recover the database. Currently, your instance is shut down. Which sequence of commands is correct to restore and recover
your database?
A. RMAN> STARTUP NOMOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;
B. RMAN> STARTUP
MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN
C. RMAN> STARTUP NOMOUNT;
RMAN> RESTORE DATABASE;
RMAN>
RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
D. RMAN> STARTUP MOUNT;
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER
DATABASE OPEN RESETLOGS;
Answer: B
10. Which two statements regarding the control file and Recover Manager are true? (Choose two)
A. The control
file can grow in size.
B. The control file can store RMAN scripts.
C. CONTROL_FILE_RECORD_KEEP_TIME determines retention time for
RMAN
records.
D. The RMAN catalog can exist solely in the control file of the target database.
Answer: C, D
11. Examine the statement:
DROP
TABLESPACE IND2
INCLUDING CONTENTS
AND DATAFILES;
What is the result of the statement?
A. The contents and data files belonging to the IND2
tablespace are dropped.
B. The statement will only succeed if the IND2 tablespace was built using Oracle-Managed
Files (OMF) data files.
C. The
statement will only succeed if the data files belonging to the IND2 tablespace are
Oracle-Managed Files (OMF) or of the database was created using
OMF.
D. The contents of the tablespace are dropped along with all its data files except those
identical with the Oracle-Managed Files (OMF) naming
convention.
Answer: A
12. The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover? (Choose
two)
A. Restore the data file and perform incomplete recovery.
B. Restore the data file and perform point-in-time recover.
C. Drop the tablespace
and lose all data in the tablespace.
D. Restore the database and lose all data since the last backup.
Answer: C, D