Questions(61-70)

QUESTION 61:
You need to recover five data files that are spread across multiple disks. Which
initialization parameter should you set to speed up redo application?
A. RECOVERY_PARALLELISM
B. FAST_START_MTTR_TARGET
C. LOG_CHECKPOINT_INTERVAL
D. FAST_START_PARALLEL_ROLLBACK
Answer: A
Explanation:
RECOVERY_PARALLELISM specifies the number of processes to participate in instance or
crash recovery. A value of 0 or 1 indicates that recovery is to be performed serially by one
process. You can enable parallel recovery to tune the cache recovery phase. During thread or
media recovery, the redo log is read, and redo blocks that are to be applied are parsed out.
These blocks are subsequently distributed evenly to all recovery processes to be read into the
buffer cache. Crash and instance recovery of datafiles on different disk drives are good
candidates for parallel recovery.

QUESTION 62:
You are ready to implement RMAN in the backup and recover strategy for your
company. Which system privilege must the RMAN user have to be able to connect and
execute RMAN commands on a target database?
A. SYSDBA
B. SYSOPER
C. No system privileges are required for the RMAN user.
D. Only SYS user can connect and execute RMAN commands on a target database.
Answer: A
Explanation:
The RMAN user should have the SYSDBA privilege to be able to connect and execute
RMAN commands.When we connect it doesnt ask for password bcoz it uses  authentication.


QUESTION 63:
Examine this syntax which allocates channels during a parallel image copy:
RMAN> CONFIGURE DEVICE TYPE disk parallelism 4:
2> COPY
3> datafile 1 TO '/BACKUP/datafile1.dbf',
4> datafile 2 TO '/BACKUP/datafile2.dbf',
5> datafile 3 TO '/BACKUP/datafile3.dbf;
RMAN>COPY
2> datafile 4 TO '/BACKUP/datafile4.dbf';
How many channels are used?
A. 0
B. 1
C. 3
D. 4
Answer: C
Explanation:
This command allocates 4 channels, but uses only 3 channels at a time and the parameter specifies that at a time we can simultaneously use 4 channels..A channel is the primary means
of communication between the Oracle server and the operating system. You can either
explicitly allocate a channel in a RUN block or RMAN allocates channels implicitly using
AUTOMATIC CHANNEL ALLOCATION. This RMAN command can be used to allocate 4
channels when backup, copy, or restore commands are issued.

QUESTION 64:
Users complain SQL statements using a particular index fail. Using DBVERIFY, you
find that two separate blocks in the index have become corrupt. The database data files
for user data and index are very large.
What is the least disruptive recover strategy available in Oracle9i?
A. Rebuild the index using the online option.
B. Take the individual data file offline (not the whole tablespace), restore and recover the
data file from backup with RMAN, then set the data file online again.
C. Without setting the individual data file offline, use RMAN with Block Media
Recovery to restore and recover only those blocks.
D. Take the individual data file (not the whole tablespace) offline, use RMAN with Block
Media Recovery to restore and recover only those blocks, then set the data file online
again.
Answer: C
Explanation:

 

Rebuilding Index is also an option but since only two blocks are corrupted we use BMR.

You can use RMAN with Block Media Recovery(BMR) to restore and recover only those blocks. It
is not required to set the individual data file offline. BMR enables you to back up specific
blocks in a datafile without taking the database offline. The default backup method is datafile
media recovery. You use the new BLOCKRECOVER statement to perform BMR.


QUESTION 65:
Which is a restriction on a list partitioned table?
A. You cannot create global range partitioned indexes on the table.
Actualtests.com - The Power of Knowing

1Z0-032
B. The optimizer will not execute partition wise joins on the table's partitions.
C. You must include at least one element in the value list of each partition of the table,
even if that element is the keyword NULL.
D. Partition pruning will not occur during query optimizer if a range of values is included
in the query predicate.
Answer: C
Explanation:
At least one element needs to be defined for each partition of the table. The set of values that
specifies a partition cannot be empty; it must contain at least one value.
Incorrect Answers
A: You can create global range partitioned indexes on the table.
B: The optimizer will execute partition wise joins on the table's partitions.
D: Partition pruning will occur during query optimization if a range of values is included in
the query predicate.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 102-107
Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features
QUESTION 66:
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
Explanation:
The LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a
Data Guard standby database with three attributes: SYNC or ASYNC for the network
transmission mode, LGWR or ARCH to identify the primary database process responsible for
sending redo information to the standby and AFFIRM or NOAFFIRM
to control whether log archiving disk write operations are to be performed synchronously or
asynchronously.
Incorrect Answers
D: There is no PROTECTED or UNPROTECTED attribute for the
Actualtests.com - The Power of Knowing

1Z0-032
LOG_ARCHIVE_DEST_n initialization parameter.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 86-99
Chapter 3: New Oracle9i Availability and Recoverability Features
QUESTION 67:
If you create your database using Oracle Managed Files (OMF), what is true?
A. You must use Oracle predefined names to identify raw partitions that will hold OMF
structures.
B. You must define directories for two online redo log groups and three copies of the
control file.
C. If your CREATE DATABASE command fails, any OMF database files that have
already been created will be dropped automatically.
D. You must use only OMF data files when adding new tablespaces or data files to your
database in the future.
Answer: A
Explanation:
You need to use Oracle predefined names to identify raw partitions that will hold OMF
structures. The following initialization parameters allow the database server to use the Oracle
Managed Files feature: DB_CREATE_FILE_DEST defines the location of the default file system
directory where Oracle creates datafiles or tempfiles when no file specification is given in the
creation operation, DB_CREATE_ONLINE_LOG_DEST_n defines the location of the default file
system directory for online redo log files and control file creation when no file specification is
given in the creation operation.
Incorrect Answers
B: You should define directories for OMF datafiles, redo log files and control files. Oracle9i
gives you two new initialization parameters, DB_CREATE_FILE_DEST and
DB_CREATE_ONLINE_LOG_DEST_n, to specify the location where Oracle will create
and manage OMFs; n can take a value from 1 to 5. So there is no limitation on control
files amount to 3 copies.
C: If your CREATE DATABASE command fails, any OMF database files that have already
been created will not be dropped automatically. This feature will work for the OMF
datafiles only after successful database creation.
D: It's not required if you created your database using Oracle Managed Files (OMF), you
must use only OMF data files when adding new tablespaces or data files to your database
in the future..
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Robert Freeman, p. 2-12
Chapter 1: Oracle9i Database Administration and Management Features
Actualtests.com - The Power of Knowing

1Z0-032
QUESTION 68:
In the Oracle9i Data Guard architecture, what is the purpose of the Log Transport
Services?
A. To transfer redo log information to one or more destinations.
B. To apply redo log records sent from the primary database to a standby database at the
receiving location.
C. To synchronize changes to the control files on all standby databases with changes on
the primary database when a log switch occurs.
D. To batch archived log files on the primary database until a defined number of
checkpoints have been processed and then to distribute the archives to each standby
database.
Answer: A
Explanation:
The Log Transport Service is comprised of several processes. On the primary database site,
the Log Writer updates the online redo logs with the transactions. It can also update the local
archived redo logs and send online redo logs transactions to the standby databases. The
Archiver saves the online redo log transactions on either local or standby archive logs. The
Fetch Archive Log (FAL) client gets redo log transactions from the primary database. When it
detects an archive log gap on the standby database, it initiates a request to the FAL server to
automatically send and archive the primary database's redo log transactions. The FAL server
exists on the primary database server, and it services requests from FAL clients.
Incorrect Answers
B: The Log Application Service applies the archived redo logs to the standby database.
C: Log Transport Services cannot synchronize changes to the control files on all standby
databases with changes on the primary database when a log switch occurs
D: They do not batch archived log files on the primary database.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 51-74
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 86-99
Chapter 3: New Oracle9i Availability and Recoverability Features
QUESTION 69:
The list below displays four steps that you need to execute in order to switch from the
primary database role to the standby database role.
Choose the correct order of execution for the steps.
1. Shot down and start up the former primary instance without mounting the
instance.
2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL
STANDBY command.
Actualtests.com - The Power of Knowing

1Z0-032
3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command.
4. End read or update activity on the former primary and standby database.
A. 1, 2, 3, 4
B. 3, 2, 4, 1
C. 4, 2, 1, 3
D. 4, 3, 2, 1
Answer: C
Explanation:
To switch from the primary database role to the standby database role you need to end to read
or update activity on the former primary and standby databases, issue the ALTER
DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command, shut
down and start up the former primary instance without mounting the instance, issue the
ALTER DATABASE MOUNT STANDBY DATABASE command.
Incorrect Answers
A: First you need to end to read or update activity on the former primary and standby
databases.
B: You need to issue the ALTER DATABASE MOUNT STANDBY DATABASE command
after the former primary database have been switched to standby mode.
D: You need to switch the former primary database to standby mode and restart instance
before you mount the former primary instance in standby mode.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 64-72
Chapter 2: Availability Enhancements
Oracle 9i New Features, Robert Freeman, p. 86-99
Chapter 3: New Oracle9i Availability and Recoverability Features
QUESTION 70:
What does the Metadata Application Programming Interface (API) allow you to do?
A. Repair damaged data dictionary entries.
B. Delete data dictionary information about database objects you no longer need.
C. Extract data definition commands from the data dictionary in a variety of formats.
D. Prepare pseudocode modules for conversion to Java or PL/SQL programs with a
Metadata code generator
Answer: C
Explanation:
Oracle9i has introduced a new package called DBMS_METADATE that enables you to
retrieve all the attributes of the database object from the data dictionary with one invocation.
Also you can use other methods, available in earlier versions of Oracle for documenting the
objects in an existing database: query the various tables in the data dictionary to obtain
Actualtests.com - The Power of Knowing

1Z0-032
information about an object, export/import utilities, OCIDescribeAny interface.
Incorrect Answers
A: The Metadata Application Programming Interface (API) does not allow you to repair
damaged data dictionary entries.
B: It is not used to delete data dictionary information about database objects you no longer
need.
D: The Metadata Application Programming Interface (API) does not prepare pseudocode
modules for conversion to Java or PL/SQL programs.
OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 136-138
Chapter 3: Manageability Enhancements
Oracle 9i New Features, Rob