1Z0-083 PDF問題集で2024年07月21日試験問題 有効な1Z0-083問題集
究極の1Z0-083準備ガイドで無料最新のOracle練習テスト問題集
質問 # 56
You are managing this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are two pluggable databases in CDB1.
* USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2.
CDB1 user SYS executes these commands after connecting successfully to PDB2:
Which two are true? (Choose two.)
- A. The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
- B. The inserts on USER1.EMP were rolled back when the session connected to PDB2.
- C. The insert on USER2.DEPT fails because of the active transaction in the parent container.
- D. The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
- E. The insert on USER2.DEPT is uncommitted.
- F. The inserts on USER1.EMP were committed when the session inserted a row into USER2.DEPT.
- G. The inserts on USER1.EMP were committed when the session connected to PDB2.
正解：B、D
質問 # 57
Examine this configuration:
CDB1 is a container database.
PDB1 and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. PDB1 and PDB2 are in MOUNT state.
- B. PDB$SEED is in READ ONLY state.
- C. Redo logs are opened.
- D. PDB1 and PDB2 are in READ ONLY state.
- E. CDB$ROOT is in MOUNT state.
正解：B、C
質問 # 58
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
- A. database instance memory management and sizes
- B. SQL statements
- C. database writer performance
- D. general operating system health
- E. log writer performance
正解：B
解説：
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.
質問 # 59
Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)
- A. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- B. The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
- C. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
- D. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
- E. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
- F. The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
- G. The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
- H. The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
正解：B、C、D、H
解説：
A is correct:
"Therefore, you must use the NOREDO option when the source database was in NOARCHIVELOG mode when the backups were taken." D is correct:
"You can also use the NOREDO option when you do not want to apply archived redo log files to a consistent backup." E is correct:
This method is not supported for backups that are stored on tape devices H is correct:
"Backup-based duplication without a connection to target or a recovery catalog RMAN creates duplicate files from RMAN backups and copies that were placed in a designated BACKUP LOCATION."
質問 # 60
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
- A. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
- B. Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed. - C. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
- D. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
- E. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
正解：A、B
質問 # 61
Which two are true about server-generated alerts? (Choose two.)
- A. Stateless alerts can be purged manually from the alert history.
- B. Stateless alerts can be cleared manually.
- C. Stateful alerts are purged automatically from the alert history.
- D. Stateless alerts are automatically cleared.
- E. Stateful alerts must be created by a DBA after resolving the problem.
正解：B、E
質問 # 62
Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /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, and PDB1 only
- B. PDB$SEED, PDB1, and PDB2only
- C. CDB1, PDB1, and PDB2only
- D. CDB1and PDB$SEEDonly
- E. CDB1, PDB$SEED, PDB1, and PDB2
正解：A
質問 # 63
Examine these RMAN commands:
RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";
RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE
PASSWORD FILE SECTION SIZE 400M;
Which two statements are true about the DUPLICATE command?
- A. Itsucceeds only if the target database is greater than 400M.
- B. It fails because no parallel channels are allocated for the auxiliary database.
- C. It succeeds.
- D. No catalogued backup of the TARGET is used to duplicate the database.
- E. It fails because connection to the AUXILIARY instance must be as SYSDBA.
正解：C、D
質問 # 64
Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. Uncommitted transactions in PDB1have been rolled back.
- B. Uncommitted transactions in CDB1and PDB1have been rolled back.
- C. CDB1is in MOUNT state
- D. PDB1is closed.
- E. CDB1is shut down.
正解：C、D
質問 # 65
Which three are true? (Choose three.)
- A. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- B. Application-common TSDP policies are always container specific.
- C. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
- 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 Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- F. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- G. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
正解：B、G
質問 # 66
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. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
- B. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- C. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
- D. Set only the PDB_FILE_NAME_CONVERT parameter.
- E. Enable only OMF.
- F. Add only the CREATE_FILE_DEST clause to the statement.
正解：D、E、F
質問 # 67
Which two are true about the SQL Tuning Advisor?
- A. It prevents performance regressions for SQL statements when changes are made.
- B. It only recommends syntactic changes to SQL statements.
- 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 or stale statistics.
正解：C、D
質問 # 68
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. Test tuned SQL statements one at a time for all statements in the application.
- C. Tune individual SQL statements using the SQL Tuning Advisor.
- D. Identify poorly tuned SQL statements using the SQL Tuning Advisor.
- E. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
- F. Test the application as a whole using tuned SQL statements.
正解：A、C、F
質問 # 69
Which two are true about RMAN encryption? (Choose two.)
- A. Password encryption can be persistently configured using the CONFIGURE ENCRYPTIONcommand.
- B. RMAN encryption keys are stored in a database keystore.
- C. RMAN can encrypt the Oracle Database password file.
- D. The SET ENCRYPTIONcommand overrides encryption settings specified by the CONFIGURE ENCRYPTIONcommand.
- E. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
正解：D、E
解説：
Explanation/Reference: https://docs.oracle.com/database/121/BRADV/rcmconfa.htm#BRADV89476
質問 # 70
Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)
- A. Tablespaces are automatically created as need while importing full exports in either a non-CDB or a PDB.
- 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. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.
- E. A new PDB is automatically created when importing a non-CDB into a CDB.
- F. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.
正解：C、F
質問 # 71
Which three true about recovering tables using RMAN? (Choose three.)
- A. RMAN can recover tables in the SYSTEM tablespace.
- B. RMAN can recover a table after a DDL operation has altered the table structure.
- C. RMAN can recover tables in the SYSAUX tablespace.
- D. RMAN can recover tables owned by the SYS user.
- E. RMAN can recover tables owed by the SYSTEM user.
- F. RMAN can recover tables in a standby database.
- G. RMAN always uses an auxiliary instance.
正解：B、E、G
解説：
https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/rman-recovering-tables-partitions.html#GUID-526969ED-37C3-44C6-B205-AF1621008DCE
質問 # 72
How do you configure a CDB for local undo mode?
- A. Open the CDB in read-only mode.
In cdb$root, ex cute alter database local undo on, and then change the CDB to read/write mode. - B. Open the CDB instance in upgrade mode.
In cdb$root, execute alter database local undo on, and then restart the CDB instance. - C. Open the CDB instance in upgrade mode.
In each PDB, execute alter database local undo on, create an undo tablespace, and hen restart the CDB instance. - D. Open the CDB instance in restricted mode.
In cdb$root, drop the undo tablespace.
Execute alter database local undo on in each PDB and then restart the CDB instance. - E. Open the CDB instance in restricted mode.
In cdb$root, execute alter database local undo on.
create an undo tablespace in each PDB, and hen restart the CDB instance
正解：B
解説：
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/admin/administering-a-cdb-with-sql-plus.html#GUID-1AAB032F-D13A-4E06-A062-59E0487C2FC5
質問 # 73
Which three are true about Database Point-in-Time Recovery?
- A. The database must be in mount state when performing Database Point-in-Time Recovery.
- B. The database must be in archivelog mode.
- C. The database must be open resetlogs after Database Point-in-Time Recovery.
- D. The database must have flashback database on to perform Database Point-in-Time Recovery.
- E. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- F. The target point for the recovery must be specified as a time or System Change Number (SCN).
正解：A、D、F
質問 # 74
Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?
- A. It is in mount state after creation.
- B. It has the same common users defined as does CDB1.
- C. Service PDB1 is created for remote logins to PDB1.
- D. It has the same number of roles as CDB1.
- E. It has no local users.
- F. It has only local roles.
正解：A、B、C
質問 # 75
......
合格率 取得する秘訣は1Z0-083認定試験エンジンPDF：https://jp.fast2test.com/1Z0-083-premium-file.html
今すぐ試そう！高評価Oracle 1Z0-083試験問題集：https://drive.google.com/open?id=19l-cg96t69eJYN-cfxpRV5I2meYH-Mi1