リアルOracle 1Z0-083試験問題集には正解283問題と解答があります
有効な1Z0-083テスト解答とOracle 1Z0-083試験PDF問題を試そう
質問 # 11
Which two are true about Oracle instance recovery? (Choose three.)
- A. 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.
- B. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
- C. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
- D. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
- 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 begins from the beginning of the CURRENT redo log group.
正解：B、D
質問 # 12
Which two statements are true about encrypted backups performed by using RMAN?
- A. Transparent encryption of backups uses an encryption wallet.
- B. A password encryption of backups uses the password while creating and restoring backups.
- C. Image copy backups can be created by using password encryption.
- D. A database uses the same encryption key for every encrypted backup.
- E. Encrypted backups can only be written to disk.
正解：A、B
質問 # 13
Examine this configuration:
* CDB1 is a container database.
* COMMON_USER_PREFIX is C##.
* PDB1 is a pluggable database contained in CDB1.
* APP1_ROOT is an application container contained in CDB1.
* APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. APP1_USER1 can be created in CDB1.
- B. APP1_USER1 can have different privileges in each Application PDB contained in APP1_ROOT.
- C. P1_USER1 can be created in CDB1.
- D. APP1_USER1 can be created in PDB1.
- E. C##_USER1 will have the same privileges and roles granted in all PDBs in CDB1.
- F. C##_APP_USER1 can be created in CDB1.
正解：B、E
質問 # 14
Choose two. Which two are true about various Oracle security and auditing capabilities?
- A. Application-common OLS policies can be created only if all the PDBs in the application container are closed.
- B. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- C. Application-common TSDP policies are always container specific.
- 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.
正解：B、E
質問 # 15
Which two are true about gathering optimizer statistics? (Choose two.)
- A. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/write mode gathers object statistics for that PDB.
- 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 CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)
- D. System statistics can be gathered only while connected to CDB$ROOT.
- E. Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.
正解：A、C
解説：
Explanation
https://mikedietrichde.com/2016/10/21/gather-fixed-objects-stats-in-pdbs-as-well/#:~:text=Yes%2C%20you'll%2
.
質問 # 16
Which three are true about SGA memory management in a multitenant database? (Choose three.)
- A. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
- B. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
- C. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
- D. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
- E. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
- F. SGA_MIN_SIZE cannot be set for a PDB.
正解：A、B、F
質問 # 17
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
- A. database instance memory management and sizes
- B. general operating system health
- C. database writer performance
- D. log writer performance
- E. SQL statements
正解：E
解説：
Because Oracle's memory requirements vary depending on your application, you should tune memory allocation after tuning your application and your SQL statements. Allocating memory before tuning your application and your SQL statements may make it necessary to resize some Oracle memory structures to meet the needs of your modified statements and application.
質問 # 18
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. 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. The V$RMAN_CONFIGURATIONview displays only settings with values that have been modified.
- E. The RMAN SHOW ALLcommand displays only settings with nondefault values.
- F. A target database's persistent RMAN configuration settings are always stored in the target's control file
- G. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
正解：D、F、G
解説：
Explanation/Reference: https://books.google.com.pk/books?
id=pUEkAAAAQBAJ&pg=PA114&lpg=PA114&dq=V$RMAN_CONFIGURATION+view+displays+only+settings
+with+values+that+have+been+modified&source=bl&ots=fhC9A7ULeX&sig=ACfU3U2- cGhTjmAOpCZhvlL5R4j6ixLRAw&hl=en&sa=X&ved=2ahUKEwjJzf- WmtnoAhXT8eAKHQ9uBG8Q6AEwAHoECAwQJg#v=onepage&q=V%24RMAN_CONFIGURATION%20view
%20displays%20only%20settings%20with%20values%20that%20have%20been%20modified&f=false
質問 # 19
Which three are true about Audit policies In container databases (CDBs)?
- A. Application-common unified audit policies defined In an application root must be manually synchronized by each application PDB contained in the application root.
- 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 CDB level.
- D. An application PDB cannot have a local audit policy.
- E. All audit records are written to the audit trail in CDB$ROOT
- F. A common unified audit policy can be created at the application root level.
正解：A、B、D
質問 # 20
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 middleware.
- B. It is an Oracle Database service
- C. It cannot be used to upgrade Oracle Database homes.
- D. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
- E. It can be used to provision applications.
正解：A、E
質問 # 21
Which two are true about data movement between a non-CDB and a PDB using Data Pump?
- A. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
- B. A new PDB is automatically created when importing a non-CDB into a CDB.
- C. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
- D. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
- E. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
- F. Tablespaces are automatically created as needed while importing full exports in either a non-CDB or a PDB.
正解：B、F
質問 # 22
Which two are true about Recovery Manager (RMAN) diagnostic message output?
- A. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
- B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
- C. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
- D. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
- E. Media Management messages for SBT devices are written to an Oracle trace file.
- F. Media Management messages for SBT devices are always written to sbtio.log.
正解：E、F
質問 # 23
Which are the three steps in the SQL tuning process for Oracle Database environments?
- A. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
- B. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
- C. Tune individual 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. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
正解：A、C、E
質問 # 24
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
- B. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
- C. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
- D. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- E. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- F. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
正解：C、D、E
質問 # 25
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- A. to include specific user tablespaces only when relocating a PDB
- B. to exclude a temp tablespace when plugging in a PDB
- C. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
- D. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
- E. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- F. to specify the list of tablespaces to include when creating a PDB from the CDB seed
正解：C、E
解説：
Reference:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/creating-and-removing- pdbs-with-sql-plus.html#GUID-1C47D543-8376-48AE-A1AE-632316731D59
質問 # 26
Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)
- A. The root password cannot be specified in a response file.
- B. orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
- C. root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
- D. The sudo password must be specified in a response file.
- E. root.sh can be executed automatically by the Database installer only by using sudo credentials.
- F. The sudo password can be specified in a response file.
正解：A、E
質問 # 27
Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome
Oracle_home_path
For which two purposes can you use this command? (Choose two.)
- A. to switch to a patched Oracle Database home
- B. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server
- C. to switch back to the previous Oracle home as part of a rollback operation
- D. to switch to a read-only Oracle home
- E. to switch an existing Oracle Database home to a newer release of Oracle software on the same server
正解：A、C
解説：
You can use rhpctl move gihome command with the same syntax to switch from the current Oracle Grid Infrastructure home to a patched home.
The rhpctl command enables you to switch from your current Oracle Grid Infrastructure or Oracle Database home to patched Oracle home so that you can provision the new Oracle home as gold image.
You can also use the rhpctl command to switch back to the old Oracle home, if you want to roll back the operation.
質問 # 28
Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)? (Choose three.)
- A. undo tablespaces
- B. temporary tablespaces
- C. SYSAUX tablespaces
- D. the data dictionary in CDB$ROOT
- E. the Process Monitor Process (PMON)
- F. the log writer process (LGWR)
正解：B、D、E
質問 # 29
Which two are true about backup set compression using RMAN default compression? (Choose two.)
- A. Compression can be done only for locally managed tablespaces.
- B. Compressed backups cannot have a section size defined.
- C. Compressed backups can be written only to media.
- D. Unused blocks below the high water mark are backed up.
- E. Binary compression adds CPU overhead to backup operations.
正解：A、E
解説：
Backup as compressed backupset device type disk database section size 100m; (not A, not D).
If they speak about Unused block compression then :
RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated (bellow HWM). (Not C) Data file has to be locally managed. (E)
質問 # 30
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
- A. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
- B. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.
- C. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.
- D. Oracle attempts to convert conventional database users to local users when moving schemas from a non- CDB to a PDB.
- E. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.
- F. A new PDB is automatically created when importing a non-CDB into a CDB.
正解：B、C
質問 # 31
Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?
- A. It can be performed using an auxiliary instance managed by RMAN.
- B. It can be used to recover a truncated table.
- C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
- D. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
- E. RMAN always includes tablespaces containing undo segments in the recovery set.
- F. It can be performed using an auxiliary instance managed by a DBA.
- G. It can be used to recover a dropped tablespace.
- H. flashback database must be enabled for it to work.
正解：A、D、F、H
質問 # 32
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 and target platforms must have the same endianness.
- C. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.
- D. The source PDB can be in MOUNT or OPEN state.
- E. The source PDB must not be an application root.
- F. Automatic conversion of endianness occurs.
正解：A、B
解説：
To platform or for transport any of the command can be used and the source DB needs to be in mounted mode.
https://blog.enmotech.com/2018/01/10/oracle-12cr2-cross-platform-pdb-transport-using-xtts/
質問 # 33
Which three conditions must be met before you create a Virtual Private Catalog (VPC)?
- A. At least one target database should be registered in the recovery catalog.
- B. The recovery_catalog_owner role should be granted to the virtual catalog owner.
- C. The owner of VPC cannot own recovery catalog.
- D. A base recovery catalog should exist.
- E. The register database privilege should be granted to the virtual catalog owner.
正解：C、D、E
質問 # 34
Which three are true about Automatic Workload Repository (AWR) snapshots?
- A. They are generated if STATISTICS LEVEL is set to ALL.
- B. They are generated if STATISTICS LEVEL is set to TYPICAL.
- C. They are always created automatically.
- D. They are generated if STATISTICS LEVEL is set to BASIC.
- E. They can be retained forever.
- F. They are always created manually.
正解：A、B、C
質問 # 35
......
Oracle 1Z0-083試験に備えるには、Oracleデータベース管理の概念について包括的な理解とOracleデータベースでの実践的な経験が必要です。候補者は、Oracleの公式試験学習ガイド、練習問題、オンライントレーニングコースなど、さまざまな学習資料を活用して試験に備えることができます。さらに、候補者は、プロの設定でOracleデータベースを扱うか、自分自身のラボ環境を作成することによって、実践的な経験を積むことができます。
Oracle 1Z1-083試験の準備をするために、候補者は、公式トレーニングコース、練習試験、学習ガイドなど、Oracleが提供するさまざまなリソースを利用できます。候補者は、Oracleデータベースを操作し、試験で取り上げられているタスクを練習することで、実践的な経験を積むこともできます。 Oracle 1Z1-083試験に合格することは、データベース管理者にとって重要な成果であり、より良い雇用機会とより高い給与につながる可能性があります。
Oracle 1Z0-083試験、またはOracle Database Administration II試験は、Oracleデータベースの管理と管理スキルを向上させたいプロフェッショナル向けの認定試験です。この試験は、Oracle Database Administration I試験に合格し、Oracleデータベースの管理に実践的な経験がある個人を対象としています。この試験に合格することは、Oracle Certified Professional（OCP）認定を取得するための要件です。
1Z0-083試験問題と有効な1Z0-083問題集でPDF：https://www.jpntest.com/shiken/1Z0-083-mondaishu
Oracle 1Z0-083認定リアル2024年最新の模擬試験：https://drive.google.com/open?id=1K-c51NyK7FzBUZv7oy21q0aZLDD1qt8n