1Z0-083試験無料問題集（283題）「Oracle Database Administration II 認定」

出題：1

You want to duplicate one of your databases when connected to the target database and to the recovery catalog.
Which three are true about this type of database duplication?

A. The duplication process can use existing backup sets or image copies.

B. The duplication process can create backup sets or image copies.

C. The target database must be in mount state.

D. The duplication process pushes image copies to the auxiliary instance.

E. The target database must be open.

F. The duplication process pushes backup sets to the auxiliary instance.

正解：C,E,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：2

Which three actions are mandatory post database upgrade?

A. Updating client scripts with the new Oracle home.

B. Run OPatch commands from the new Oracle home.

C. Migration to unified auditing.

D. Upgrading user tables that depend on Oracle-maintained abstract data types.

E. Resetting passwords to enforce case-sensitivity.

F. Setting threshold values for tablespace alerts.

正解：A,B,D 解答を投票する

出題：3

Which three are located by using environment variables? (Choose three.)

A. the location of Oracle Net Services configuration files

B. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

C. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

D. the maximum number of database files that can be opened by a database instance

E. default directories for temporary files used by temporary tablespaces

F. the temporary disk space used by Oracle Installer during installation

正解：A,C,F 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：4

Which two are true about RMAN backups when using a media manager? (Choose two.)

A. By default, a request for a proxy copy may result in a backup set being created.

B. A media manager always writes RMAN requested backups to tape.

C. A media manager is required to create RMAN image copies.

D. A media manager is required to create RMAN proxy copies.

E. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.

正解：A,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：5

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

A. It is integrated with the SQL Access Advisor.

B. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.

C. SQL statements that were originally run concurrently are run concurrently by SPA.

D. It provides before and after execution statistics for each SQL statement in the analysis task

E. It predicts the impact of system changes on SQL workload response time.

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：6

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

A. Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B. Duplication can be done by having the target database instance push copies to the auxiliary database instance.

C. A connection to an auxiliary instance is always required.

D. A backup of the target database is always required.

E. A connection to the recovery catalog instance is always required.

F. A new DBID is always created for the duplicated database.

G. A connection to the target database instance is always required.

H. A subset of the target database can be duplicated.

正解：A,B,C,H 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：7

Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup?

A. Backups can be written only if checksums are stored for each block.

B. Binary compression cannot be applied to the backup.

C. Backups can be written only to disk.

D. Backups can be taken only for data files.

E. Backups can be written only to media.

F. Backups can be taken only if a fast recovery area is configured.

正解：B,C 解答を投票する

出題：8

Which three are true about Automatic Workload Repository (AWR) snapshots? (Choose three.)

A. They can be retained forever.

B. They are always created manually.

C. They are always created automatically.

D. They are generated if STATISTICS_LEVEL is set to ALL.

E. They are generated if STATISTICS_LEVEL is set to TYPICAL.

F. They are generated if STATISTICS_LEVEL is set to BASIC.

正解：A,D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：9

Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)

A. It can only install and configure Oracle Database software. The database has to be created separately.

B. It does not require the setup wizard.

C. It uses a single RPM that automatically extracts and installs the Oracle Database software.

D. It can be used for both Oracle Database and Oracle Grid Infrastructure installation.

E. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.

正解：D,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：10

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

A. RMAN uses the push method to transfer backup sets

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

C. RMAN uses the push method to transfer image copies

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

正解：B 解答を投票する

出題：11

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

A. SPFILE backups can be created while connected to an application root PDB.

B. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.

C. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.

D. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

E. The BACKUP DATABASE PLUS ARCHIVELOG command will back up archive logs when RMAN is connected to a PDB.

正解：C,D 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

出題：12

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
(Choose three.)

A. ADDM can recommend shrinking the buffer cache.

B. AWR snapshots must be deleted when no longer required by ADDM.

C. By default, AWR snapshots are automatically purged after eight days.

D. By default, MMON creates an AWR snapshot every 30 minutes.

E. ADDM can recommend extending the buffer cache.

F. ADDM performs its analysis only when a DBA requests it.

正解：A,C,E 解答を投票する

解説: (GoShiken メンバーにのみ表示されます)

1Z0-083試験無料問題集「Oracle Database Administration II 認定」