更新された2023年12月テストエンジン練習1Z1-083問題集と練習試験合格させます
問題集お試しセット1Z1-083テストエンジンで問題集トレーニングには285問あります
Oracle 1Z1-083認定試験では、バックアップと回復、パフォーマンスチューニング、セキュリティ、データベースアーキテクチャなど、幅広いトピックをカバーしています。候補者は、これらのトピックを深く理解し、実際のシナリオに知識を適用できることが期待されています。この試験は80の複数選択の質問で構成されており、候補者はそれを完了するのに2時間あります。
質問 # 37
Choose three. Which three actions are mandatory post database upgrade?
- A. Updating client scripts with the new Oracle home.
- B. Upgrading user tables that depend on Oracle-maintained abstract data types.
- C. Run OPatch commands from the new Oracle home.
- D. Migration to unified auditing.
- E. Resetting passwords to enforce case-sensitivity.
- F. Setting threshold values for tablespace alerts.
正解：A、B、C
質問 # 38
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. opening the cloned PDB
- B. creating a database link from CDB$ROOT in the remote database to be cloned to CDB$ROOT in the local database
- C. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
- D. creating a new empty PDB in the local database from PDB$SEED
- E. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
- F. automatically dropping the database link to the remote database if it already exists
- G. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
正解：C、F、G
質問 # 39
Which two are true about RMAN encryption?
- A. RMAN encryption keys are stored in a database keystore.
- B. Password encryption can be persistently configured using the configure encryption command.
- C. RMAN can encrypt the Oracle Database password file.
- D. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- E. The set encryption command overrides encryption settings specified by the configure encryption command.
正解：A、E
質問 # 40
Which two are true about server-generated alerts? (Choose two.)
- A. Stateful alerts are purged automatically from the alert history.
- B. Stateless alerts can be purged manually from the alert history.
- C. Stateful alerts must be created by a DBA after resolving the problem.
- D. Stateless alerts are automatically cleared.
- E. Stateless alerts can be cleared manually.
正解：C、E
解説：
Explanation/Reference: https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/
質問 # 41
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- B. The Oracle Grid Infrastructure installation must be owned by the grid user.
- C. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- D. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
- E. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- F. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
正解：A、E
解説：
Explanation/Reference: https://docs.oracle.com/database/121/CWWIN/usrgrps.htm#CWWIN-GUID-6FD3C6AE-5A99-
4C6D-85D6-868CBA6F5DAE
質問 # 42
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)
- A. temporary tablespaces
- B. the log writer process (LGWR)
- C. SYSAUX tablespaces
- D. undo tablespaces
- E. the data dictionary in CDB$ROOT
- F. the Process Monitor Process (PMON)
正解：A、E、F
質問 # 43
choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA. Which two files are removed automatically if space is required in the FRA as per the retention policy?
- A. RMAN backups that are obsolete
- B. archived redo log files that have multiple copies in a different archive location
- C. flashback logs
- D. user-managed backups of data files and control files
正解：A、C
質問 # 44
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. Disable FORCE LOGGING for the database.
- B. Enable asynchronous disk I/O.
- C. Increase the size of tape I/O buffers.
- D. Increase the size of the database buffer cache.
- E. Increase the level of RMAN multiplexing.
正解：B、E
質問 # 45
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
- A. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- B. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
- C. It empties the RECYCLE BIN.
- D. It increases tablespace size, if required, to meet upgrade requirements.
- E. It sets all user tablespaces to "read-only" before starting the upgrade.
- F. It recompiles all stored PL/SQL code by using utlrp.sql.
正解：A、D、F
解説：
Reference:
https://oracle-base.com/articles/12c/upgrading-to-12c
質問 # 46
Which three are true about using Database Resource Manager in an Oracle multitenant environment?
(Choose three.)
- A. A CDB-level resource plan can limit PDB CPU utilization.
- B. PDB-level resource plans can limit uncommitted UNDO per consumer group.
- C. A CDB-level resource plan can limit PDB UNDO use.
- D. A CDB-level resource plan can limit session CPU utilization.
- E. A PDB-level resource plan can limit session PGA memory.
- F. A CDB-level resource plan is mandatory when using PDB-level resource plans.
正解：C、D、F
質問 # 47
Choose three. Which three are true about Audit policies in container databases (CDBs)?
- A. A common unified audit policy can be created at the CDB level.
- B. Fine-grained auditing policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
- C. A common unified audit policy can be created at the application root level.
- D. Application-common unified audit policies defined in an application root must be manually synchronized by each application PDB contained in the application root.
- E. All audit records are written to the audit trail in CDB$ROOT .
- F. An application PDB cannot have a local audit policy.
正解：A、C、D
質問 # 48
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- B. Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
- C. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- D. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- E. Backing up a database in ARCHIVE LOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
- F. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the databased be in the MOUNT state.
- G. An Oracle database can be restored from backup files copied using O/S utilities.
正解：C、D、G
質問 # 49
Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?
- A. It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.
- B. It is a set of recommendations by the optimizer to change the access methods used.
- C. It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.
- D. It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.
- E. It is a set of recommendations by the optimizer to create new indexes.
正解：C
質問 # 50
Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?
- A. redo logs
- B. control files
- C. mandatory Oracle-supplied PL/SQL packages
- D. user-defined PL/SQL packages
- E. undo tablespaces
- F. temporary tablespaces
- G. all data dictionary metadata
正解：A、B、G
質問 # 51
Identify three scenarios in which RMAN will use backup sets to perform active database duplication.
- A. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
- B. when you perform active database duplication on a database that has readonly tablespaces
- C. when you perform active database duplication on a database with flashback disabled
- D. when you specify set encryption before the duplicate ... from active database command
- E. when the duplicate ... from active database command contains the section size clause
正解：A、D、E
質問 # 52
Which two statements are true about the Database Configuration Assistant (DBCA)?
- A. It can generate SQL database creation scripts.
- B. It can configure Automatic Storage Management (ASM) diskgroups.
- 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 be used to add a new tablespace.
- E. It can be used to create a database template from an existing database.
正解：A、E
質問 # 53
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?
- A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
- B. CDB1_TAB only
- C. CDB1_TAB and APP_PDB1_TAB
- D. CDB1_TAB and APP_ROOT_TAB
- E. none of the tables, because all three tables will be dropped
正解：C
質問 # 54
hoose two. Which two are true about Recovery Manager (RMAN) diagnostic message output?
- A. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- B. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
- C. Media Management messages for SBT devices are written to an Oracle trace file.
- D. MAN error stacks should be read from the top down as that is the order in which errors are generated.
- E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
正解：D、E
質問 # 55
Choose two. Which two are true about creating RMAN backups for an Oracle container database?
- A. Control file backups can be created while connected to a nonroot container.
- B. Online Redo Log backups can be created while connected to the root container.
- C. Archived Redo Log backups can be created while connected to an application root CDB.
- D. Control file backups can be created while connected to the root container.
- E. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
正解：D、E
質問 # 56
A database is configured in ARCHIVE LOG mode. A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)
- A. after losing an UNDO tablespace that is in use
- B. after losing all members of the CURRENT online redo log group
- C. after losing all copies of the control file
- D. after losing a SYSAUX tablespace data file
- E. after losing all members of an INACTIVE online redo log group
正解：B、C
質問 # 57
Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)
- A. SQL statements that were originally run concurrently are run concurrently by SPA.
- B. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
- C. It provides before and after execution statistics for each SQL statement in the analysis task
- D. It is integrated with the SQL Access Advisor.
- E. It predicts the impact of system changes on SQL workload response time.
正解：B、E
解説：
Reference:
https://www.oracle.com/technetwork/database/manageability/spa-ow09-131455.pdf (4)
質問 # 58
......
Oracle 1Z0-083認定試験の対象となるには、データベース管理の概念に強力な基盤があり、Oracle Database Administration I認定試験に合格する必要があります。また、バックアップと回復の経験、パフォーマンスチューニング、セキュリティ管理など、Oracleデータベースを操作する実際の経験が必要です。試験の準備は困難な場合がありますが、Oracleの公式研究資料、練習試験、トレーニングコースなど、多くのリソースが利用可能です。
Oracle 1Z1-083問題集カバー率リアル試験問題：https://jp.fast2test.com/1Z1-083-premium-file.html