1Z0-083のPDF問題集で2023年12月20日最近更新された問題 [Q169-Q193]

1Z0-083のPDF問題集で2023年12月20日最近更新された問題

1Z0-083試験問題有効な1Z0-083問題集PDF

Oracle Database Administration IIとしても知られるOracle 1Z1-083は、Oracleデータベースの管理と維持におけるデータベース管理者のスキルと知識を検証する認定試験です。この試験は、Oracle Database Administration I認定をすでに獲得しており、データベース管理に関する知識と専門知識をさらに進めたい専門家向けです。

 

質問 # 169
Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY
PDB1 is open READ WRITE
PDB2 is MOUNTED.
ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A. CDB1 and PDB$SEED only
• B. PDB$SEED, PDB1, and PDB2 only
• C. CDB1, PDB$SEED, PDB1, and PDB2
• D. CDB1, PDB1, and PDB2 only
• E. CDB1, PDB$SEED, and PDB1 only

正解：E

質問 # 170
Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

• A. Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.
• B. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.
• C. Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.
• D. If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F
• E. If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

正解：A、C、E

質問 # 171
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases?

• A. A PDB snapshot depends on a storage snapshot which can be stored on any file system
• B. A PDB snapshot is always a full copy of the source PDB
• C. A snapshot copy PDB can be created from a stand-alone clone PDB
• D. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system
• E. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems
• F. A PDB snapshot is always a sparse copy of the source PDB
• G. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems

正解：F、G

質問 # 172
Which two are true about gathering optimizer statistics? (Choose two.)

• A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
• B. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.
• C. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
• D. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
• E. System statistics can be gathered only while connected to CDB$ROOT.

正解：A、C

解説：
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%20have%20to,independently%20from%20the%20CDB%24ROOT.&text=Oracle%20Database%20automatically%20gathers%20fixed,Automatic%20Optimizer%20Statistics%20Collection%E2%80%9C) .
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/20/arpls/DBMS_STATS.html

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

• A. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• B. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.
• C. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• D. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• E. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• F. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• G. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
• H. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

正解：E、F、G、H

質問 # 174
While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)

• A. Enable asynchronous disk I/O.
• B. Increase the size of tape I/O buffers.
• C. Disable FORCE LOGGING for the database.
• D. Increase the size of the database buffer cache.
• E. Increase the level of RMAN multiplexing.

正解：C、D

質問 # 175
choose three Which three RMAN persistent settings can be set explicitly?

• A. control file auto backup formats
• B. archive log deletion policy
• C. redo log backup duplexing
• D. image copy duplexing
• E. archive log backup duplexing
• F. SPFILE backup duplexing

正解：A、B、E

質問 # 176
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)

• A. automatically dropping the database link to the remote database if it already exists
• B. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
• C. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
• D. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
• E. opening the cloned PDB
• F. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
• G. creating a new empty PDB in the local database from PDB$SEED

正解：A、B、D

質問 # 177
Which two are true about memory advisors? (Choose two.)

• A. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
• B. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
• C. 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.
• D. If Automatic Memory Management is enabled, no memory advisors are available.
• E. All memory advisors use data from Automatic Workload Repository.

正解：B、D

質問 # 178
You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY ( END; object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY ( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', => 'SCOTT_EMP_VW', => DBMS_REDACT.NONE, => 'SYS_CONTEXT (''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

• A. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• B. DataisredactedforEMP.SALcolumnonlyiftheSCOTTsessionhastheMGRroleset.
• C. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. Correct
• D. DataisredactedfortheEMP.SALcolumnonlyiftheSCOTTsessiondoesnothavetheMGR role set.
• E. Data is never redacted for the EMP_VW.SAL column.

正解：D、E

質問 # 179
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A. It empties the RECYCLE BIN.
• B. It sets all user tablespaces to "read-only" before starting the upgrade.
• C. It increases tablespace size, if required, to meet upgrade requirements.
• D. It recompiles all stored PL/SQL code by using utlrp.sql.
• E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

正解：C、D、F

質問 # 180
Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

• A. It requires the use of fast recovery area (FRA).
• B. The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.
• C. The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.
• D. The control file is backed up automatically each time the SPFILE is backed up manually.
• E. The control file is backed up whenever a new tablespace is created.
• F. The control file is backed up whenever a new table is created.

正解：C、D、E

質問 # 181
Which two are true about Optimizer Statistics? (Choose two.)

• A. They are ignored by Optimizer if they are stale.
• B. They are gathered by the SQL Tuning Advisor.
• C. They provide real-time data about schema objects.
• D. By default, they are automatically gathered by a maintenance job.
• E. They can be gathered by the DBMS_STATS package.

正解：D、E

質問 # 182
Which two are true about the Oracle database methodology? (Choose two.)

• A. Tuning activities should stop once the user is satisfied with performance.
• B. SQL statements should always be tuned before tuning any file systems.
• C. The alert log should be used to find the database and instance areas most in need of tuning.
• D. Tuning activities should stop once agreed service levels for performance have been met.
• E. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
• F. The database instance memory should always be tuned before tuning any file systems.

正解：B、E

質問 # 183
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

• A. A new PDB is automatically created when importing a non-CDB into a CDB.
• B. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
• C. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
• D. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
• E. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
• F. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.

正解：E、F

質問 # 184
Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• B. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• C. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• D. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• E. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
• F. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

正解：B、D、E

解説：
Explanation/Reference: https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm

質問 # 185
Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

• A. It can be used to provision applications.
• B. It is an Oracle Database service
• C. It can be used to provision middleware.
• D. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
• E. It cannot be used to upgrade Oracle Database homes.

正解：C、D

解説：
Reference:
https://www.oracle.com/assets/rapid-home-provisioning-2405191.pdf

質問 # 186
Examine this configuration: 1. CDB1 is a container database. 2. COMMON_USER_PREFIX is C##. 3. PDB1 is a pluggable database contained in CDB1. 4. APP1_ROOTis an application container contained in CDB1. 5. APP1_PDB1 is an application PDB contained in APP1_ROOT. You execute these commands successfully: Which two are true? (Choose two.)

• A. P1_USER1can be created in CDB1.
• B. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
• C. APP1_USER1can be created in PDB1.
• D. C##_USER1will have the same privileges and roles granted in all PDBs in CDB1.
• E. C##_APP_USER1 can be created in CDB1.
• F. APP1_USER1can be created in CDB1.

正解：B、E

質問 # 187
Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A. Uncommitted transactions in CDB1and PDB1have been rolled back.
• B. Uncommitted transactions in PDB1have been rolled back.
• C. CDB1is in MOUNT state
• D. CDB1is shut down.
• E. PDB1is closed.

正解：C、E

質問 # 188
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)

• A. By default, the transported database will use Oracle Managed Files (OMF)
• B. Data files can be converted on the source system.
• C. Databases can be transported between systems with different endian formats.
• D. A new DBID is automatically created for the transported database.
• E. Data files can be converted on the destination system.
• F. The password file is automatically converted by RMAN.

正解：A、B、E

質問 # 189
Which three are true about performing an Oracle Database install on Linux?

• A. The Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.
• B. The runfixup.sh script can install missing RPMs.
• C. It can be done after installing Grid Infrastructure for a Standalone Server.
• D. It can be done before installing Grid Infrastructure for a Standalone Server.
• 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. The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.
• G. It allows you to select the languages supported by the Oracle database server.

正解：D、F、G

質問 # 190
A database is configured in ARCHIVE LOG mode. 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 the SYSTEM tablespace
• B. after losing an archived log from before the most recent backup
• C. when any archived log from, before, or after the most recent backup is corrupt.
• D. after losing an archived log from after the most recent backup
• E. after losing all copies of the control file

正解：A、B

質問 # 191
Which two are true about instance recovery? (Choose two.)

• A. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
• B. It is not possible if an archived log is missing.
• C. It is performed by the Recovery Writer (RVWR) background process.
• D. It is performed automatically while the database remains in MOUNT state. Then the database is opened.
• E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
• F. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.

正解：D、E

質問 # 192
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

• A. Data Recovery Advisor can proactively check for failures.
• B. The Data Recovery Advisor CHANGE FAILUREcommand can be used only to change failure priorities.
• C. Using the Data Recovery Advisor LIST FAILUREcommand always requires that the database for which failures are to be listed is in MOUNTstate.
• D. A failure can be closed only when it has been repaired.
• E. Data Recovery Advisor can be used if a database is closed.

正解：A、B

解説：
Explanation/Reference:

質問 # 193
......

1Z0-083問題集合格確定させる練習には285問があります：https://www.goshiken.com/Oracle/1Z0-083-mondaishu.html

1Z0-083練習テスト問題解答更新された285問があります：https://drive.google.com/open?id=1AM7Ponn5uC-GNYgevVY498FuHAbXSlEA