検証済みの1Z1-083問題集と解答で合格保証もしくは全額返金 [2023年07月]
1Z1-083のPDF問題集で2023年07月16日最近更新された問題
Oracle 1Z1-083（Oracle Database Administration II）認定試験は、Oracleデータベースを管理および維持する責任があるデータベース管理者の知識とスキルをテストするために設計されています。この試験は、Oracleデータベースでの作業経験があり、データベース管理の認定を取得することでキャリアを進めたい専門家を対象としています。試験は、データベースアーキテクチャ、パフォーマンスチューニング、バックアップとリカバリ、セキュリティ、トラブルシューティングなど、データベース管理に関連する幅広いトピックをカバーしています。
Oracle 1Z0-083 認定試験は、データベース管理におけるキャリアアップを目指す専門家にとって人気のある選択肢です。経験豊富なデータベース管理者を対象に、この試験はOracleデータベース環境の管理とメンテナンス能力を試します。
質問 # 102
choose three Which three are true about RMAN duplexed backup sets or image copies?
- A. A backup set may be duplexed so that one copy is written to sbt and the other to disk.
- B. A backup set may be duplexed with both copies written to disk.
- C. A backup set may be duplexed with both copies written to sbt.
- D. An image copy on sbt can be copied to disk.
- E. An image copy on disk can be copied to disk.
- F. An image copy on disk can be copied to sbt.
正解：B、C、E
質問 # 103
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- C. Only the grid user can perform the upgrade.
- D. An existing Oracle base can be used.
- E. Existing Oracle Database instances must be shut down before starting the upgrade.
- F. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
正解：C、E、F
解説：
Reference:
https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
質問 # 104
Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?
- A. Tune individual SQL statements using the SQL Tuning Advisor.
- B. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
- C. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
- D. Test tuned SQL statements one at a time for all statements in the application.
- E. Test the application as a whole using tuned SQL statements.
- F. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
正解：A、E、F
質問 # 105
Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2.
COMMON_USER_PREFIX is set to an empty string. 3. PDB1 is a pluggable database in CDB1. 4. APP1_ROOT is an application container in CDB1. 5. APP1_PDB1 is an application PDB in APP1_ROOT. You execute these commands: S sqlplus sys/oracle@localhost:1521/cdb1 as sysdba SQL> CREATE ROLE role1 CONTAINER=CURRENT; Which is true?
- A. It will return an error because common roles must start with C##.
- B. ROLE1 will be created only in CDB$ROOT and APP1_ROOT.
- C. ROLE1 will be created only in CDB$ROOT.
- D. It will return an error because creation of a local role is not allowed in CDB$ROOT.
- E. ROLE1 will be created in CDB$ROOT, PDB1, APP1_ROOT, and APP1_PDB1.
正解：D
質問 # 106
Which two are true about Optimizer Statistics? (Choose two.)
- A. By default, they are automatically gathered by a maintenance job.
- B. They can be gathered by the DBMS_STATS package.
- C. They are gathered by the SQL Tuning Advisor.
- D. They provide real-time data about schema objects.
- E. They are ignored by Optimizer if they are stale.
正解：A、B
質問 # 107
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
- A. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
- B. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- C. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- D. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- E. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- F. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
正解：A、C、F
質問 # 108
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?
- A. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- B. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct
- C. Settingthetargettablespacetoread-only
- D. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- E. Setting the target tablespace offline
正解：A、C
質問 # 109
Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true?
- A. PDB1 and PDB2 are in mount state.
- B. PDB$SEED is in read only state.
- C. PDB1 and PDB2 are in read only state.
- D. CDB$ROOT is in mount state.
- E. Redo logs are opened.
正解：C、E
質問 # 110
Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?
- A. when the total number of locked user account exceeds a specific value
- B. when the number of logons per second exceeds a specific value
- C. when free space in a locally managed tablespace falls below a specified percentage
- D. when free space in a dictionary managed tablespace falls below a specified percentage
- E. when a resumable statement is suspended
- F. when the total number of logons exceeds a specific value
正解：A、B、C
質問 # 111
Which three are true about using Database Resource Manager in an Oracle multitenant environment?
(Choose three.)
- A. A CDB-level resource plan is mandatory when using PDB-level resource plans.
- B. A CDB-level resource plan can limit PDB UNDO use.
- C. A CDB-level resource plan can limit PDB CPU utilization.
- D. PDB-level resource plans can limit uncommitted UNDO per consumer group.
- E. A CDB-level resource plan can limit session CPU utilization.
- F. A PDB-level resource plan can limit session PGA memory.
正解：A、B、E
質問 # 112
Choose two. Which two are true about Oracle Database Configuration Assistant (DBCA)?
- A. It can be used to convert a non-container database to a container database.
- B. It can be used to change the character set of an existing database.
- C. It can be used to create container databases and non-container databases.
- D. It can only be launched from the command line interface.
- E. It can be launched from both the command line and the Universal Installer (OUI) interfaces.
正解：C、E
質問 # 113
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
(Choose three.)
- A. Media Management errors appear as a line with "sbtio".
- B. Some messages in the error stack are not errors.
- C. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
- D. Media Management errors appear as a line with "sbtio" and a number.
- E. Media Management errors appear as a line with "Additional information" and a number.
- F. If an RMAN command fails, the output will only identify the command that failed.
正解：A、C、E
質問 # 114
Which two are true about RMAN encryption? (Choose two.)
- A. RMAN can encrypt the Oracle Database password file.
- B. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
- C. RMAN encryption keys are stored in a database keystore.
- 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.
正解：D、E
質問 # 115
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?
- A. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- B. These backups can be written to disk or SBT.
- C. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- D. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
- E. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
正解：A、E
質問 # 116
Choose two. Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases?
- A. Space is always reclaimed proactively before space pressure occurs.
- B. Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
- C. Space is only reclaimed when there is space pressure in the Fast Recovery Area (FRA).
- D. Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
- E. Space might be reclaimed proactively before space pressure occurs.
正解：C、E
質問 # 117
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)
- A. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
- B. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- C. The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.
- D. SBT tape compression can be used even if no RMAN compression is configured.
- E. SBT tape compression and RMAN backup compression should be used in parallel.
正解：C、E
質問 # 118
Which two are true about Oracle instance recovery? (Choose three.)
- A. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
- B. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
- C. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
- D. Recovery begins from the beginning of the CURRENT redo log group.
- E. Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the datanase is opened.
- F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
正解：A、C、F
質問 # 119
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
Which three are true?
- A. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- B. The restore point is a label for the system change number (SCN) before the archival backup was taken.
- C. The control file is included in the self-contained archival backup.
- D. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- E. All archive logs created after this backup are kept for two years.
- F. The spfile is included in the self-contained archival backup.
正解：C、E、F
質問 # 120
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
- C. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- D. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- E. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
- F. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
正解：A、B、F
質問 # 121
......
1Z1-083試験問題有効な1Z1-083問題集PDF：https://jp.fast2test.com/1Z1-083-premium-file.html