最上級の1Z1-083試験問題Oracleテスト最高成績で最速合格をゲットせよ！
試験準備には最適な1Z1-083試験問題2022年最新のOracle Database 19c究極な160問があります
Oracle 1Z1-083 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
質問 73
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)
- A. cloning a remote pluggable database in silent mode
- B. relocating a remote pluggable database in silent mode
- C. relocating a remote container database in silent mode
- D. cloning a remote container database in silent mode
- E. relocating a remote pluggable database in interactive mode
- F. cloning a remote container database in interactive mode
- G. relocating a remote container database in interactive mode
正解: B,D,E
解説:
Explanation/Reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/clone-pdbs-using-dbca-silent- mode/index.html?
learningpath=true&appuser=nobody&appsession=170971049395&contentid=26693&activityname=Clone%
20PDBs%20using%20DBCA%20in%20Silent%20Mode&eventid=6352
質問 74
Which two are true about the Optimizer Statistics Advisor?
- A. It runs automatically every night by default.
- B. It can be run only automatically.
- C. It always analyzes all schemas in the database.
- D. It can be run only manually.
- E. It can recommend changes to improve the statistics gathering process.
正解: B,E
質問 75
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
- A. oracle will be an owner of the Oracle Inventory.
- B. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
- C. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
- D. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
- E. oracle must be the owner of every Oracle Database installation.
正解: C,D
質問 76
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)
- A. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
- B. It is always possible for RMAN to connect to a pluggable database as a target.
- C. A Virtual Private Catalog used to register a container database can be created in a non-container database.
- D. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
- E. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
- F. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
正解: B,C,E
質問 77
Which two are true about the character sets used in an Oracle database? (Choose two.)
- A. Single-byte character sets provide better performance than multibyte character sets.
- B. Unicode enables information from any language to be stored using a single character set.
- C. Multibyte character sets allow more efficient space utilization than single byte character sets.
- D. Single-byte character sets always use 8-bit encoding schemes.
- E. Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).
- F. Single-byte character sets always use 7-bit encoding schemes.
正解: A,B
質問 78
Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)
- A. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.
- B. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
- C. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
- D. CDB$ROOT and PDB$SEED are automatically duplicated.
- E. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
正解: B,C
解説:
Reference:
https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV430
質問 79
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
- B. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- C. All the Oracle-supplied accounts are Schema Only accounts.
- D. Schema Only accounts can be granted administrator privileges.
- E. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- F. If the password file location changes, then the new location is used automatically by the Oracle Server.
正解: A,C,D
解説:
Reference:
https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
質問 80
Which three are true about recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. A lost SPFILE can be recovered from memory using SQL*PLUS.
- B. A lost PFILE can be re-created alert.log using SQL*PLUS.
- C. A lost TEMPFILE must always be re-created manually.
- D. A lost password file can be manually re-created with the orapwd utility.
- E. A lost index tablespace can be re-created without performing any recovery.
- F. A lost password file can be re-created with SQL*PLUS.
正解: B,D,F
質問 81
Which three are true about SGA memory management in a multitenant database? (Choose three.)
- A. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
- B. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.
- C. SGA_MIN_SIZE cannot be set for a PDB.
- D. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
- E. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.
- F. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.
正解: B,C,D
質問 82
Which two are true about RMAN encryption?
- A. Password encryption can be persistently configured using the configure encryption command.
- B. RMAN can encrypt the Oracle Database password file.
- C. RMAN encryption keys are stored in a database keystore.
- D. The set encryption command overrides encryption settings specified by the configure encryption command.
- E. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
正解: C,D
質問 83
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 beginning of the CURRENT redo log group.
- C. Recovery reads redo until the end of the redo thread. SMON rollsback any dead transactions, and then the datanase is opened.
- D. Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
- E. 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.
- F. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
正解: C,D,F
質問 84
Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives?
- A. Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.
- B. The SBT device should be configured to use parallelism 2 to allow both tape drives to be used simultaneously
- C. SBT tape compression and RMAN backup compression should be used in parallel.
- D. Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.
- E. SBT tape compression can be used even if no RMAN compression is configured.
正解: C,E
質問 85
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
- A. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
- B. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- C. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- D. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- E. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
正解: A,E,F
質問 86
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 transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- C. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
- D. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
- E. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
- F. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
正解: A,B,C
質問 87
Which two are prerequisites for using FLASHBACK TABLE? (Choose two.)
- A. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
- B. Row Movement must be enabled on the table being flashed back.
- C. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
- D. A table's constraints must be disabled before issuing the flashback.
- E. A table's indexes must be set to unusable before issuing the flashback.
正解: A,C
質問 88
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
- A. A failure can be closed only when it has been repaired.
- B. The Data Recovery Advisor change failure command can be used only to change failure priorities.
- C. Data Recovery Advisor can proactively check for failures.
- D. Using the Data Recovery Advisor list failure command always requires that the database for which failures are to be listed is in mount state.
- E. Data Recovery Advisor can be used if a database is closed.
正解: A,E
質問 89
Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)? (Choose three.)
- A. Oracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as IMAGE COPIES.
- B. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance bestarted and the dataabse be in the MOUNT state.
- C. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
- D. Oraclearchive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- E. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- F. Backing up a database in ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in OPEN state.
- G. An Oracle database can be restored from backup files copied using O/S utilities.
正解: A,C,E
質問 90
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
- A. These backups can be written to disk or SBT.
- B. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- C. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- D. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
- E. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
正解: A,E
質問 91
The users tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace?
- A. Backups can be done incrementally.
- B. Backups can be taken only if the database is in archivelog mode.
- C. Only consistent backups can be created.
- D. Backups must be contained in backup sets.
- E. The database must be registered in an RMAN catalog.
- F. Backups must be done incrementally.
正解: A,D
質問 92
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. AWR data is stored in the SYSTEM tablespace.
- B. By default, AWR snapshots are taken every 60 minutes.
- C. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.
- D. The taking of AWR snapshots can be disabled.
- E. By default, AWR snapshots are retained for 7 days.
正解: B,C,D
質問 93
Which two are true about Oracle instance recovery?
- A. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (ckpt).
- B. Recovery reads redo until the end of the redo thread, smon rolls back any dead transactions, and then the database is opened.
- C. Recovery begins from the beginning of the current redo log group.
- 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 begins from the start of any active redo log group or the start of the current log group if no other group is active.
- F. Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure.
正解: A,E
質問 94
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 read only state.
- B. PDB1 and PDB2 are in mount state.
- C. Redo logs are opened.
- D. CDB$ROOT is in mount state.
- E. PDB$SEED is in read only state.
正解: C,D
質問 95
Which three are true about Database Point-in-Time Recovery?
- A. The database must be open resetlogs after Database Point-in-Time Recovery.
- B. The database must have flashback database on to perform Database Point-in-Time Recovery.
- C. The target point for the recovery must be specified as a time or System Change Number (SCN).
- D. The database must be in mount state when performing Database Point-in-Time Recovery.
- E. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- F. The database must be in archivelog mode.
正解: A,C,F
質問 96
......
注目の1Z1-083豪華セット試験ガイドで最速合格を目指そう：https://jp.fast2test.com/1Z1-083-premium-file.html