[2026] Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP

문제1

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

A. The change tracking file must be created after the first level 0 backup.

B. Multiple change tracking files can be created for a database.

C. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations.

D. RMAN does not support backup and recovery of the change tracking file.

정답: C,D

문제2

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios in which you must have a recovery catalog.

A. To store the backup information of multiple database

B. To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.

C. To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.

D. To restrict the amount of space that is used by the backups

정답: A,B

문제3

You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' 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.)

A. ALTER TABLESPACE adtbs RESIZE 20G;

B. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;

C. ALTER TABLESPACE adtbs ADD DATAFILE;

D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;

E. ALTER TABLESPACE adtbs AUTOEXTEND ON;

정답: A,E

설명: (Fast2test 회원만 볼 수 있음)

문제4

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?

A. Two channels are allocated and backup sets are created in the destinations specified for channels 1 and 2

B. Only one channel is allocated and the backup is created in the destination specified for channel

C. Only one channel is allocated and the backup is created in the flash recovery area

D. Three channels are allocated and backup sets are created in the destinations specified for channels 1, 2, and FRA

정답: C

문제5

Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

A. backing up the recovery catalog to the same disk as that of the target database

B. running the recovery catalog database in NOARCHIVELOG mode.

C. setting the retention policy to a REDUNDANCY value greater than 1

D. backing up data filed only and not the archived redo log files

E. configuring control file autobackup to be ON

정답: C,E

설명: (Fast2test 회원만 볼 수 있음)

문제6

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?

A. using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

B. using only the RMAN SWITCH command to set the new location for the data file

C. placing the database in the MOUNT state for the restore and recovery operations.

D. configuring two channels: one for the restore operation and the other for the recovery operation

정답: A

문제7

Which three tasks can be performed using a duplicate database? (Choose three.)

A. Testing the effect of an application changes on database performance

B. Testing the backup and recovery procedures

C. Continuously updating archive log files from the target database to support failover

D. Testing the upgrade of an Oracle database to a new release

정답: A,B,D

문제8

You perform an RMAN block media recovery on the tools 01.dbf data file in the SALES database.
Which two statements are true?

A. You must take the tools01.dbf data file offline before you start a block media recovery.

B. You can perform only a complete media recovery of individual blocks, point-in-time recovery of individualdata blocks is not supported.

C. You must put the database in NOARCHIVELOG mode to perform a block media recovery.

D. You must restore a backup control file to perform a block media recovery.

E. You must ensure that the SALES database is mounted or open.

정답: B,E

문제9

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?

A. The STATISTICS_LEVEL parameter is set to BASIC.

B. The SQL_TRACE parameter is set to FALSE.

C. The TIMED_STATISTICS parameter is set to FALS

D. The EVEN parameter was not set.

E. Enterprise Manager is not used.

정답: A

문제10

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

A. The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

B. The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.

C. The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.

D. The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.

E. The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.

정답: E

Oracle Upgrade Oracle9i/10g OCA to Oracle Database 11g OCP - 1z1-034무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트