Questions(300-349)

QUESTION 300:
Which statement is true regarding database writer process (DBWn)?
A. It writes only committed data to the data files.
B. It synchronizes the database buffer cache and the data files regularly.
C. It makes changes to data blocks in the database buffer cache when required.
D. It is possible to configure more than one database writer process, but this is useful
only on uniprocessor systems.
Answer: B
 When you have long transaction and Buffer cache is not of enough memory to handle it,then DBWR writes uncommited data to datafiles.hence option A is wrong and B is right.

QUESTION 301:
You are using Recovery Manager (RMAN) to back up your database at regular
intervals. You are using recovery catalog to maintain the RMAN repository. On a
Monday, while trying to back up a data file you realize that the recovery catalog
database is down and you decide to back up the data file by using an operating
system command.
On Tuesday, after the recovery catalog database is functional you execute the
following command to register the previous day's backup in the RMAN repository:
RMAN>CATALOG DATAFILE COPY'/u01/oracle/backup/users01.dbf;
How can this backup be used to recover the data file in case of a corruption?
A. as a zero-level base backup for the incremental backups
B. as the lowest nonzero-level backup for the incremental backups
C. as the highest nonzero-level backup for the incremental backups
D. as the highest nonzero-level backup that requires the archived redo log files only
Answer: A
The manual backup taken has to be a whole database backup as its the only mode in which we get consistent backup.Hence it can be only used as base/level 0 backup.

QUESTION 302:
You are working in an Oracle Shared Server environment. You added one more
dispatcher to handle TCP requests. How would you verify that the dispatcher has
been registered when the instance was started?
A. by checking the entries in the listener.ora file

B. by checking the entries in the initialization parameter file
C. by checking the output of the lsnrctl show command
D. by checking the output of the lsnrctl services command
Answer: D

QUESTION 303:
You are working on a database and instance failure has occurred due to a power
outage. You want to bring the instance up. From what point in the redo log file does
instance recovery begin and where does it end?
A. from the checkpoint position to the end of the redo log file
B. from the beginning of the oldest online redo log file to the checkpoint position
C. from the beginning of the current redo log file to the end of inactive redo log file
D. from the beginning of the inactive redo log file to the end of current redo log file
Answer: A
An Checkpoint indicates that all the transactions before checkpoint have been saved to database on the HDD.hence recovery is needed for the data which has been generated after the checkpoint.

QUESTION 304:
Which two statements regarding backup sets are true? (Choose two.)
A. A backup set may contain both data files and control files.
B. Each file in a backup set must have the same Oracle block size.
C. A backup set may contain both data files and archived redo log files.
D. A backup set may contain both a control file and archived redo log files.
Answer: A, B


QUESTION 305:
You have set the control file autobackup to ON by using the following command in
the Recovery Manager (RMAN):
CONFIGURE CONTROLFILE AUTOBACKUP ON;
Which two events would cause the control file to be backed up automatically?
(Choose two.)
A. when a tablespace is added
B. when the database instance is restarted
C. when a successful backup is recorded in the RMAN repository
D. when the RMAN connection is disconnected from the target database
Answer: A, C

QUESTION 306:
The database writer (DBWn) uses the checkpoint queue to identify blocks while
writing data from the database buffer cache to data files. What type of information
is stored in each entry of the checkpoint queue? (Choose three.)
A. data file name
B. data block size
C. data file number
D. redo log file name
E. data block number
F. tablespace number
G. the Redo Byte Address (RBA)
Answer: C, E, G
data file name,data block size,redo log file name or tablespace number does not help to identify a datablock uniquely.where as to identify the block which is to be written we use
datafile number:::inside datafile block number and RBA(address of the redo data generated by this block)


QUESTION 307:
You are using operating system tools or utilities to back up your production
database. Your organization decides to use Recovery Manager (RMAN) to back up
the database starting from next Monday and you have been asked to register all
operating system (OS) backups in the RMAN repository. Which RMAN command
would you use for this?
A. COPY
B. BACKUP
C. CATALOG
D. DUPLICATE
E. CREATE CATALOG
Answer: C
CATALOG  :Its function of CATALOG command to make an entry in rman repository.

QUESTION 308:
Your database is configured for shared server. A particular client requires a
dedicated server. Select two actions that you can perform to configure the client to
use a dedicated server. (Choose two.)
A. configuring the listener.ora file with USE_DEDICATED_SERVER=o n
B. configuring the client profile (sqlnet.ora file) with USE_DEDICATED_SERVER=on
C. specifying the SESSIONS=1 attribute for the DISPATCHERS parameter in the
initialization parameter file
D. configuring a net service name with a connect descriptor that contains
(server=dedicated) in the CONNECT_DATA section
Answer: B, D

QUESTION 309:
You receive the following error while connecting to an Oracle9i database instance:
ORA-12523 TNS:listener could not find instance appropriate for the client
connection
Which action would be appropriate in the context of investigating the cause of
error?
A. checking the listener.ora file to verify that the protocol specified in ADDRESS is
supported by the database server
B. checking the sqlnet.ora file to verify that the NAMES.DIRECTORY_PATH =
(TNSNAMES,HOSTNAME)parameter is set
C. executing the lsnrctl services command to verify that the instances are registered with
the listener, and have the READY status.
D. checking the tnsnames.ora file to verify that the net service name specified in your
connect string is mapped to a connect descriptor
Answer: C

QUESTION 310:
You work on a database that is used for application development and operates in
ARCHIVELOG mode. As a DBA, you know that database downtime can be
tolerated and have designed a backup strategy containing a weekly closed database
backup. The local naming method is used by clients to connect to the database.
Which files should you include in this weekly user-managed backup? (Choose all
that apply.)
A. control file
B. sqlnet.ora file
C. archived log files
D. tnsnames.ora file
E. listener configuration file
Answer: A, C

Controlfile is must for consistent backup and since there is no option of datafile,we back up only archived logfile.Which in turn can help to recover datafile.

QUESTION 311:
In your Oracle9i database, INSTANCE_NAME and SERVICE_NAMES
parameters are set. Which statement is correct regarding the service registration
with the default local listener?
A. You must manually configure the listener.ora file to enable PMON to register service
information with the listener automatically.
B. By default, the PMON process automatically registers service information with its
local listener on the default local address of TCP/IP, port 1521.C. You must configure the LOCAL_LISTENER parameter in the initialization parameter
file to enable PMON to register service information with the listener automatically.
D. You must set the NAMES.DIRECTORY_PATH = (TNSNAMES,HOSTNAME)
parameter in the sqlnet.ora file to enable PMON to register service information with the
listener automatically.
Answer: B
In Oracle 8i we needed to register manually but in 9i PMON registers all by itself.Only required input from  user side is values for two parameters and they are INSTANCE_NAME and SERVICE_NAMES.

QUESTION 312:
You need to change your test database from NOARCHIVELOG mode to
ARCHIVELOG mode. In the process you execute the ALTER DATABASE
command to change the database to ARCHIVELOG mode. What will be the
outcome of this command?
A. It opens the database and sets the database in ARCHIVELOG mode.
B. It sets the database in ARCHIVELOG mode and updates the control file.
C. It updates the header of all the data files and sets the database in ARCHIVELOG
mode.
D. It enables the Archiver (ARCn) processes and sets the database in ARCHIVELOG
mode.
Answer: B
Changing database from noarchivelog mode to archivelog mode makes an entry in Controlfile,also its just mode has been change but we still need to start arcn process.only then archiving will be performed or else we need to archive manually.

QUESTION 313:
There are three databases in your company: PDDB, QTDB, and SLDB. A single
RMAN recovery catalog is used for all the three databases. In the recovery catalog
you have a stored script, Level0Backup, created for performing a level 0 backup.
For which database will the backup be performed when you execute this script?
A. all the three databases
B. depends on the channel allocation
C. the target database to which RMAN is connected
D. the database configured using the CONFIGURE command at the command line before
calling the script
Answer: C
QUESTION 314:
You have configured the Oracle Shared Server. Which initialization parameter
would you configure so that the shared pool is not used for the shared server-related
User Global Area (UGA)?
Actualtests.com - The Power of Knowing

1Z0-032
A. CIRCUITS
B. SESSIONS
C. PRIVATE_SGA
D. LARGE_POOL_SIZE
E. PGA_AGGREGATE_TARGET
Answer: D
QUESTION 315:
While using Oracle Import utility to import the ORDERS table, the CREATE
TABLE command in the export dump file fails because the structure of the table
already exists. What should you do to avoid this error and continue loading data
into the ORDERS table?
A. set IGNORE to Y
B. set DESTROY to Y
C. set COMPILE to Y
D. set CONSTRAINTS to N
E. set TOID_NOVALIDATE to ORDERS
Answer: A
QUESTION 316:
Which option must you specify in the sqlnet.ora file on the client machines to enable
clients to use the host naming method?
A. names.addresses
B. names.default_domain
C. names.directory_path
D. names.preferred_servers
E. sqlnet.authentication_services
Answer: C
QUESTION 317:
Which two statements are true regarding Recovery Manager (RMAN) recovery?
(Choose two.)
A. RMAN always recovers all data files including the SYSTEM data file.
B. RMAN can be used to recover a corrupted data block in any data file.
C. RMAN always recovers the current control file and the SYSTEM data file.
D. RMAN prompts for the required archived redo log files while recovering a corrupted
file.
Actualtests.com - The Power of Knowing


1Z0-032
E. RMAN uses the archived redo log files and online redo log files to recover a restored
file without prompting for the file names.
Answer: B, E
QUESTION 318:
A single SQL*Loader input data file might contain records in a variety of formats.
Click the Exhibit button and examine the data shown, in which EMP and DEPT
records are intermixed (DEPT records are indicated by 1 and EMP records are
indicated by 2).
Which two statements can you use to load the data shown in the Exhibit into the
DEPT and EMP tables? (Choose two.)
Exhibit:
A.
A. INTO TABLE dept
WHEN recid = 1
(recid FILLER POSITION(1:1) INTEGER EXTERNAL,
deptno POSITION(3:4) INTEGER EXTERNAL,
dname POSITION(8:21) CHAR)
INTO TABLE emp
WHEN recid <> 1
(recid FILLER POSITION(1:1) INTEGER EXTERNAL,
empno POSITION(3:6) INTEGER EXTERNAL,
ename POSITION(8:17) CHAR,
deptno POSITION(19:20) INTEGER EXTERNAL)
B. INTO TABLE emp
(empno POSITION(1:4) INTEGER EXTERNAL,
ename POSITION(6:15) CHAR)
INTO TABLE dept
(empno POSITION(17:20) INTEGER EXTERNAL,
ename POSITION(21:30) CHAR)
C. INTO TABLE dept
WHEN recid = 1
(recid FILLER INTEGER EXTERNAL TERMINATED BY WHITESPACE,
deptno INTEGER EXTERNAL TERMINATED BY WHITESPACE,
dname CHAR TERMINATED BY WHITESPACE)
INTO TABLE emp
WHEN recid <> 1
Actualtests.com - The Power of Knowing

1Z0-032
(recid FILLER POSITION(1) INTEGER EXTERNAL
TERMINATED BY ' ',
empno INTEGER EXTERNAL TERMINATED BY ' '
ename CHAR TERMINATED BY WHITESPACE,
deptno INTEGER EXTERNAL TERMINATED BY ' ')
D. D. INTO TABLE emp
(empno INTEGER EXTERNAL TERMINATED BY " ",
ename CHAR TERMINATED BY WHITESPACE)
INTO TABLE dept
(empno INTEGER EXTERNAL TERMINATED BY " ",
ename CHAR) TERMINATED BY WHITESPACE)
Answer: A, C
QUESTION 319:
Which statement describes the function of the database writer process (DBWn)?
A. It writes only committed data to the data files.
B. It is created when the first user session is established.
C. It ensures that a sufficient number of free buffers are available in the database buffer
cache.
D. It synchronizes the headers of the data files and control files with the current redo log
and checkpoint numbers.
Answer: C
QUESTION 320:
As a DBA, you need to design a backup strategy that conforms to the operational
and business requirements of your organization. Which two cases prompt you to
include consistent backups in your backup strategy? (Choose two.)
A. database downtime is tolerated
B. database is in NOARCHIVELOG mode
C. database contains only locally managed tablespaces
D. database contains only dictionary-managed tablespaces
E. database does not have multiplexed control files and redo log files
Answer: A, B
QUESTION 321:
What action can you take to reduce the recovery time in case of instance failures?
A. use an SPFILE
Actualtests.com - The Power of Knowing

1Z0-032
B. multiplex the control files
C. reduce the number of data files used by the database
D. reduce the number of redo log members in each group
E. configure database parameters to increase the frequency of checkpoints
Answer: E
QUESTION 322:
Your database is in ARCHIVELOG mode and four archive destinations are defined
for your database. You notice that one of the disks mapped to an archive destination
has become inaccessible. You are using the RMAN BACKUP command to perform
a backup of the database including archived log files. What would happen if RMAN
tries to back up the archived log files from this location?
A. The backup operation fails with an error.
B. The backup operation waits for your intervention.
C. The backup completes without archived log files in it.
D. The backup completes successfully as RMAN picks up archived logs from the other
archive destinations.
Answer: D
QUESTION 323:
Which statement regarding the RMAN repository stored in the control file is true?
A. The repository never gets overwritten.
B. The repository is used to store the RMAN scripts.
C. The repository is used to store information about only one target database.
D. The repository can be used to store information about backups from different
incarnations of the database.
Answer: C
QUESTION 324:
You need to insert rows into a table named ORDERS from the source table,
ORDERS_C, which you received from your client. Because the number of rows is
significantly high, you decide to use Parallel Direct Load to make the insert process
faster. Which two options could you use to achieve this? (Choose two.)
A. use DIRECT hint in the INSERT statement
B. use PARALLEL hint in the INSERT statement
C. use PQ_DISTRIBUTE option in the INSERT statement
D. use PARALLEL_INDEX option in the INSERT statement
Actualtests.com - The Power of Knowing

1Z0-032
E. alter the ORDERS table to specify the PARALLEL clause before inserting the rows
Answer: B, E
QUESTION 325:
You are archiving to four destinations as shown below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /DB01/u01/archive' MANDATORY
LOG_ARCHIVE_DEST_2 = 'LOCATION = /DB01/u02/archive'
LOG_ARCHIVE_DEST_3 = 'LOCATION = /DB01/u03/archive' MANDATORY
LOG_ARCHIVE_DEST_4 = 'LOCATION = /DB01/u04/archive'
You want to ensure that the archiver successfully archives to at least three of these
locations. However, you do not want the system to halt if it cannot write to all four
destinations. Which option would you use to accomplish this task?
A.
set LOG_ARCHIVE_MIN_SUCCEED_DEST=1 for successfully archiving to one
OPTIONAL destination in addition to the two MANDATORY destinations
B. set LOG_ARCHIVE_MIN_SUCCEED_DEST=2 for successfully archiving to two
OPTIONAL destinations
C. set LOG_ARCHIVE_MIN_SUCCEED_DEST=3 for successfully archiving to both
MANDATORY destinations and one OPTIONAL destination
D. set LOG_ARCHIVE_MIN_SUCCEED_DEST=4 for successfully archiving to the
MANDATORY destinations and both OPTIONAL destinations
Answer: C
QUESTION 326:
Which three statements are correct regarding the listener process? (Choose three.)
A. A listener can be configured to listen for multiple protocols.
B. Multiple listeners cannot listen on behalf of a single database.
C. The name of the listener should be unique per listener.ora file.
D. A listener can listen for a single database only and not multiple databases.
E. The listener transfers the connection request to a dispatcher in a Shared Server
configuration.
F. The listener transfers the connection request to the Connection Manager in a Dedicated
Server configuration.
Answer: A, C, E
QUESTION 327:
Which statement correctly describes RMAN backup and recovery?
A. You cannot use RMAN to perform inconsistent backups.
Actualtests.com - The Power of Knowing

1Z0-032
B. RMAN skips fractured data blocks during backup of online files
C. RMAN does not allow parallelization of backup and restore operations.
D. RMAN backup includes all data blocks, regardless of whether they contain data.
E. RMAN allows you to recover a database that operates in NOARCHIVELOG mode.
Answer: E
QUESTION 328:
You are using RMAN for the backup and recovery of your database. You want the
control file to be backed up and have configured control file autobackup to ON by
using the CONFIGURE command. Which two events would cause the control file to
be backed up automatically? (Choose two.)
A. A tablespace is taken offline.
B. The database instance is restarted.
C. A new data file is added to an existing tablespace.
D. A successful backup is recorded in the RMAN repository.
E. The RMAN connection is disconnected from the target database.
Answer: C, D
QUESTION 329:
You are using Recovery Manager (RMAN) to back up your database at regular
intervals. On Monday morning, you find that the media that has the users.dbf data
file is corrupted. You use the RMAN SET NEWNAME command to restore the file
to a new location. Which RMAN command would you use to update the control file
with the new location?
A. SET
B. SWITCH
C. RESYNC
D. CHANGE
E. REGISTER
Answer: B
QUESTION 330:
Because of some data loss, you have to perform a Time-Based incomplete recovery
of your test database. After applying the required archived redo log files, what is the
next step that you would perform?
A. open the database with the RESETLOGS option
B. open the database without specifying any option
Actualtests.com - The Power of Knowing

1Z0-032
C. open the database with the NORESETLOGS option
D. shut down and restart the database in OPEN mode
E. shut down and restart the database in MOUNT mode, and then manually open it
Answer: A
QUESTION 331:
Your database has 10 tablespaces. A few days ago, one of the tablespaces was made
read only. In case of a media failure necessitating a tablespace recovery, which type
of tablespace can be re-created rather than recovered?
A. Undo tablespace
B. Users tablespace
C. System tablespace
D. Read-only tablespace
E. Temporary tablespace
Answer: E
QUESTION 332:
You plan to perform a backup of the control file in your database. Which two
statements regarding the control file backup are true? (Choose two.)
A. You can back up the control file to a binary file.
B. You must bring the database to the NOMOUNT state to perform the control file
backup.
C. You must store all types of control file backups in the location defined by
USER_DUMP_DEST.
D. You can back up the control file by generating a script that can be used to re-create the
control file.
Answer: A, D
QUESTION 333:
You require a backup of a database that operates in NOARCHIVELOG mode. You
performed a backup of the entire set of data files and control files, but excluded
online redo log files from this backup. Which statement regarding this backup is
true?
A. This type of backup is possible only when the database is open.
B. The files in this backup are all consistent, and, therefore, the online redo log files are
not needed in the backup.
C. The backup performed is incomplete and of no use because online redo log files are
Actualtests.com - The Power of Knowing

1Z0-032
not included in this backup.
D. The backup performed is considered an inconsistent backup because online redo log
files have been excluded from the backup.
Answer: B
QUESTION 334:
You are working on the PDDB database. You find that a tablespace is full, so you
add a data file to the tablespace. You are using RMAN to perfor m backup and
recovery of the database. You used recovery catalog to connect to RMAN and
executed the following command to perform the backup:
RMAN>backup database;
Which statement regarding this command is true?
A. The command works only if the recovery catalog is synchronized.
B. The command works only if the control file autobackup is configured to ON.
C. The command performs the backup of all the database files except the new data file.
D. The command synchronizes the recovery catalog automatically and performs the
backup successfully.
Answer: D
QUESTION 335:
You need to change the name of a net service name without changing any domains.
Which net configuration file would you edit?
A. names.ora only
B. sqlnet.ora only
C. tnsnames.ora only
D. names.ora and sqlnet.ora
E. tnsnames.ora and sqlnet.ora
Answer: C
QUESTION 336:
You want to maintain the logical backup of all the application tables at regular
intervals. Which option would you use to achieve this?
A. Wallet Manager
B. SQL *Loader utility
C. Oracle Export utility
D. Oracle Directory Manager
Actualtests.com - The Power of Knowing

1Z0-032
Answer:
QUESTION 337:
Under which conditions would you perform an incomplete recovery of a database?
(Choose all that apply.)
A. when the instance of the database has crashed
B. when media failure destroys some or all of the online redo logs that were not archived
C. when complete recovery cannot be performed because an archived redo log is missing
D. when the current control file is lost, is not multiplexed and a backup control file is to
be used to open the database
Answer: B, C, D
QUESTION 338:
In your production database, you observe that one of the data files is corrupted
while the database was functional. When investigating the reason, you find that the
media has crashed and now you have to restore the data file to a different location
while the database is functional. You have the option of using the following steps:
1. Take the tablespace offline by using the ALTER TABLESPACE command in
IMMEDIATE mode.
2. Restore the data file to a new location.
3. Apply the archived redo log files.
4. Use the ALTER DATABASE command to update the control file.
5. Bring the tablespace online by using the ALTER TABLESPACE command.
Which sequence of steps would you use to restore the data file, ensuring near to zero
downtime?
A. 4, 3
B. 2, 4, 3
C. 1, 2, 3, 5
D. 1, 3, 4, 5
E. 1, 2, 4, 3, 5
Answer: E
QUESTION 339:
In your database, there is a large transaction modifying very crucial data. A
hardware problem caused instance failure and the instance went down before all the
writes to the data files were completed. Which statement is true?
A. On startup, PMON coordinates instance recovery and opens the database.
Actualtests.com - The Power of Knowing

1Z0-032
B. On startup, CKPT coordinates instance recovery and opens the database.
C. After the database is opened, all the uncommitted changes will be rolled back.
D. On startup, RECO process performs instance recovery and opens the database.
E. On startup, RMAN is automatically invoked to perform instance recovery and open
the database.
Answer: C
QUESTION 340:
You are using Recovery Manager (RMAN) to back up your database at regular
intervals. The database is running in ARCHIVELOG mode. On Monday morning,
you find that users are unable to access the USERS tablespace. On investigation,
you find that all the data files that belong to the USERS tablespace are corrupted
and you do not have any logical back up of the database. Which two options could
you use to recover the tablespace along with the data, without affecting other data
files? (Choose two.)
A. drop and re-create the USERS tablespace
B. restore and recover the corrupted data files by using the RESTORE DATAFILE and
RECOVER DATAFILE commands
C. restore and recover the data files by using the RESTORE DATABASE and
RECOVER DATABASE commands
D. restore and recover the tablespace by using the RESTORE TABLESPACE and
RECOVER TABLESPACE commands
Answer: B, D
QUESTION 341:
Which backups can be performed without shutting down the instance? (Choose all
that apply.)
A. an image copy backup
B. a backup of the database running in NOARCHIVELOG mode
C. a backup of dictionary-managed tablespace if the database is in ARCHIVELOG mode.
D. a backup of the database when all read/write datafiles and control files are
checkpointed with respect to the same system change number (SCN).
Answer: A, C
QUESTION 342:
Which statement is true regarding a Recovery Manager (RMAN) incomplete
database recovery using UNTIL SEQUENCE?
Actualtests.com - The Power of Knowing

1Z0-032
A. RMAN will reset the current sequence number to the number specified.
B. RMAN will restore data files from the most appropriate backup, and then recover
them up to the specified sequence number.
C. RMAN will ignore the number specified if the THREAD option is not specified and
continue the normal restore and recovery processes.
D. RMAN will restore the data files up to the sequence number specified, from the most
appropriate backup and then recover by applying all available archived redo log files up
to the number specified.
Answer: B
QUESTION 343:
You are configuring a listener by using Oracle Net Manager. You want the listener
to be stopped by an authorized user only. What would you do?
A. set a listener password
B. provide the SNMP contact information
C. set a listener userid and password
D. add the listener owner to the DBA group at the operating system (OS) level
Answer: A
QUESTION 344:
In your test database, you want to maintain a backup of the complete database on a
daily basis by using Full Database Mode of Oracle Export utility. You execute the
following command every night:
$ exp system/manager \\
full=Y \\
file=$ORACLE_HOME/backup/feb-2004/full_11.dmp \\
log=$ORACLE_HOME/backup/feb-2004/full_11.log
The objects of which users will not be exported as a result of this command?
A. SYS
B. SYSTEM
C. the users that have the DBA role granted
D. the users that do not have the CONNECT role granted
E. the users that do not have the EXP_FULL_DATABASE role granted
Answer: A
QUESTION 345:
View the Exhibit.
Examine the value set for the NAMES.DIRECTORY_PATH parameter in the
Actualtests.com - The Power of Knowing


1Z0-032
sqlnet.ora file. You are working in a TCP/IP network environment. What will
happen when you try to connect to the database from a remote client?
Exhibit:
A. The local naming method will be used first to resolve a connect identifier.
B. It will result in an error because two values cannot be specified for the
NAMES.DIRECTORY_PATH parameter.
C. If the local naming method is unable to resolve the connect identifier, then Oracle
Names server will be used to resolve the connect identifier.
D. If the host naming method is unable to resolve the connect identifier, then the net
service name stored in a centralized LDAP-compliant directory server is used to resolve
the connect identifier.
Answer: A
QUESTION 346:
Last Friday, you performed a closed database backup of your database that is
running in NOARCHIVELOG mode. On Monday morning, you discover that the
media that contains one of the data files is corrupted. Now, you need to recover your
database. Which two tasks would you perform before you start recovering the
database? (Choose two.)
A. restore all data files
B. restore password files
C. restore the control files
D. restore the redo log files
E. restore the parameter file
F. restore the server parameter file
G. restore the corrupted data file only
Actualtests.com - The Power of Knowing

1Z0-032
Answer: A, C
QUESTION 347:
Using Recovery Manager (RMAN) you backed up your database on Friday evening.
On Monday morning, you added a new tablespace to the database and backed up
the newly added tablespace. Then, you executed the following command:
RMAN>CROSSCHECK BACKUPSET OF DATABASE;
Which task does this command accomplish?
A. It checks for synchronization of only the backup sets and not the backup pieces.
B. It checks for synchronization of the backup set that contains the newly added
tablespace.
C. It checks for synchronization of the backup set that contains the SYSTEM tablespace
only.
D. It checks for synchronization of all backup sets including the backup pieces and proxy
copies.
E. It checks for synchronization of the backup set excluding the set that contains the
SYSTEM tablespace.
Answer: D
QUESTION 348:
While starting up the database on a Monday morning, you get the following error
after the database is mounted:
ORA-01157: cannot identify/lock data file 9-see DBWR trace file
ORA-01110: data file 9:'/u01/oracle/app/oradata/orcl/users01.dbf'
While investigating, you realize that a backup of the data file (users01.dbf) exists.
Which data dictionary view would you use to locate the archived redo log files that
are required for recovery?
A. V$ARCHIVED_LOG
B. V$RECOVERY_LOG
C. V$RECOVER_FILE
D. V$RECOVERY_STATUS
Answer: B

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

Questions(51-60)

QUESTION 51:
The direct handoff connection method to an Oracle9i Shared Server involves fewer
messages than in previous releases of the multithreaded architecture.
Which type of message has been eliminated?
A. The initial request from the client to the listener.
B. Messages between the dispatcher and the shared server background processes.
C. A redirect message from the listener to the client during client connections.
D. Round-trip messages between the listener and the shared server background processes.
Answer: C
Explanation:
When a client machine initiates a shared server connection to the database in Oracle9i, the
listener uses the direct handoff whenever possible. This connection process requires fewer
network calls and, accordingly, less overhead.
When the listener receives the request from the client for a shared server connection, it locates
the address of the least loaded dispatcher process. In previous versions, the next step would
have been to pass this address back to the client for the client to contact the dispatcher again
over the network. Instead, in Oracle9i's direct handoff method, the listener hands the
connection request to the dispatcher. The dispatcher communicates directly with the client to
establish a connection without the need for the additional network calls that were required in
previous versions.

QUESTION 52:
The CURSOR_SHARING parameter is set to SIMILAR at the instance level and you
issue these SELECT statements in the order shown below:
SELECT * FROM employees WHERE department_id=50;
SELECT * FROM employees WHERE department_id=70;
There is an index on the DEPARTMENT ID column of the 1,000,000 row EMPLOYEES
table. Ninety percent of the employees are part of the DEPARTMENT_ID 50.
In which two scenarios will Oracle9i share the corresponding cursors for the two
statements? (Choose two)
A. You are using the rule-based optimizer.
B. You are using the cost-based optimizer with up-to-date statistics but with no
histograms.
C. You are using the cost-based optimizer with up-to-date statistics and histograms
computed for the DEPARTMENT_ID column.
D. You are using the cost-based optimizer with up-to-date statistics and histograms
computed for the DEPARTMENT_ID column and system statistics gathered.
Answer: A, B
Explanation:

Oracle9i will share the corresponding cursors for the two statements if you are using the rulebased
optimizer or the cost-based optimizer with up-to-date statistics but with no histograms.

QUESTION 53:
An index-organized table (IOT) called SPARSE has had many records deleted.
Which command reorganizes the IOT so that the empty space is removed, while
minimizing the impact for users?
A. EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
B. ALTER TABLE ... COALESCE ;
C. ALTER INDEX ...REBUILD ONLINE;
D. CREATE TABLE ...AS SELECT_ONLINE;
Answer: B
Explanation:
COALESCE means De fragmentation.It separates used memory from free memory.
The ALTER TABLE table_name COALESCE statement will reorganize the IOT. The rebuild
operation creates a new tree to defragment the index, as opposed to the coalesce operation that
coalesces the leaf blocks within the same branch of the tree.Data is places at the leaf node of a tree index or IOT.hence COALESCE data means COALESCE used leaf from unused leaf.e.g if lead1 has 40% data and leaf2 has 30% data then after COALESCE leaf1 will have 70%data and leaf2 will be 100% free.

QUESTION 54:
Data file DF1 belongs to tablespace TS1.,and the database is in ARCHIVELOG mode.
You did an incomplete recover in the following steps:
1. Take data file DF1 offline.
2. Copy a backup copy of DF1 into the current DF1 location.
3. Execute RECOVER DATAFILE UNTIL TIME sometime in the past.
4. Bring DF1 online.
5. Execute ALTER DATABASE OPEN RESETLOGS.
To guarantee that the database is recoverable in the future, what is the least amount of
work needed?
A. Back up the data file.
B. Bring tablespace TS1 online.
C. Copy redo logs to the backup directory.
D. Make a complete backup right after opening the database.
Answer: D
Explanation:
Its an thumb rule that we need to take backup after and before(corrupt data backup manually) incomplete recovery.

After any type of incomplete recovery a complete backup is required immediately after
opening the database. It needs to be done because of resetlogs option: after resetting logs any
previous backup is unusable any more.


QUESTION 55:
QUESTION 56:
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
Explanation:
It is not possible to export rows with collection data types(varray and nested tables)"Restrictions for Direct Path Exports
Keep the following restrictions in mind when you are using direct path mode:
To invoke a direct path Export, you must use either the command-line method or a parameter file. You cannot invoke a direct path Export using the interactive method.
The Export parameter BUFFER applies only to conventional path Exports. For direct path Export, use the RECORDLENGTH parameter to specify the size of the buffer that Export uses for writing to the export file.
You cannot use direct path when exporting in tablespace mode (TRANSPORT_TABLESPACES=Y).
The QUERY parameter cannot be specified in a direct path Export.
A direct path Export can only export data when the NLS_LANG environment variable of the session invoking the export is equal to the database character set. If NLS_LANG is not set or if it is different than the database character set, a warning is displayed and the export is discontinued. The default value for the NLS_LANG environment variable is AMERICAN_AMERICA.US7ASCII." .


QUESTION 57:
In RMAN, when the RESYNC CATALOG command is issued, in which two situations
does the command file actually perform synchronization? (Choose two)
A. After the COPY command.
B. After adding a data file in the target database.
C. After adding a tablespace in the target database.
D. After adding a tablespace in the catalog database.
E. After dropping a data file in the catalog database.
F. After running SQL Loader to load a large amount of data.
Answer: B, C
Explanation:
If you issue RESYNC CATALOG after COPY and BACKUP command then there will be no sync done.Bcoz COPY and BACKUP command are auto sync command.but after adding a datafile or tablespace RESYNC CATALOG will actually performe sync between catalog and controlfile.

 QUESTION 58:
Archive file format LOG_ARCHIVE_FORMAT is defined as arch_%s.arc. A week ago,
you just archived arch_4.arch to tape, then removed all archived files to save disk space.
Yesterday you saw arch_10.arc and arch_11.arc on the disk. Today, you see arch_3.arc
in the archive directory. Which two could you happened? (Choose two)
A. Redo logs were restored from tape for recovery.
B. The file names are only used when they are copied to tape.C. The database was opened with the RESETLOGS option and log numbers restarted.
D. Log names run in circular fashion; arch_3.arc is re-created by the ARCn process.
E. A file name is randomly chosen by the archive process; as long as it is unique, it does
not have to be sequential.
Answer: A, C
Explanation:
If you see arch_3.arc in the archive directory again, it means that redo logs restore from tape
happened and or the database was opened with the RESETLOGS option and the log files
sequence have been restarted.

QUESTION 59:
What is true about this statement used during import?
imp hr/hr tables= (employee, departments) file=hr.dmp ignore=y
A. It ignores duplicates.
B. It prevents character set translation on import.
C. It allows rows to be inserted into a table that already exists.
D. It ignores storage parameters in the DML executed during import.
Answer: C
Explanation:
If a table already exists at the target database where we are importing data and ignore=y, then the rows are imported to the existing tables, otherwise errors will be reported and no rows are loaded into the table. The IGNORE=Y option allows rows to be inserted into a table that already exists.

QUESTION 60:

Click the Exhibit button and examine the diagram, which illustrates the components
performing tasks within an Oracle Shared Sever environment.
Which task is being performed by component 4?
A. The PMON process registers the request in the response queue.
B. A shared sever places the process request in the response queue.
C. A request within the request queue is processed by an idle shared server process.
D. A dispatcher assigns a request from the request queue to and idle shared server
process.
Answer: C
Explanation:
An idle shared server process will process a request within the request queue.

Questions(41-50)

QUESTION 41:
You company has four DBAs. You need to know which DBA added a column to the
JOB_HISTORY table. The database cannot be offline during work hours. Which
LogMiner command can you use to find out which user made the table change?
A. SELECT username,operation,sql_redo from V$logmnr_contents where
operation='DDL';
B. SELECT username,operation,sql_redo from V$logmnr_logs where operation='DDL';
C. You must wait until after hours, shut the database down, and issue the command
EXECUTE DBMS_LOGMNR_D.BUILD to extract the information from the
database.
D. The task cannot be done. LogMiner does not track DDL commands in Oracle9i.
Answer: A
Explanation:
Prior to Oracle9i, DDL statements were recorded as a set of DML statements on internal
tables.Oracle 9i records the original DDL statement in the redo logs, and LogMiner lists this DDL statement followed by the set of generated DML statements. When you query V$LOGMNR_CONTENTS, you can see DDL under the OPERATION column, and the DDL statement itself under the SQL_REDO column.

QUESTION 42:
Automatic Consumer Group Switching is an important new feature of the Database
Resource Manager. Which three plan directive parameters are used to control this
feature? (Choose three)
A. SWITCH_TIME
B. SWITCH_GROUP
C. MAX_SESS_POOL
D. SWITCH_ESTIMATE
Actualtests.com - The Power of Knowing

1Z0-032
Answer: A, B, D
Explanation:
You can specify the maximum estimated time to complete (in seconds) for an operation by
assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this
parameter is UNLIMITED. Oracle will estimate the time the operation with table will take. It
the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle's estimate is greater than
the value specified by MAX_EST_EXEC_TIME, Oracle will return an error and the operation
will not be started. If the SWITCH_ESTIMATE parameter is FALSE, Oracle will start the
operation even if Oracle's estimate is greater than the value specified by
MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met.
The SWITCH_GROUP parameter specifies the group to which the session will be switched.
The SWITCH_TIME parameter specifies the amount of time a session can execute before it
must be switched to another group. The default for the SWITCH_GROUP parameter is
NULL; the default for the SWITCH_TIME parameter is UNLIMITED.

QUESTION 43:
How can you make a shared server-side initialization parameter file available to all
instances of a Real Application Clusters database?
A. Include an SPFILE parameter in each instance-specified initialization file.
B. Create an SPFILE copy on each client from which the instance will be started.
C. Store the SPFILE in a raw partition with a vendor-specifies location and name.
D. Use a single client to start the instances and create the SPFILE on this client.
Answer: A
Explanation:
You can make a shared server-side initialization parameter file available to all instances of a
Real Application Clusters database by including an SPFILE parameter in each instancespecific
initialization file. You still have to store a copy of the initialization parameter file on
each node to facilitate startup of the instances. You can avoid distributing copies by
converting this initialization parameter file into a Server Parameter File (SPFILE). Then you
put the one parameter, as shown here, in the initialization parameter file for each instance:
spfile = oracle/home:\config\spfile

QUESTION 44:
Examine the command:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY)
COLUMNS;
What does the command accomplish?
A. Creates an additional copy of the database online redo log files.
B. Stores the primary key column values of each row involved in a DML operation in the
online redo log files.
C. Stores the primary key column values of each row involved in a DML operation in the
supplemental log files.
D. Stores the old and new primary key column values of each row involved in a DML
operation only when the primary key is modified in the online redo log files.
Answer: B
Explanation:
Database supplemental logging allows you to specify logging of primary keys, unique indexes
or both. With this enabled, whenever a DML is performed, the columns involved in the
primary key or unique index are always logged even if they were not involved in the DML.
This only takes effect for statements which have not yet been parsed. It also invalidates all
DML cursors in the cursor cache and therefore has an effect on performance until the cache is
repopulated.

QUESTION 45:
Consider this RMAN command:

RMAN> CONFIGURE RETENTION POLICY CLEAR;
What is the effect of this command?
A. Backups will never expire.
B. It removes any retention policy.
C. The DELETE OBSOLETE command will fail with an error.
D. It sets the retention policy to the default of REDUNDANCY 1.
Answer: D
Explanation:
This command sets retention policy to the default of REDUNDANCY 1.

QUESTION 46:
Examine the code:
CREATE ROLE readonly IDENTIFIES USING app.chk_readwrite ;
CREATE ROLE readwrite IDENTIFIED USING app.chk_readwrite ;
CREATE OR REPLACE PROCEDURE app.chk_readwrite
AUTHID CURRENT_USER IS
ipchk STRING(30);
BEGIN
IF sys_context('USERENV','ISDBA')='TRUE'
THEN DBMS_SESSION.SET_ROLE'READWRITE') ;
ELSE DBMS_SESSION.SET_ROLE('READONLY') ;
END;
/
Which three statements correctly describe the Secure Application role definition?
(Choose three) (The SYS_CONTEXT calls returns whether or not the session is a true
DBA session.)
A. No user or application has to remember or hide a password.
B. It prevents everyone except a true DBA session from acquiring the READWRITE
role.
C. app.chk_readwrite is called whenever a user tries to access rows protected by the
READONLY or READWRITE label.
D. app.chk_readwrite is called by users or applications when they want to enable the
READONLY or READWRITE role.
Answer: A, B, D
Explanation:
Oracle8i introduced the Secure Application Context to enable an application to tailor access
control based on using the attributes of the user's session. Oracle prevents users from
bypassing privileges validation procedure by restricting application attribute changes to the
procedure that implements the context. Oracle9i takes the concept of the application context
one step further; it provides a means of associating the application context with the security
role.

QUESTION 47:
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: C, D, E
Explanation:
Trial Recovery allows the Administrator to determine how many blocks are affected by
corruption, mark them as corrupt in memory to allow the test recovery proceed to completion.
By default, trial recovery always attempts to corrupt blocks in memory if this action allows
trial recovery to proceed. In other words, trial recovery by default can corrupt an unlimited
number of data blocks. You can specify the ALLOW n CORRUPTION clause on the RECOVER
TEST statement to limit the number of data blocks trial recovery can corrupt in memory. It can
be invoked by adding the TEST option to any RECOVER command. For example, you can
start SQL*Plus and then issue any of the following commands:
RECOVER DATABASE TEST
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL TEST
RECOVER TABLESPACE users TEST
RECOVER DATABASE UNTIL CANCEL TEST



QUESTION 48:
Which two are regarding automatic space management segments? (Choose two)
A. You can create an automatic space management segment in a dictionary-managed
tablespace.
B. You can create an automatic space management segment only in a locally managed
tablespace.
C. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an
automatic space management segment.
D. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure
on an automatic space management segment.
Answer: B, D
Explanation:
You can create an automatic space management segment only in a locally managed
tablespace. The FREE_BLOCKS procedure refers to the blocks in a segment below the high
water mark whose number of rows falls below the PCTUSED attribute, and therefore are
candidate for new inserted rows. An automatic space management segment usage eliminates
the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters. So
you CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an
automatic space management segment.

QUESTION 49:
The database was started up using a text parameter file. What will be the default scope
of changes made by using the SET clause of the ALTER SYSTEM statement?
A. Only MEMORY is updated.
B. Only SPFILE values are updated.
C. Only init.ora parameters are updated.
D. Both init.ora parameters and SPFILE values are updated.
Answer: A
Explanation:
The default scope of changes made by using the SET clause of the ALTER SYSTEM
statement is only MEMORY scope. The MEMORY scope only makes changes in memory for
the current instance and not the SPFILE; it does not persist.

QUESTION 50:
Which three resource plan parameters are used to enable Automatic Consumer Group
Switching to estimate job execution times automatically, and to perform a switch to a
low priority consumer group before they are initiated? (Choose three)
A. SWITCH_TIME
B. SWITCH_GROUP
C. MAX_SESS_POOL
D. SWITCH_ESTIMATE
Answer: A, B, D
Explanation:
You can specify the maximum estimated time to complete (in seconds) for an operation by
assigning a value the MAX_EST_EXEC_TIME parameter; the default value for this
parameter is UNLIMITED. Oracle will estimate the time the operation with table will take. It
the SWITH_ESTIMATE parameter is set to TRUE, and if Oracle's estimate is greater than
the value specified by MAX_EST_EXEC_TIME, Oracle will return an error and the operation
will not be started. If the SWITCH_ESTIMATE parameter is FALSE, Oracle will start the
operation even if Oracle's estimate is greater than the value specified by
MAX_EST_EXEC_TIME; Oracle will only switch groups based on other criteria being met.
The SWITCH_GROUP parameter specifies the group to which the session will be switched.
The SWITCH_TIME parameter specifies the amount of time a session can execute before it
must be switched to another group. The default for the SWITCH_GROUP parameter is
NULL; the default for the SWITCH_TIME parameter is UNLIMITED.

Questions(31-40)

QUESTION 31:

Which phrase best describes RMAN multiplexed backup sets?
A. Stripes a single backup set across multiple channels.
B. Identical copies of backup pieces within a backup set.
C. Multiple backup sets with multiple channels configured.
D. Simultaneous reads from multiple files and writes into the same backup piece.
Answer: C
Explanation:RMAN multiplexes multiple backup sets with multiple channels configured.

QUESTION 32:
Which modifier is used to change listener parameters in the Listener Control utility
environment?
A. SET
B. ALTER
C. CHANGE
D. UPDATE
Answer: A
Explanation:
The SET command enables you to dynamically set the values for the listener parameters. The
values persist till the listener is stopped.
 Some examples as

• SET
  
• SET CURRENT_LISTENER
  
• SET DISPLAYMODE
  
• SET INBOUND_CONNECT_TIMEOUT
  
• SET LOG_DIRECTORY
  
• SET LOG_FILE
  
• SET LOG_STATUS
  
• SET SAVE_CONFIG_ON_STOP
  
• SET TRC_DIRECTORY
  
• SET TRC_FILE
  
• SET TRC_LEVEL
  

QUESTION 33:
You plan to take a closed database backup using operating system commands. Which
three SHUTDOWN options are appropriate for this type of backup? (Choose three)
A. ABORT
B. NORMAL
C. IMMEDIATE
D. TRANSACTIONAL
Answer: B, C, D
Abort will shutdown database in inconsistent mode and backup at this point in time will be fruitless.

To perform an offline whole database backup the database needs to be shut down normally
using one of the following options: IMMEDIATE, TRANSACTIONAL, or NORMAL.

QUESTION 34:
Which three initialization parameters are no longer needed when
FAST_START_MTTR_TARGET is defined? (Choose three)
A. TARGET_REDO_BLKS
B. FAST_START_IO_TARGET
C. LOG_CHECKPOINT_TIMEOUT
D. RECOVERY_ESTIMATED_IOS
E. LOG_FILE_SIZE_REDO_BLKS
F. LOG_CHECKPOINT_INTERVAL
Answer: B, C, F
Explanation:
The initialization parameter FAST_START_MTTR_TARGET enables you to specify the
amount of time (in seconds) the database should take to perform crash recovery of a single
instance. This value is internally converted to a set of parameters that are as follows
1>FAST_START_IO_TARGET :- It indicated number of block transfer required during crash recovery.

2>LOG_CHECKPOINT_INTERVAL:- It indicated max time gap between 2 consecutive checkpoint operation and

3>LOG_CHECKPOINT_TIMEOUT :- It indicated max time from last checkpoint.
Setting these parameters to active values obstructs the normal functioning of
FAST_START_MTTR_TARGET, thereby resulting in unpredictable results.


QUESTION 35:
In a dedicated sever configuration, which two statements describe the actions that can be
taken to complete a client/server connection when the client and server are NOT on the
same computer? (Choose two)
A. The listener hands the connection request directly to a dispatcher.
B. The dedicated sever inherits the connection request from the listener.
C. The listener issues a redirect message to the client, containing the protocol address of a
dispatcher.
D. The application initiating the session spawns a dedicated server process for the
connection request.
E. The dedicated sever informs the listener of its listening protocol address.
The listener passes the protocol address to the client in a redirect message and
terminates the connection.
The client connects to the dedicated server directly using the protocol address.
Answer: B, E
Explanation:
The dedicated sever inherits the connection request from the listener. The PMON process is
responsible for registering information about the dedicated server processes with the listener.
Whenever a client request arrives for a connection, the listener starts a dedicated server
process and passes the connection to the dedicated server process. This is known as a
bequeathed session. In order for this method to be used, the listener must be running on the
same server as the node; that is, the listener cannot bequeath a connection to another node.
Once the client connection is established with the server process with the help of the listener,
the client will now directly communicate with the server process. Since the client's
connection with the listener is transient and its connection with the server is permanent, you
can shut down the listener without affecting the existing connections.

QUESTION 36:
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
Explanation:
Power Failure has occurred client side and hence only connection between that particular client and server in disconnected.PMON is a process that continuously monitors connection between users and server processes,and when it gets disconnected,PMON frees dead dispatchers,resources and rollbacks uncommitted transactions.

A process failure is due to the abnormal termination of a process. Oracle handles these types
of failures by using a background process called PMON. PMON identifies the terminated
session and resets the status of the active transaction table, releases locks, and removes the
process ID from the list of active processes.

QUESTION 37:
For which two tasks would it be best NOT to use the utility SQL*Loader? (Choose two)
A. When loading selected rows into each table.
B. When loading data from an export dump file.
C. When loading data from disk, tape, or named pipes.
D. When your data is NOT being inserted from a flat file.
E. When using a record management system to access data files.
Answer: B, D
Explanation:
SQL* LOADER utility is used to load data from other data source into Oracle. For example, if you have a table in FOXPRO, ACCESS or SYBASE or any other third party database, you can use SQL Loader to load the data into Oracle Tables. SQL Loader will only read the data from Flat files. So If you want to load the data from Foxpro or any other database, you have to first convert that data into Delimited Format flat file or Fixed length format flat file, and then use SQL loader to load the data into Oracle. 

Question is when should we not use it.
1>To get data from dump file we use export utility.hence B

2>We use SQL*LOADER for Flat file data transfer.hence D

QUESTION 38:
Your database is running in NOARCHIVELOG mode. Every night there is a backup
taken using RMAN. During your startup this morning you received en error regarding
DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace.
Which option is open to you?
A. The data file needs to be restored by using operating system commands, because a data
file movement must take place, and then the database can be recovered from RMAN.
B. The data file needs to be restored by using operating system commands, since a data
file movement must take place, and then the database must be recovered manually.
C. From RMAN you can issue the commands RESTORE and RECOVER.
RMAN automatically restores the data file on DISK 3 to another disk, based upon
utilization statistics.
D. From RMAN you can issue a SET NEWNAME command to update the data file
location information in the control file, and then issue the RESTORE and RECOVER
commands to recover the database.
Answer: D
Explanation:
Question says that there is some problem with DISK 3 and hence we cant restore datafile to disk 3.and in order to restore the datafile to new location we need to first specify new location using SET NEWNAME
command.Manually its not possible to set new location in controlfile hence we need to use rman.
RMAN enables you to restore the data files to a non-default location. Relocating the data files
to an alternative location is useful when storage is limited or when you need to reorganize the
database to improve performance. You need to create a RMAN script that will perform the
following actions: setting a new location for the data file, restoring the data file, recovering
the data file.

QUESTION 39:
The multithreaded agent architecture for heterogeneous services is similar to the Oracle
multithreaded server architecture. The principal difference is that it used threads
instead of processes.
What are thee kinds of threads that it uses? (Choose three)
A. TCP
B. Task
C. Monitor
D. Dispatcher
E. Shared Server
F. Shutdown address
Answer: B, C, D
Explanation:
Multithreaded agent architecture for heterogeneous services.
Its an method of providing Oracle like architecture to Non-oracle systems.

• A single monitor thread. The monitor thread is responsible for the following:
  
  
  • Maintaining communication with the listener
    
  • Monitoring the load on the process
    
  • Starting and stopping threads when required
    
  
  
• Several dispatcher threads. The dispatcher threads are responsible for the following:
  
  
  • Handling communication with the Oracle server
    
  • Passing task requests to the task threads
    
  
  
• Several task threads. The task threads handle requests from the Oracle processes.
  
  These three thread types roughly correspond to the Oracle multithreaded server PMON, dispatcher, and shared server processes, respectively.

QUESTION 40:
You created a database by using the Database Configuration Assistant. What must you
do to access a user account in the sample schemas?
A. Create the user account and unlock the account.
B. Create the user account and define a password.
C. Unlock the user account and define a password.
D. Set the 07_DICTIONARY_ACCESSIBILITY parameter to TRUE.
Answer: C
Explanation:
To access a user account in the sample schemas you need to unlock the user account and
define a password.

Questions21-30

QUESTION 21:


Which two statements are true regarding the use of UTF-16 encoding? (Choose two)
A. Enables easier loading of multinational data.
B. Uses a fixed-width Multibyte encoding sequence.
C. Asian characters are represented in three characters.
D. Used a variable-width Multibyte encoding sequence.
E. European characters are represented on one or two bytes.
Answer: A, B
Explanation:
AL16UTF16 is a 2-byte, fixed-width Unicode character set, which is also referred to as
UTF16 or UCS2. The ASCII English character set is assigned the first 128 values from 0
(0X00) through 127 (oX7F) in Unicode, which translates to 1 byte. Even though AL16UTF16
uses one more byte than UTF8 for ASCII character representation, it is still faster because it
uses fixed-width encoding as opposed to UTF8, which uses variable-width encoding. UTF-16
encoding enables easier loading of multinational data. It uses a fixed-width multibyte
encoding sequence.

QUESTION 22:
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.
Actualtests.com - The Power of Knowing

1Z0-032
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
Explanation:
When the user process arrives, the listener examines the request and determines whether the
user process can use a shared server process. If so, the listener returns the address of the
dispatcher process that is currently handling the least number of requests. Then the user
process connects to the dispatcher directly. The dispatcher process then directs multiple client
requests to a common queue. The idle shared server processes pick up the virtual circuit from
the common request queue on a first-in-first-out (FIFO) basis and make all necessary calls to
the database to complete that request. When the server process completes the request, it places
the response on the calling dispatcher response queue. The dispatcher then returns the
completed request to the appropriate user process.

QUESTION 23:
You issue this RMAN command:
RMAN> create script Level0Backup {
backup
incremental level 0
format '/u01/db01/backup/%d_%_Sp'
fileperset 5
(database include current controlfile);
sql 'alter database archive log current';
}
Which three statements are true about the Level0Backup script you just created?
(Choose three)A. The script is stored only in the control file.
B. The script is stored only in the recover catalog.
C. The script can be executed only by using the RMAN RUN command.
D. The commands of the script can be displayed with the LIST command.
E. The commands of the script can be displayed with the PRINT command.
F. The commands of the script can be displayed with the REPORT command.
Answer: B, C, E
Explanation:
A stored script is a sequence of RMAN commands stored within the recovery catalog
repository. To execute a stored script, you must use the EXECUTE SCRIPT command in a
RUN block, as shown in the following code. The commands of the script can be displayed
with the PRINT command.

Printing a Script to a File: Example

The following example prints a script to the file '/tmp/backup_db.rman':

PRINT SCRIPT backup_db TO FILE '/tmp/backup_db.rman';

Printing a Script to the Screen: Example

This example prints a stored script to standard output (includes sample output):

RMAN> PRINT SCRIPT 'backup_db';

printing stored script: backup_db
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt
BACKUP DATABASE;

}

QUESTION 24:
Which RMAN command do you use to verify that the RMAN repository information is
synchronized with the actual files that exist on disk?
A. LIST
B. CHANGE
C. CATALOG
D. CROSSCHECK
Answer: D
Explanation:
RMAN command CROSSCHECK enables you to crosscheck the availability of the backup
sets by verifying the information stored in its repository with the backup sets that are
physically available in the designated storage medium.

QUESTION 25:
A web browser can connect directly to an Oracle server using which two? (Choose two)
A. HTTP
B. IIOP
C. TCP/IP
D. Named Pipes
E. TCP/IP with SSL
Answer: A, B
Explanation:
The clients forward the requests using HTTP, which provides the language that enables Web
browsers and application Web servers to communicate. Also web clients can access the
Oracle database directly - for example, by using a Java applet. In addition to regular
connections, the database can be configured to accept HTTP and Internet Inter-ORB Protocol
(IIOP) connections.


QUESTION 26:
What is true regarding direct-load insert?
A. A direct-load insert can be invoked by suing the APPEND hint.
B. Inserting using the NOLOGGING option is the default for direct-load inserts.
C. All data loaded using direct-load insert is loaded below the high-water mark.
D. An object that is modifies using parallel direct-load can be queried within the same
transaction.

Answer: A
Explanation:
Conventionally when we insert data is first loaded in Instance and then in to database via DBWR.but in direct-load insert data is directly loaded into data files of database.Its fast but uses more memory.
It inserts data in only those segments which are above the high-water mark.Data is appended to the table. Existing free space is not re-used. So, if you direct load insert a bunch of rows, then delete them, and insert them again, the space made by the delete will not be re-used.

QUESTION 27:
In which three cases does a checkpoint occur? (Choose three)
A. Every three minutes.
B. When a log switch occurs.
C. When forces by an administrator.
D. When a tablespace is taken offline normal.
E. When the redo buffer is one-third full.
Answer: B, C, D
Explanation:
Checkpoints, at the database or data file level, occur automatically when the database
encounters the following conditions: 
1>when a log switch occurs, when configured through the
database initialization parameters LOG_CHECKPOINT_INTERVAL and
LOG_CHECKPOINT_TIMEOUT,
2>when an online database backup begins, when a
tablespace is taken offline NORMAL,
3>when the ALTER SYSTEM CHECKPOINT command
is issued, when the database is closed gracefully or when the redo buffer is one-third full.

QUESTION 28:
Which two roles or privileges must you have to export tables owned by another user?
(Choose two)
A. CREATE USER
B. CREATE SESSION
C. CREATE ANY TABLE
D. IMP_FULL_DATABASE
E. EXP_FULL_DATABASE
Answer: B, E
Explanation:
1>To connect to the database you need the CREATE SESSION privilege.
2>To do a full export or an export tables owned by another user you need the EXP_FULL_DATABASE privilege.

QUESTION 29:
When you are performing media recover, and an archived log is lost or corrupt, which
type of recover must you perform?
A. Until SCN
B. Until time
C. Until cancel
D. Recover using backup control file.
Answer: C
Explanation:
You must use the cancel-based recovery to perform an incomplete media recovery if a current
redo log is damaged and is not available to perform recovery. Another reason for using
cancel-based recovery is when an archived redo log file needed for recovery is unavailable
either due to the loss of the file or corruption. Archiving to multiple destinations or backing
up the files more frequently can avoid such errors.

QUESTION 30:
Which three features are provided by Oracle Net Services? (Choose three)
A. Data encryption.
B. User authentication.
C. Transparent data conversion
D. Configuration and administration mechanisms.
E. Support for multiple network transport protocols.
Answer: C, D, E
Explanation:
Two Task Common layer of Oracle Net Services provide transparent data conversion,
configuration and administration
mechanisms, support for multiple network transport protocols(if client is using http and server is using Tcp/Ip).