Oracle 1Z0-083 Quiz 23 Topic 5 Questions 111-115

Question: 1

Which two are true about RMAN duplexed backup sets?

AA non-duplexed backup set written to disk can be duplexed to tape by backing up the backup set that is already on disk.

BA duplexed backup set always uses twice as many SBT channels as a non-duplexed backup set for the same number of files.

CA non-duplexed backup set written to disk can be duplexed to disk by backing up the backup set that is already on disk.

DA non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

EA non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

FA duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

Show Answer

Question: 2

Which two are true about Oracle Flashback features?

Aflashback table can undrop a column.

Bflashback drop can undrop an index when undropping a table.

CAfter a database is restored from flashback logs using the flashback database command, it is sometimes rolled forward using redo logs.

Dflashback version query can retrieve redo records from online and archived redo log files.

Eflashback query can retrieve redo records from online and archived redo log files.

Show Answer

Question: 3

Which three are true about managing memory components in an Oracle database instance?

AWith Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

BAutomatic Memory Management must be used together with locking the System Global Area into physical memory.

COn Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

DWith Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

EWith Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

FAutomatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

Show Answer

Question: 4

Which three actions are performed by Database Upgrade Assistant (DBUA)?

AIt removes the audsys schema and the audit_admin and audit_viewer roles.

BIt sets all user tablespaces to 'read-only' before starting the upgrade.

CIt recompiles all stored pl/sql code by using utlrp.sql.

DIt Increases tablespace size, if required, to meet upgrade requirements.

EIt empties the recycle bin.

FIt performs prerequisite checks to verify if the Oracle database is ready for upgrade.

Show Answer

Question: 5

Which three are true about performing an Oracle Database install on Linux?

AThe runfixup.sh script can install missing RPMs.

BThe Oracle PreinstallationRPMcan be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

CIt can be done before installing Grid Infrastructure for a Standalone Server.

DThe Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

EIt can be done after installing Grid Infrastructure for a Standalone Server.

FThe Oracle database administrator must be granted access to the root operating system account to run root privileged scripts.

GIt allows you to select the languages supported by the Oracle database server.

Show Answer

Oracle 1Z0-083 Quiz:23 Topic:5 Questions:111-115