[2025年03月14日] 最新の1Z0-083試験の的確なOracle Database Administration IIのPDF問題
1Z0-083試験問題を練習するならFast2test顕著なOracle Database Administration II試験練習問題集
質問 # 158
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. Stateless alerts can be cleared manually.
- D. Stateless alerts are automatically cleared.
- E. Stateful alerts must be created by a DBA after resolving the problem.
正解：C、E
解説：
Explanation/Reference: https://jameshuangsj.wordpress.com/2019/12/01/clears-stateless-alerts-in-oem-by-using-emcli/
質問 # 159
Which three are true In Oracle 19c and later releases?
- A. Tablespaces never remain In read/write mode during transportable tablespace operations.
- B. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
- C. Tablespaces always remain In read/write mode during transportable tablespace operations.
- D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
- E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
- F. A transportable data pump import can leave a plugged-in tablespace In read/write mode.
正解：C、D、E
質問 # 160
Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)
- A. creating thte oraInventory (oinstall) group
- B. performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met
- C. creating the grid OS user
- D. creating the OSDBA (dba) group
- E. creating the oracle OS user
- F. configuring the OS for Oracle Automatic Storage Management shared storage access
正解：A、D、E
解説：
Reference:
https://docs.oracle.com/cd/E11882_01/install.112/e41961/prelinux.htm#CWLIN2932
質問 # 161
Examine this configuration:
33.CDB1is a container database running in ARCHIVELOGmode.
34.Multiple uncommitted transactions are running in CDB1.
35.Redo log groups 1 and 2 are INACTIVE.
36.Redo log group 3 is the CURRENTgroup.
All members of redo log group 3 are lost before it is archived.
Examine these possible steps:
37.SHUTDOWN ABORT
38.STARTUP NOMOUNT
39.STARTUP MOUNT
40.ALTER DATABASE MOUNT
41.RESTORE DATABSE
42.RECOVER DATABASE NOREDO
43.RECOVER DATABASE UNTIL AVAILABLE
44.RESTORE ARCHIVELOG ALL
45.ALTER DATABSE OPEN
46. ALTER DATABASE OPEB RESETLOGS
Choose the minimum required steps in the correct order to recover the database.
- A. 1, 2, 5, 7, 4, 10
- B. 1, 3, 5, 7, 10
- C. 1, 3, 5, 6, 10
- D. 1, 3, 5, 8, 6, 10
- E. 1, 3, 5, 6, 9
正解：C
質問 # 162
Which two are true about the SQL Tuning Advisor?
- A. It considers all SQL statements being analyzed by the advisor task as a group.
- B. It prevents performance regressions for SQL statements when changes are made.
- C. It can recommend semantic changes to SQL statements.
- D. It checks each query being analyzed for missing or stale statistics.
- E. It only recommends syntactic changes to SQL statements.
正解：C、D
質問 # 163
Which two are true about Optimizer Statistics? (Choose two.)
- A. They can be gathered by the DBMS_STATS package.
- B. They are gathered by the SQL Tuning Advisor.
- C. They are ignored by Optimizer if they are stale.
- D. By default, they are automatically gathered by a maintenance job.
- E. They provide real-time data about schema objects.
正解：A、D
質問 # 164
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)
- 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 commandcompilation to be written to a log file and to standard output.
- C. Media Management messages for SBT devices are always written to sbtio.log.
- D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
- E. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
- F. Media Management messages for SBT devices are written to an Oracletrace file.
正解：D、F
質問 # 165
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
- A. the number of data files containing extents belonging to tables updated by a transaction
- B. poorly written SQL
- C. poorly trained users who do not commit transactions
- D. the number of tablespaces containing tables updated by a transaction
- E. issuing multiple savepoints during a transaction
正解：B、C
解説：
About Concurrency and Scalability
The better your application handles concurrency, the more scalable it is.
Concurrency is the simultaneous execution of multiple transactions. Statements within concurrent transactions can update the same data. Concurrent transactions must produce meaningful and consistent results. Therefore, a multiuser database must provide the following:
Data concurrency , which ensures that users can access data at the same time.
Data consistency, which ensures that each user sees a consistent view of the data, including visible changes from his or her own transactions and committed transactions of other users
質問 # 166
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- B. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- C. If the password file location changes, then the new location is used automatically by the Oracle Server.
- D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
- E. Schema Only accounts can be granted administrator privileges.
- F. All the Oracle-supplied accounts are Schema Only accounts.
正解：B、D、E
解説：
You can grant administrative privileges, such as SYSOPER and SYSBACKUP, to schema-only (passwordless) accounts. (B correct)
- Privilege analysis is now available as part of Oracle Database Enterprise Edition. (D correct)
- The unified auditing top-level statements feature enables you to audit top-level user (direct user) activities in the database without collecting indirect user activity audit data. (F correct)
https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html
質問 # 167
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:
Which three are true? (Choose three.)
- A. A default service is created for the application root APP1.
- B. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
- C. APP1 can never be unplugged.
- D. An application seed PDB is created for APP1.
- E. An application root PDB is created for APP1.
- F. Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED.
正解：A、B、E
解説：
AB not APP1$SEED created because not uses AS SEED
F is incorrect -> If not have any PDBs plug to the APP container, you can unplug an APP container.
質問 # 168
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
- 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. Control file backups can be created while connected to the root container.
- D. Archived Redo Log backups can be created while connected to an application root CDB.
- E. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
正解：A、D
質問 # 169
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 considers all SQL statements being analyzed by the advisor task as a group.
- C. It checks each query being analyzed for stale statistics.
- D. It can recommend semantic changes to SQL statements.
- E. It only recommends syntactic changes to SQL statements.
- F. It checks each query being analyzed for missing statistics.
正解：C、D、F
解説：
https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning- advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673
質問 # 170
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- B. The V$RMAN_CONFIGURATION view displays only settings with valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- C. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
- D. A target database's persistent RMAN configuration settings are always stored in the target's control file
- E. The RMAN SHOW ALL command displays only settings with nondefault values.
- F. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
正解：A、B、D
質問 # 171
Which three are true about an application seed pluggable database (PDB)? (Choose three.)
- A. It is automatically synchronized with its application root PDB when an application is upgraded.
- B. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- C. It cannot be dropped from its application container.
- D. A new application PDB created by cloning an application seed PDB can have an up-to-date version of the application installed after cloning completes.
- E. It is not required in an application container.
- F. It is automatically synchronized with its application root PDB when an application is installed.
- G. It cannot be added to an application container after the application container has already been created.
正解：B、D、E
解説：
https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/creating-removing-application-containers-seeds-with-sql-plus.html#GUID-065649AC-18ED-4858-ACC5-36F011362A83
質問 # 172
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?
- A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
- B. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
- C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
- D. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- E. Re-createthepasswordfileintheOracleDatabase12cformat. Correct
正解：A、D
質問 # 173
Which two are true about RMAN duplexed backup sets? (Choose two.)
- A. They can be created by using the RMAN CONFIGURE command to specify duplexing before taking a backup.
- B. They can be created only by using the COPIES option of a BACKUP command.
- C. They must be written to media.
- D. They can be written only to disk.
- E. They can be written to media.
正解：A、E
解説：
In most cases, the easiest method of duplexing backup sets is to use BACKUP... COPIES or CONFIGURE ... BACKUP COPIES to duplex backup sets.
RMAN can duplex backups to either disk or tape, but cannot duplex backups to tape and disk simultaneously.
https://docs.oracle.com/en/database/oracle/oracle-database/18/bradv/configuring-rman-client- advanced.html#GUID-2A285F87-552A-4F36-A5B9-F25A69611B4B
質問 # 174
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- B. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
- C. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- D. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
- E. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
- F. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
正解：C、D、F
解説：
Reference:
https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction
+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in
+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd- U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v= onepage&q=FLASHBACK%20transaction%20query%20requires%20undo%20to%20retrieve%20all% 20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=false
https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm
質問 # 175
Which two are true about the execution of operating system scripts starting from Oracle Database 19c?
(Choose two.)
- A. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
- B. The sudo password can be specified in a response file.
- C. root.sh can be executed automatically by the Database installer only by using sudo credentials.
- D. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
- E. The sudo password must be specified in a response file.
- F. The root password cannot be specified in a response file.
正解：D、F
質問 # 176
Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?
- A. Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- B. A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
- C. Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.
- D. A target database's persistent RMAN configuration settings are always stored in the target's control file.
正解：B
質問 # 177
Choose the best answer. Examine this output of an export from the current release of an Oracle multitenant database: $ sqlplus system/oracle . SQL> col name for a10 SQL> select name, open_mode from v$pdbs; NAME OPEN_MODE ---------------------------------------PDB$SEED READ ONLY PDB1 READ WRITE PDB2 MOUNTED SQL> exit Next you execute: $ expdp system/oracle full=y What is the outcome?
- A. It creates a full export of only the used while connected to the root container and PDB1. container and all PDBs. container and all open PDBs. root container.
- B. It creates a full export of the root
- C. It fails because Data Pump cannot be container.
- D. It creates a full export of the root
正解：C
質問 # 178
A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2.
You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time.
Which three are required?
- A. CDB2 must be in shared UNDO mode only.
- B. CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
- C. CDB2 must be in archivelog mode.
- D. CDB1 and CDB2 must be in shared UNDO mode.
- E. CDB1 must be in archivelog mode.
- F. CDB1 and CDB2 must both be in local UNDO mode.
正解：C、E、F
質問 # 179
......
試験を受けるためには、候補者は基本的なデータベース管理の概念と実践についての堅固な理解、およびOracle Databaseテクノロジーでの作業経験が必要です。また、Oracle Database Administration I試験（1Z0-082）を修了しているか、同等の知識と経験を持っている必要があります。試験は80問の多肢選択問題から成り、制限時間は120分です。
試験問題と解答は1Z0-083学習ガイド問題解答：https://jp.fast2test.com/1Z0-083-premium-file.html
練習用1Z0-083にはFast2test顕著な問題集はあなたをOracle Database Administration II試験合格させます合格させる：https://drive.google.com/open?id=19l-cg96t69eJYN-cfxpRV5I2meYH-Mi1