Online Access Free 1Z1-083 Exam Questions

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.a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled
• B.a General Purpose database template with default memory allocation
• C.a default database configuration
• D.a Data Warehouse database template, with t he dedicated server mode option and AMM enabled

Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

• A.It can be performed repeatedly until the correct time is found without using an RMAN catalog.
• B.It can be performed using an auxiliary instance managed by RMAN.
• C.RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
• D.It can be used to recover a truncated table.
• E.RMAN always includes tablespaces containing undo segments in the recovery set.
• F.It can be used to recover a dropped tablespace.
• G.It can be performed using an auxiliary instance managed by a DBA.
• H.flashback database must be enabled for it to work.

Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

• A.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file and to standard output.
• B.Media Management messages for SBT devices are always written to sbtio.log.
• C.Media Management messages for SBT devices are written to an Oracle trace file.
• D.RMAN error stacks should be read from the top down as that is the order in which errors are generated.
• E.RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• F.The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.

Which three actions are mandatory post database upgrade?

• A.Setting threshold values for tablespace alerts.
• B.Resetting passwords to enforce case-sensitivity.
• C.Upgrading user tables that depend on Oracle-maintained abstract data types.
• D.Updating client scripts with the new Oracle home.
• E.Migration to unified auditing.
• F.Run OPatch commands from the new Oracle home.

Which two are true about reclaiming space used by Flashback logs in Oracle Database 19c and later releases? (Choose two.)

• A.Space might be reclaimed proactively before space pressure occurs.
• B.Space might be reclaimed automatically when the retention period for Flashback logs is lowered.
• C.Space is only reclaimed when there is space pressure in the Fast Recovery Area. (FRA)
• D.Space is always reclaimed automatically when the retention period for Flashback logs is lowered.
• E.Space is always reclaimed proactively before space pressure occurs.