2022年03月07日に更新された最新のFast2test 1Z1-083試験問題リアル1Z1-083問題集で
1Z1-083別格な問題集で最上級の成績にさせる1Z1-083問題
Oracle 1Z1-083 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
質問 59
Which three actions are performed by Database Upgrade Assistant (DBUA)?
- A. It removes the audsys schema and the audit_admin and audit_viewer roles.
- B. It recompiles all stored pl/sql code by using utlrp.sql.
- C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
- 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 empties the recycle bin.
正解: A,E,F
質問 60
Examine this configuration:
1. The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCL uses disk group +FRA for the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:
What is the outcome?
- A. Only the ORCL database instance is started.
- B. Only the ORCL database instance and the +DATA and +FRA disk groups are started.
- C. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
- D. Only the ORCL database and the ASM instances are started.
- E. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
正解: C
質問 61
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)
- A. after losing an archived log from before the most recent backup
- B. after losing the SYSTEM tablespace
- C. after losing all copies of the control file
- D. when any archived log from, before, or after the most recent backup is corrupt.
- E. after losing an archived log from after the most recent backup
正解: A,D
質問 62
For which two requirements can you use the user_tablespaces clause with the create pluggable database command?
- A. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- B. to specify a default tablespace in a PDB cloned from another PDB in the same CDB
- C. to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB
- D. to exclude a temp tablespace when plugging in a PDB
- E. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- F. to include specific user tablespaces only when relocating a PDB
正解: C,D
質問 63
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 ARCHIVELOG mode using O/S utilities requires that the database instance be started and the database be in MOUNT state.
- C. Oracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.
- D. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be started and the dataabse be in the MOUNT state.
- E. An Oracle database can be restored from backup files copied using O/S utilities.
- F. Backing up a database in NOARCHIVELOG mode using O/S utilities requires that the database instance be shut down.
- G. 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.
正解: A,E,F
質問 64
Examine this output:
Which two are true? (Choose two.)
- A. PDB3 can use all available parallel execution processes at times.
- B. PDB1is always limited to 40% of the available system resources regardless of demand.
- C. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- D. Any PDB not specified in the plan will be unable to execute statements in parallel.
- E. PDB2is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- F. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
正解: D,F
質問 65
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true?
- A. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- B. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- C. All non-Oracle files in the current FRAthat 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. These backups can be written to disk or SBT.
正解: D
質問 66
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. Only the grid user can perform the upgrade.
- B. Existing Oracle Database instances must be shut down before starting the upgrade.
- C. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- D. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- E. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
- F. An existing Oracle base can be used.
正解: A,B,C
質問 67
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? (Choose two.)
- A. Backups can be done incrementally.
- B. Only consistent backups can be created.
- C. Backups must be contained in backup sets.
- D. Backups can be taken only if the database is in ARCHIVELOG mode.
- E. The database must be registered in an RMAN catalog.
- F. Backups must be done incrementally.
正解: A,D
質問 68
Which two are true about RMAN duplexed backup sets?
- A. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
- B. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
- C. A non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.
- D. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
- E. A duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.
- F. A non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.
正解: A,E
質問 69
A schema owner truncated a table in error and must recover the data.
Which Oracle Flashback feature could be used to recover the data?
- A. FLASHBACK DATA ARCHIVE
- B. FLASHBACK DATABASE
- C. FLASHBACK TABLE
- D. FLASHBACK TRANSACTION
- E. FLASHBACK VERSION QUERY
正解: E
質問 70
Examine this output:
Which two are true? (Choose two.)
- A. PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.
- B. PDB3 can use all available parallel execution processes at times.
- C. Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.
- D. Any PDB not specified in the plan will be unable to execute statements in parallel.
- E. PDB1 is always limited to 40% of the available system resources regardless of demand.
- F. PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.
正解: D,F
質問 71
Which three are true about an application seed pluggable database (PDB)?
- A. It cannot be added to an application container after the application container has already been created.
- B. It Is automatically synchronized with its application root PDB when an application is upgraded.
- C. It is not required in an 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 automatically synchronized with its application root PDB when an application is installed.
- F. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
- G. It cannot be dropped from its application container.
正解: A,D,E,F
質問 72
Which two are true about instance recovery?
- A. It is not possible if an archived log is missing.
- B. It is performed by the Recovery Writer (rvwr) background process.
- C. Setting fast_start_mttr_target to a higher value reduces instance recovery time by causing the log writer to write more frequently, thereby reducing the number of I/Os needed during instance recovery.
- D. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
- E. Setting fast_start_mttr_target to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
- F. It is performed automatically while the database remains in mount state. Then the database is opened.
正解: A,B
質問 73
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. A target database's persistent RMAN configuration settings are always stored in the target's control file
- B. The V$RMAN_CONFIGURATIONview displays only settings with values that have been modified.
- C. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- D. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- E. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
- F. The RMAN SHOW ALLcommand displays only settings with nondefault values.
- G. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
正解: A,B,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
質問 74
Which three are true? (Choose three.)
- A. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- B. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
- C. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
- D. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- E. Application-common TSDP policies are always container specific.
- F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- G. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
正解: A,D,G
質問 75
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
- A. By default, AWR snapshots are taken every 60 minutes.
- B. The taking of AWR snapshots can be disabled.
- C. Its collection level is determined by the value of the STATISTICS_LEVELdatabase parameter.
- D. By default, AWR snapshots are retained for 7 days.
- E. AWR data is stored in the SYSTEMtablespace.
正解: A,B,C
解説:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
質問 76
Which two are true about RMAN encryption? (Choose two.)
- A. Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.
- B. RMAN can encrypt the Oracle Database password file.
- C. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
- D. RMAN encryption keys are stored in a database keystore.
- E. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
正解: C,E
解説:
Explanation/Reference: https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
質問 77
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. Enable asynchronous disk I/O.
- B. Increase the level of RMAN multiplexing.
- C. Increase the size of the database buffer cache.
- D. Disable FORCE LOGGING for the database.
- E. Increase the size of tape I/O buffers.
正解: B,C
質問 78
......
1Z1-083試験問題集でベスト1Z1-083試験問題を試そう：https://jp.fast2test.com/1Z1-083-premium-file.html