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

문제1

Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

A. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and then switches to the original group.

B. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer for queries, but not for data manipulation language (DML) operations.

C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB of data transfer and returns to the original group after the operation.

D. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MB of data transfer.

정답: C

문제2

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

A. Automatic checkpoint tuning will be enabled.

B. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter.

C. The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.

D. The MTTR advisor will be disabled.

정답: A,C

문제3

You realize that the control file is damaged in your production database. After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?

A. Mount the database

B. Open the database in NORMAL mode

C. Open the database in RESTRICTED mode

D. Open the database with the RESETLOGS option

정답: A

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

문제4

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks.
One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE *disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

A. all disks that are currently in OFFLINE mode

B. all disks that are not currently in OFFLINE mode

C. all disks in the disk group

D. all disks in the disk group only if all of them are ONLINE

정답: B

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

문제5

Your database initialization parameter file has the following entry:
SEC_MAX_FAILZD_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?

A. It locks the user account after the specified number of attempts.

B. It is enforced only if the password profile is enabled for the user.

C. It drops the connection after the specified number of login attempts fail for any user.

D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBAprivilege.

정답: C

문제6

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?

A. The uncommitted transaction will be committed at the next startup of the database instance

B. The DBA has to perform the recovery on the database to recover the uncommitted transaction

C. The online redo log files and archived redo log files are required to accomplish the recovery

D. The uncommitted transaction is rolled back automatically at the next opening of the database

정답: D

문제7

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

문제8

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?

A. An upper limit on how far you can flash back the database, depending on the information in the redo logs

B. An upper limit on how far you can flash back the database, depending on the information in the undo tablespace

C. The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provide that there is enough space

D. The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space

정답: D

문제9

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?

A. Specify the command ID in the RMAN script

B. Implement RMAN multiplexing

C. Use a tag with the RMAN BACKUP command

D. Set the DEBUG ON in the RMAN script

정답: A

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

우리와 연락하기

유용한 링크

최신 업데이트