Oracle 1Z0-083 Quiz 25 Topic 1 Questions 121-125

Question: 1

Which three are true about Automatic Workload Repository (AWR)?

AAWR data is stored in the system tablespace.

BThe taking of AWR snapshots can be disabled.

CBy default, AWR snapshots are taken every 60 minutes.

DBy default, AWR snapshots are retained for 7 days.

EIts collection level is determined by the value of the statistics_level database parameter.

Show Answer

Question: 2

Which three are true about backup, restore, and recovery operations done without using Recovery Manager (RMAN)?

AOracle archive log backups, copied using an O/S utility, can be added to the RMAN catalog as a backup set.

BBacking up a database in archivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.

CBacking up a database in noarchivelog mode using O/S utilities requires that the database instance be started and the database be in mount state.

DOracle data file backups, copied using an O/S utility, can be added to the RMAN catalog as image copies.

EBacking up a database in noarchivelog mode using O/S utilities requires that the database instance be shut down.

FBacking up a database in archivelog mode using O/S utilities requires that the database instance be started and the database be in open state.

GAn Oracle database can be restored from backup files copied using O/S utilities.

Show Answer

Question: 3

Which three methods can be used for heap table data migration after upgrading a database?

Ausing operating system file copy utilities

Busing SQL Developer

Cusing Oracle Data Pump

Dusing Database Replay

Eusing Database Upgrade Assistant

Fusing the create table AS select SQL statement

Show Answer

Question: 4

Which three are true about upgrading Oracle Grid Infrastructure?

AExisting Oracle Database instances must be shut down before starting the upgrade.

BA direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.

COnly the grid user can perform the upgrade.

DThe upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.

EAn existing Oracle base can be used.

FThe newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.

Show Answer

Question: 5

Which two are true about the Optimizer Statistics Advisor?

AIt always analyzes all schemas in the database.

BIt can recommend changes to improve the statistics gathering process.

CIt runs automatically every night by default.

DIt can be run only automatically.

EIt can be run only manually.

Show Answer

Oracle 1Z0-083 Quiz:25 Topic:1 Questions:121-125