[完全版]2023年最新のFast2test 1Z1-083のPDFで最近更新された問題です
1Z1-083試験には保証が付きます。更新されたのは285問があります
質問 # 120
Which two are true about memory advisors? (Choose two.)
- A. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components.
- B. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available.
- C. All memory advisors use data from Automatic Workload Repository.
- D. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available.
- E. If Automatic Memory Management is enabled, no memory advisors are available.
正解：D、E
質問 # 121
Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
- A. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
- B. The BACKUP DATABASE command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
- C. The BACKUP PLUGGABLE DATABASE command can be used to back up CDB$ROOT.
- D. The BACKUP DATABASE PLUS ARCHIVE LOG command will back up archive logs when RMAN is connected to a PDB.
- E. SPFILE backups can be created while connected to an application root PDB.
正解：B、C
質問 # 122
You are managing this configuration:
1. CDB1 is a container database.
2. BDB1 and PDB2 are two pluggable databases in CDB1.
3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.
Which two are true?
- A. The inserts on USER1 . EMP were committed when the session connected to pdb2.
- B. The insert on user2.dept fails because of the active transaction in the parent container.
- C. The inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.
- D. The inserts on USER1.EMP were rolled back when the session connected to pdb2.
- E. The inserts on USER1. EMP were committed when the session inserted a row into user2 .dept.
- F. The insert on user2.dept is uncommitted.
- G. The insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.
正解：F、G
質問 # 123
Choose two. You plan to perform cross-platform PDB transport using XTTS. Which two are true?
- A. The source and target platforms must have the same endianess.
- B. The source PDB must not be an application root.
- C. The source PDB must be in MOUNT state.
- D. A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
- E. Automatic conversion of endianess occurs.
- F. The source PDB can be in MOUNT or OPEN state.
正解：A、F
質問 # 124
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK drop 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 undo to retrieve all versions of a row that existed between two points in time.
- D. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
- E. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- F. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
正解：A、B、E
質問 # 125
Examine this configuration:
CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
PDB$SEED is open READ ONLY
PDB1 is open READ WRITE
PDB2 is MOUNTED.
ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:
For which databases will fixup scripts be created?
- A. CDB1, PDB$SEED, PDB1, and PDB2
- B. PDB$SEED, PDB1, and PDB2 only
- C. CDB1, PDB$SEED, and PDB1 only
- D. CDB1, PDB1, and PDB2 only
- E. CDB1 and PDB$SEED only
正解：C
質問 # 126
Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?
- A. Run the Memory Advisor for the Program Global Area.
- B. Run the SQL Tunning Advisor.
- C. Run the Memory Advisor for the System Global Area.
- D. Run the Memory Advisor for the shared pool.
- E. Run the SQL Access Advisor.
正解：D
質問 # 127
Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases?
- A. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems
- B. A PDB snapshot depends on a storage snapshot which can be stored on any file system
- C. A PDB snapshot is always a sparse copy of the source PDB
- D. A snapshot copy PDB can be created from a stand-alone clone PDB
- E. A PDB snapshot is always a full copy of the source PDB
- F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system
- G. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems
正解：C、G
質問 # 128
Which three are true about monitoring waits for sessions and services? (Choose three.)
- A. V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
- B. V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- C. V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
- D. V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
- E. V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
- F. V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
正解：A、C、E
質問 # 129
Choose two. Which two are true about RMAN backups when using a media manager?
- A. By default, a request for a proxy copy may result in a backup set being created.
- B. A media manager always writes RMAN requested backups to tape.
- C. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
- D. A media manager is required to create RMAN proxy copies.
- E. A media manager is required to create RMAN image copies.
正解：B、C
質問 # 130
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 applications.
- B. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
- C. It can be used to provision middleware.
- D. It is an Oracle Database service
- E. It cannot be used to upgrade Oracle Database homes.
正解：A、C
質問 # 131
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. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- C. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- D. The RMAN SHOW ALL command displays only settings with nondefault values.
- E. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
- G. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
正解：A、B、F
解説：
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
質問 # 132
Choose three. Which three are true about cloning databases into an existing CDB with RMAN?
- A. A non-CDB can be cloned into a PDB.
- B. Two or more PDBs can be cloned with the same command.
- C. A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
- D. Only one PDB can be cloned at a time.
- E. A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
- F. The target and auxiliary instance passwords must be the same.
正解：C、D、E
質問 # 133
Which three are true about Optimizer Statistics Advisor? (Choose three.)
- A. It is part of the DBMS_ADVISOR package.
- B. It can be run only manually.
- C. It can recommend changes to improve the statistics gathering process.
- D. It is part of the DBMS_STATS package.
- E. It runs automatically every night by default.
- F. It always analyzes all schemas in the database.
正解：C、D、E
解説：
Explanation
https://mikedietrichde.com/2017/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf
質問 # 134
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 applications.
- B. It can be used to provision middleware.
- C. It can be used to patch Grid Infrastructure homes containing Oracle Restart.
- D. It is an Oracle Database service
- E. It cannot be used to upgrade Oracle Database homes.
正解：B、C
解説：
Reference:
https://www.oracle.com/assets/rapid-home-provisioning-2405191.pdf
質問 # 135
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 beginning of the CURRENT redo log group.
- C. Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions.
- D. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
- 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 last checkpoint position that was calculated by the Database Writer before instance failure.
正解：E、F
質問 # 136
A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken. A media failure has occurred.
In which two scenarios is incomplete recovery required? (Choose two.)
- A. after losing all copies of the control file
- B. after losing all members of the CURRENT online redo log group
- C. after losing an UNDO tablespace that is in use
- D. after losing all members of an INACTIVE online redo log group
- E. after losing a SYSAUX tablespace data file
正解：A、B
質問 # 137
Which two are true about RMAN encryption? (Choose two.)
- A. The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.
- B. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- C. Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.
- D. RMAN encryption keys are stored in a database keystore.
- E. RMAN can encrypt the Oracle Database password file.
正解：A、B
質問 # 138
Examine this configuration:
1. CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2. PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
What is the outcome?
- A. Only CDB$ROOT, PDB$SEED, and PDB1 are upgraded.
- B. Only CDB$ROOT and PDB$SEED are upgraded.
- C. It fails because PDB$SEED is in MIGRATE state.
- D. CDB$ROOT, PDB$SEED, PDB1, and PDB2 are upgraded.
- E. Only CDB$ROOT, PDB$SEED, and PDB2 are upgraded.
- F. It fails because PDB2 is not in UPGRADE state.
正解：B
質問 # 139
Which three are true about the SQL Tuning Advisor? (Choose three.)
- A. It checks each query being analyzed for stale statistics.
- B. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
- C. It can recommend semantic changes to SQL statements.
- D. It considers all SQL statements being analyzed by the advisor task as a group.
- E. It checks each query being analyzed for missing statistics.
- F. It only recommends syntactic changes to SQL statements.
正解：A、B、E
解説：
Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL540
質問 # 140
Choose the best answer. Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application. Examine these steps: 1. Install the SALES_APP application, including the common tables, in the application root. 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. 3. Create an application seed.; 4. Install the SALES_APP application in the application seed. 5. Create the SALES_APP1 and SALES_APP2 application PDBs. 6. Sync root. 7. Sync seed. 8. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application the SALES_APP1 and SALES_APP2 application PDBs with the application the application seed with the application root.
Which are the minimum required steps in the correct sequence?
- A. 1,3,5,6,7
- B. 1,5,6
- C. 3,4,1,6,8
- D. 2,5,6
- E. 1,3,5,7
正解：B
質問 # 141
Examine the command for creating pluggable database PDB2 in container database CDB2.
Select three options, any one of which is required for it to execute successfully. (Choose three.)
- A. Enable only OMF.
- B. Add only the CREATE_FILE_DEST clause to the statement.
- C. Set only the PDB_FILE_NAME_CONVERT parameter.
- D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- E. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
- F. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
正解：A、B、D
質問 # 142
......
最新の1Z1-083合格保証付き試験問題集の認定サンプル問題：https://jp.fast2test.com/1Z1-083-premium-file.html