[2026] Oracle Upgrade to Oracle Database 12c - 1Z0-060 무료 시험 문제

문제1

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. Transportable database

B. Transportable tablespace

C. The DBMS_PDB package

D. RMAN

E. Data Pump full export / import

정답: B

문제2

An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

You want to balance the memory between the System Global Area (SGA) components depending on the workload.
Which option would solve this problem?

A. setting the SGA_TARGET parameter to 300M

B. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M

C. setting the SGA_MAX_SIZE parameter to 400M

D. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M

정답: A

문제3

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINERstatement and why is it so?

A. It fails because local users are unable to use the SET CONTAINER statement.

B. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

C. It fails because common users are unable to use the SET CONTAINER statement.

D. It succeeds because the PDB_ADMIN user has the required privileges.

정답: A

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

문제4

You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the command to back up the ASM metadata regularly.
MD_BACKUP
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)

A. Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.

B. Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.

C. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

D. Use RMAN to restore both the metadata and the data.

정답: A,B

문제5

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

A. Parallel compilation of only the stored PL/SQL code

B. Parallel recompilation of any stored PL/SQL code

C. Sequential recompilation of only the stored PL/SQL code

D. Sequential recompilation of any stored PL/SQL code

E. Sequential recompilation of Java code

F. Parallel recompilation of Java code

정답: B,F

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

문제6

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

A. Setting the target tablespace to read-only after the segments are moved

B. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D. Taking the target tablespace offline after the segments are moved

E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

정답: A,C

문제7

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 회원만 볼 수 있음)

문제8

You connect to the root container of a multitenant container database (CDB) with SYSDBA privileges by using SQL*Plus.
The CDB has several pluggable databases (PDBs) open in read/write mode.
There are ongoing transactions in both the CDB and the PDBs.
What happens after issuing the SHUTDOWN TRANSACTIONAL statement?

A. the shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.

B. the statement results in an error because there are open PDBs

C. the shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled back.

D. the shutdown proceeds immediately

정답: A

문제9

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.

A. High clustering factor for the indexes

B. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter

C. Undersized shared pool

D. Oversized buffer cache

E. Missing or stale histogram statistics

정답: A,B,E

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

Oracle Upgrade to Oracle Database 12c - 1Z0-060무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트