최신 1Z1-083 무료덤프 - Oracle Database Administration II

문제1

Which three are true about using Database Resource Manager in an Oracle multitenant environment? (Choose three.)

A. PDB-level resource plans can limit uncommitted UNDO per consumer group.

B. A CDB-level resource plan can limit session CPU utilization.

C. A PDB-level resource plan can limit session PGA memory.

D. A CDB-level resource plan is mandatory when using PDB-level resource plans.

E. A CDB-level resource plan can limit PDB UNDO use.

F. A CDB-level resource plan can limit PDB CPU utilization.

정답: A,C,F

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

문제2

Which three are true about Rapid Home Provisioning (RHP), which has been available since Oracle 18c?

A. It can be used to deploy Oracle Database homes.

B. It cannot be used to provision applications.

C. It is an Oracle Database service.

D. It can be used to deploy Grid Infrastructure homes, including Oracle Restart.

E. It is an Oracle Grid Infrastructure service.

F. It cannot be used to provision middleware.

정답: A,D,E

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

문제3

Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A. The Oracle Application Express configuration should be updated after upgrading Oracle Database.

B. The new extended data type capability must be enabled by running the utlrp.sql script

C. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

E. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

정답: A,B,E

문제4

Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)

A. The base catalog must be enabled for Virtual Private Catalog use.

B. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C. The target PDB must be registered in a base catalog.

D. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

E. The target PDB must be registered in a Virtual Private Catalog.

F. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

정답: D,E,F

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

문제5

Which two statements are true about the Database Configuration Assistant (DBCA)?

A. It can be used to create a database template from an existing database.

B. It can be used to add a new tablespace.

C. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

D. It can generate SQL database creation scripts.

E. It can configure Automatic Storage Management (ASM) diskgroups.

정답: A,D

문제6

Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

A. The CSS daemon runs from the Grid Infrastructure home.

B. It supports volume management, file system, and automatic restart capabilities.

C. It can manage database resources on the server where it is installed or on a different server.

D. It must be installed before the Oracle database software is installed.

E. It requires Oracle Automatic Storage Management (ASM) components to be installed separately.

정답: A,B

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

문제7

You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB.
Which three methods can you use?

A. Data Pump full transportable database

B. Data Pump full database export and import

C. the DBMS_PDB package

D. Data Pump transportable tablespaces

E. cloning the non-CDB as a PDB

F. replication using GoldenGate

정답: B,D,F

문제8

Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?

A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.

B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.

C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.

D. This cannot be done due to the lack of a clean restore point.

E. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.

정답: B

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

문제9

Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

A. creating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant (ASMCA)

B. creating a database service using DBMS_SERVICE.CREATE_SERVICE

C. creating a database using the CREATE DATABASE SQL statement

D. creating an Oracle Database service by modifying the SERVICE_NAMES parameter

E. creating a database service using Oracle Database Configuration Assistant (DBCA)

F. creating a disk group using the CREATE DISKGROUP SQL statement

정답: A,E,F

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

문제10

A database is configured in ARCHIVELOGmode.
Full RMAN backups are taken and no backup to trace has been taken of the control file.
A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

A. after losing all copies of the control file

B. when any archived log from, before, or after the most recent backup is corrupt.

C. after losing an archived log from before the most recent backup

D. after losing an archived log from after the most recent backup

E. after losing the SYSTEM tablespace

정답: C,E

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

문제11

Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group
+DATA.
2. ORCLuses disk group +FRAfor the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:

What is the outcome?

A. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.

B. Only the ORCL database instance is started.

C. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.

D. Only the ORCL database instance and the +DATA and +FRA disk groups are started.

E. Only the ORCL database and the ASM instances are started.

정답: C

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

문제12

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

C. by running ADDM in diagnostic mode

D. by using Active Session History (ASH) data and performing hang analysis

정답: A

문제13

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

A. Flashback logs are maintained in the Flash Recovery Area.

B. Flashback logs need to be cleared manually after you disable Flashback Database.

C. Flashback logs are used to maintain Flashback Database related errors.

D. Flashback logs are maintained in redo log files.

E. Flashback logs are not archived.

정답: A,E

문제14

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
(Choose three.)

A. the Process Monitor Process (PMON)

B. the log writer process (LGWR)

C. SYSAUX tablespaces

D. the data dictionary in CDB$ROOT

E. undo tablespaces

F. temporary tablespaces

정답: A,B,D

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

최신 1Z1-083 무료덤프 - Oracle Database Administration II

우리와 연락하기

유용한 링크

최신 업데이트