Free Oracle Database Administration II Exam 1Z0-083 Exam Practice Test

You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications: Applications will connect to the database via a middle tier. The number of concurrent user connections will be high. The database will have mixed workload, with t he execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

• a General Purpose database template with default memory allocation
• a Data Warehouse database template, with t he dedicated server mode option and AMM enabled
• a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled
• a default database configuration

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

• Enable Memory Access Mode, which reads performance data from SGA.
• Use emergency monitoring to fetch data directly from SGA for analysis.
• Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• Use Active Session History (ASH) data and hang analysis in regular performance monitoring,
• Run ADDM in diagnostic mode.

choose two You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FR

• user-managed backups of data files and control files
• flashback logs
• RMAN backups that are obsolete
• archived redo log files that have multiple copies in a different archive location

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps: Install the SALES_APP application, induding the common tables, in the application root. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root. Create an application seed. Install the SALES_APP application in the application seed. Create the SALES_APP1 and SALES_APP2 application PDBs. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed. Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

• 1,3,5,7
• 2,5,6
• 1,5,6
• 3,4,1.6,8
• 1,3,5,6,7

Which three RMAN persistent settings can be set for a database?

• backup retention policy
• default backup device type
• default section size for backups
• default destinations for backups
• multiple backup device types for a single backup

Which two are true about instance recovery? (Choose two.)

• It is not possible if an archived log is missing.
• It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
• 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.
• It is performed by the Recovery Writer (RVWR) background process.
• Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time by causing The log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
• It is performed automatically while the database remains in MOUNT state. Then the database is opened.

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?

• Run the SQL Access Advisor.
• Run the Memory Advisor for the shared pool.
• Run the SQL Tunning Advisor.
• Run the Memory Advisor for the Program Global Area.
• Run the Memory Advisor for the System Global Area.

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. There are several pluggable databases (PDBs) in CDB1. 5. Each PDB has several tables with referential integrity constraints. 6. FLASHBACK DATABASE is ON. 7. UNDO RETENTION GUARANTEE is enabled. Multiple undesired multitable changes were made in all the PDBs. Which method can be used to undo the changes using a single command?

• restore and recover database
• flashback transaction
• flashback database
• flashback table and transaction
• flashback table

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed: Which three are true? (Choose three.)

• Application PDBsthat are subsequently created in the APP1 application container will be cloned from APP1$SEED.
• An application seed PDB is created for APP1.
• An application root PDB is created for APP1.
• A default service is created for the application root APP1.
• Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
• APP1 can never be unplugged.

Which two are true about creating RMAN backups for an Oracle container database?

• Online Redo Log backups can be created while connected to CDB$ROOT
• Control file backups can be created while connected to CDB$ROOT.
• The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.
• Archived Redo Log backups can be created while connected to PDB
• Control file backups can not be created while connected to a PDB