All 1z0-083 Test Inside Oracle Questions

Page: 7 / 21

Question 28

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

Options:

Decreasing PCTUSED

Decreasing PCTFREE

Increasing the number of DBWN process

Using Automatic Segment Space Management (ASSM)

Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

Question 29

Which four are true about a Recovery Manager (RMAN) duplication without a TARGET connection? (Choose four.)

Options:

The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVE LOG mode.

RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

Question 30

Choose two. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle Universal Installer (OUI). There is no existing Oracle installation on the server. Which two are prerequisites?

Options:

an operating system user to own this installation

the Oracle Inventory group oinstall

an operating system account called grid

a group called dba

the installation of Oracle ASMLIB

Question 31

Choose three. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?