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

문제1

Which three statements are true about the database instance startup after an instance failure?

A. Changes committed before the failure, which were not written to the data files, are re-applied.

B. Uncommitted changes are rolled back to ensure transactional consistency.

C. The RECO process recovers the uncommitted transactions at the next instance startup.

D. Media recovery is required to complete the database recovery.

E. The SMON process automatically performs the database recovery.

F. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

정답: A,B,E

문제2

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

A. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

B. Database files stored in any file system and accessed using the Oracle Direct NFS feature

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

E. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

F. Database files stored in ZFS and accessed using conventional NFS mounts.

G. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

정답: A,D,E

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

문제3

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

A. A program and schedule can be specified as part of a job definition.

B. A job is specified as part of a program definition.

C. A program and window can be specified as part of a job definition.

D. A program and job can be specified as part of a schedule definition.

E. A program can be used in the definition of multiple jobs.

정답: A,C,E

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

문제4

You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.
Examine the following steps:
1. Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS('SH', 'CUSTOMERS')from dual statement.
2.Execute the dbms_stats.seed_col_usage (null,'SH',500) procedure.
3.Execute the required queries on the customers table.
4.Issue the select dbms_stats.reportwcol_usage('SH', 'customers') from dual statement.
Identify the correct sequence of steps.

A. 3, 2, 1, 4

B. 4, 1, 3, 2

C. 2, 3, 4, 1

D. 3, 2, 4, 1

정답: C

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

문제5

Examine these Data Pump commands to export and import objects from and to the same database.
The dba has not yet created users hr1 and oe1.
$expdp system/manager
schemas = hr.oe
directory = EXP_DIR
dumpfile = export.dat
include = table
$ impdpsysten/manager
schemas = hr1,oe1
directory = EXP_DIR
dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

A. expdp will fail because no path has been defined for the dumpfile.

B. expdp will succeed but impdp will fail because the users do not exist.

C. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

D. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

정답: B

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

문제6

Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?

A. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

B. The database must be running in archivelog mode for the successful execution of this command.

C. A complete database backup must exist before executing this command.

D. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

E. Block change tracking must be enabled before executing this command.

정답: A

문제7

RMAN is connected to a target database instance and an auxiliary instance. You execute the command:
RMAN> DUPLICATE TARGET DATABASE
TO dupdb
FROM ACTIVE DATABASE
SECTION SIZE 1G;
What is the outcome?

A. RMAN uses the pull method to restore files using backup sets.

B. RMAN uses the push method to transfer backup sets.

C. RMAN uses the push method to transfer image copies.

D. RMAN uses the pull method to restore files using image copies.

정답: A

문제8

In which three scenarios is media recovery required?

A. when archived redo log files are lost

B. when data files are lost

C. when a tablespace is accidentally dropped from a database

D. when all control files are lost

E. when one of the online redo log members is corrupted

정답: A,C,D

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

문제9

Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

A. Automatic checkpoint tuning is enabled.

B. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.

C. The MTTR advisor is enabled only if the value is greater than the default value.

D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

정답: B,C

문제10

Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?

A. The database backup is older than the control file backup.

B. All the data files are missing.

C. A data file belonging to a noncritical tablespace is missing.

D. The current online redo log file is missing.

E. All the control files are missing.

정답: D,E

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

문제11

Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RMAN> RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN RUN block execution?

A. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

B. The script is executed and both DC1 and CH1 channels are used for script execution.

C. The new channel, CH1, is ignored because a channel has been configured already.

D. The execution of the script fails because multiple channels cannot exist simultaneously.

정답: A

문제12

Which two statements are true when row-archival management is enabled?

A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

B. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

C. The row archival visibility session parameter defaults to all rows.

D. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

E. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

정답: B,E

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

우리와 연락하기

유용한 링크

최신 업데이트