1Z1-083無料問題集「Oracle Database Administration II」

質問 1

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 transportable tablespaces

（B）Data Pump full database export and import

（C）the DBMS_PDB package

（D）replication using GoldenGate

（E）cloning the non-CDB as a PDB

（F）Data Pump full transportable database

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

質問 2

You plan to perform cross-platform PDB transport using XTTS.
Which two are true? (Choose two.)

（A）The source PDB must be in MOUNT state.

（B）The source PDB can be in MOUNT or OPEN state.

（C）The source PDB must not be an application root.

（D）The source and target platforms must have the same endianness.

（E）Automatic conversion of endianness occurs.

（F）A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.

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

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

質問 3

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

（A）BACKUP SPFILE SECTION SIZE 1M;

（B）BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

（C）BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

（D）BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

（E）BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

（F）BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M;

（G）BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

正解：B、C、D、G 解答を投票する

質問 4

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

（A）By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.

（B）The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.

（C）The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.

（D）The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

（E）The Oracle Grid Infrastructure installation must be owned by the grid user.

（F）The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.

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

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

質問 5

Which two are true about server-generated alerts? (Choose two.)

（A）Stateless alerts can be cleared manually.

（B）Stateless alerts are automatically cleared.

（C）Stateless alerts can be purged manually from the alert history.

（D）Stateful alerts are purged automatically from the alert history.

（E）Stateful alerts must be created by a DBA after resolving the problem.

正解：A、C 解答を投票する

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

質問 6

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 need to be cleared manually after you disable Flashback Database.

（B）Flashback logs are maintained in redo log files.

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

（D）Flashback logs are maintained in the Flash Recovery Area.

（E）Flashback logs are not archived.

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

質問 7

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

（A）The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

（B）The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

（C）It can be done before installing Grid Infrastructure for a Standalone Server.

（D）The runfixup.sh script can install missing RPMs.

（E）The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

（F）It allows you to select the languages supported by the Oracle database server.

（G）It can be done after installing Grid Infrastructure for a Standalone Server.

正解：C、E、G 解答を投票する

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

質問 8

Which three are true about Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) in an Oracle multitenant environment? (Choose three.)

（A）AWR reports can be generated while connected to any container.

（B）AWR snapshots can be created in CDB$ROOT.

（C）No AWR data is stored in the CDB$ROOT SYSAUX tablespace.

（D）AWR snapshots can be created in a PDB.

（E）All AWR data is stored in the CDB$ROOT SYSAUX tablespace.

（F）ADDM can run in a nonroot container.

正解：B、D、F 解答を投票する

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

質問 9

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

（A）It is integrated with the SQL Access Advisor.

（B）It provides before and after execution statistics for each SQL statement in the analysis task

（C）It predicts the impact of system changes on SQL workload response time.

（D）SQL statements that were originally run concurrently are run concurrently by SPA.

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

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

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

質問 10

Which three are true about the SQL Tuning Advisor? (Choose three.)

（A）It builds SQL profiles for each poorly performing SQL statement to prevent regressions.

（B）It can recommend semantic changes to SQL statements.

（C）It checks each query being analyzed for stale statistics.

（D）It only recommends syntactic changes to SQL statements.

（E）It checks each query being analyzed for missing statistics.

（F）It considers all SQL statements being analyzed by the advisor task as a group.

正解：B、C、E 解答を投票する

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

質問 11

Which two are true in Oracle 19c and later releases?

（A）Unified Auditing can be configured to audit only events that are issued directly by an audited user.

（B）All the Oracle-supplied accounts are Schema Only accounts.

（C）If the password file location changes, then the instance must be restarted.

（D）Unified Auditing can be configured to audit only events that are issued indirectly by all users

（E）Schema Only accounts can be granted administrator privileges.

正解：A、E 解答を投票する

質問 12

Examine this configuration:
1. CDB1is a container database.
2. COMMON_USER_PREFIXis C##.
3. PDB1is a pluggable database contained in CDB1.
4. APP1_ROOTis an application container contained in CDB1.
5. APP1_PDB1is an application PDB contained in APP1_ROOT.
You execute these commands successfully:

Which two are true? (Choose two.)

（A）APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.

（B）APP1_USER1 can be created in PDB1.

（C）C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.

（D）P1_USER1 can be created in CDB1.

（E）C##_APP_USER1 can be created in CDB1.

（F）APP1_USER1 can be created in CDB1.

正解：B、E 解答を投票する

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

質問 13

Which two are true about various Oracle security and auditing capabilities?

（A）Unified auditing can be automatically synchronized to all application PDBs in an application container.

（B）Application-common TSDP policies are always container specific.

（C）Application-common OLS policies can be created only if all the PDBs in the application container are closed.

（D）Application-common Transparent Security Data Protection (TSDP) policies can be created only if all the PDBs in the application container are closed.

（E）Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container when they are updated.

正解：A、E 解答を投票する

質問 14

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

（A）Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct

（B）Tracking the most recent write time for a table segment in a user tablespace

（C）Tracking the most recent read time for a table segment in a user tablespace

（D）Tracking the most recent read time for a table segment in the SYSTEM tablespace

（E）Tracking insert time by row for table rows

（F）Tracking the most recent write time for a table block

正解：B、C、E 解答を投票する

質問 15

You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

（A）Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

（B）Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

（C）Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

（D）Create the database by using the CREATE DATABASE . . . command and manually import data by using Data Pump.

正解：B 解答を投票する

質問 16

Which two are true about memory advisors? (Choose two.)

（A）If Automatic Memory Management is enabled, no memory advisors are available.

（B）If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.

（C）All memory advisors use data from Automatic Workload Repository.

（D）If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.

（E）If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.

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

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

質問 17

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

（A）The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

（B）The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

（C）RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.

（D）The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

（E）RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

（F）The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

（G）RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

（H）The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.

正解：A、E、G、H 解答を投票する

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

質問 18

Which are the three steps in the SQL tuning process for Oracle Database environments?

（A）Test tuned SQL statements one at a time for all statements in the application.

（B）Tune individual SQL statements using the SQL Tuning Advisor.

（C）Identify poorly tuned SQL statements using the SQL Tuning Advisor.

（D）Test the application as a whole using tuned SQL statements.

（E）Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

（F）Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

正解：B、D、F 解答を投票する

1Z1-083 無料問題集「Oracle Database Administration II」

弊社を連絡する

関連リンク

トップ試験