Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP
Question No: 91
In your database, the flash recovery area (FRA) is configured as the default for RMAN backups. You executed the following commands to configure the settings in RMAN:
Which statement is true about the outcome?
Only one channel is allocated and the backup is created in the flash recovery area
Only one channel is allocated and the backup is created in the destination specified for channel
Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2
Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA
Question No: 92
You want to track and store all transactional changes to a table over its lifetime.
To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.
After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.
To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?
The command produces an error because the retention time cannot be reduced.
All historical data is retained but the subsequent flashback data archives are maintained for only three years.
All historical data is purged and the new flashback data archives are maintained for three years.
All historical data older than three years is purged from the flashback archive FLA1.
Question No: 93
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively.
From the tablespace space usage metrics, you find that the actual space usage has reached the specified warning threshold value, but no alerts have been generated. What could be the reason for this?
The EVEN parameter was not set.
The SQL_TRACE parameter is set to FALSE.
Enterprise Manager is not used.
The STATISTICS_LEVEL parameter is set to BASIC.
The TIMED_STATISTICS parameter is set to FALSE.
Question No: 94
Which two statements are true regarding hot patching? (Choose two.)
It requires relinking of the Oracle binary.
It does not require database instance shutdown.
It can detect conflicts between two online patches.
It is available for installing all patches on all platforms.
It works only in a single database instance environment.
Answer: B,C Explanation:
Regular patches typically contain .o (object) files and/or .a (archive) libraries, and therefore require a relink of the RDBMS binary. Online patches, however, contain .so files, which are dynamic/shared libraries, and do not require a relink of the RDBMS binary. Consequently, since a relink is not needed, you can apply or roll back online patches while the RDBMS instance is running. This simplifies administration, because no downtime is needed, and also results in a much quicker turnaround time for installing or de-installing Online Patches.
A regular RDBMS patch can require many minutes to install, since it requires instance shutdown, a relink, and instance startup. On the other hand, you can install an online patch in just a few seconds.
Online patches are only applicable for Oracle RDBMS and not any other products. Online patches are currently supported on the following Windows and UNIX platforms for version
220.127.116.11.0 and later:
->Solaris SPARC 64-bit
->Solaris AMD 64-bit
->AIX (AIX 6.1 and later)
About Patch Conflicts:
All patches may not be compatible with one another. For example, if you apply a patch, all the bugs the patch fixes could reappear after you apply another patch. This is called a conflict situation. OPatch detects such situations and raises an error when it detects a conflict.
Question No: 95
In Recovery Manager (RMAN), you are taking Image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy.
Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?
using only the RMAN SWITCH command to set the new location for the data file
placing the database in the MOUNT state for the restore and recovery operations.
using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
configuring two channels: one for the restore operation and the other for the recovery operation
Question No: 96
Consider the following scenario for your database:
->Backup optimization is enabled in RMAN.
->The recovery window is set to 7 days in RMAN.
->The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
->The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?
The RMAN backup fails because the TOOLS tablespace is read-only
The RMAN skips the backup of the tablespace because backup optimization is enabled
The RMAN makes backup because optimization can be enabled only for backups to disk
The RMAN makes the backup because no backup of the tablespace exists within the seven day window
Question No: 97
Multiple RMAN sessions are connected to the database instance. Examine the following output when backup commands are running in server sessions: What could have helped you to correlate server sessions with channels?
Implement RMAN multiplexing
Set the DEBUG ON in the RMAN script
Specify the command ID in the RMAN script
Use a tag with the RMAN BACKUP command
Question No: 98
Note the following parameter settings: Which setting is NOT allowed?
ALTER SYSTEM SET DB_CACHE_SIZE=50M;
ALTER SYSTEM SET DB_8K_CACHE_SIZE=10M;
ALTER SYSTEM SET DB_4K_CACHE_SIZE=10M;
ALTER SYSTEM SET DB_16K_CACHE_SIZE=10M;
Question No: 99
You created a tablespace with the following statement: CREATE BIGFILE TABLESPACE adtbs
DATAFILE #39;/probdb/data/adtbs.dbf#39; SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
ALTER TABLESPACE adtbs RESIZE 20G;
ALTER TABLESPACE adtbs ADD DATAFILE;
ALTER TABLESPACE adtbs AUTOEXTEND ON;
ALTER TABLESPACE adtbs ADD DATAFILE#39;/proddb/data/adtbs1.dbf#39; SIZE 10G;
ALTER TABLESPACE adtbs MODIFY DATAFILE #39;/proddb/data/adtbs.dbf#39; AUTOEXTEND ON;
Answer: A,C Explanation: C:\sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 – Production on Sat Jan 28 20:34:23 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQLgt; conn / as sysdba Connected.
SQLgt; CREATE BIGFILE TABLESPACE adtbs
DATAFILE#39;C:\adtbs.dbf#39; SIZE 1G; Tablespace created.
SQLgt; ALTER TABLESPACE adtbs RESIZE 2G
(B) and (D)
SQLgt; ALTER TABLESPACE adtbs ADD DATAFILE#39;C:\adtbs.dbf#39; SIZE 1G; ALTER TABLESPACE adtbs ADD DATAFILE #39;C:\adtbs.dbf#39; SIZE 1G
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace (C)
SQLgt; ALTER TABLESPACE adtbs AUTOEXTEND ON;
Tablespace altered. (E)
SQLgt; ALTER TABLESPACE adtbs MODIFY DATAFILE #39;C:\adtbs.dbf#39; AUTOEXTEND ON; ALTER TABLESPACE adtbs MODIFY DATAFILE #39;C:\adtbs.dbf#39; AUTOEXTEND ON
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option
Question No: 100
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)
Alert log file
Archived redo log files
Control file autobackups
Server Parameter file (SPFILE)
Recovery Manager (RMAN) backup piece
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|