Choose the best answer. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

• A.SQL statements
• B.database instance memory management and sizes
• C.database writer performance
• D.log writer performance
• E.general operating system health

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A.It is always possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• B.It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• C.A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D.It is always possible for RMAN to connect to a pluggable database as a target.
• E.A Virtual Private Catalog used to register a container database can be created in a pluggable database.
• F.A Virtual Private Catalog used to register a container database can be created in a non-container database.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

• A.It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks
• B.It creates one disk group during installation.
• C.It requires the operating system oracle_base environment variable to be predefined before installation.
• D.It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
• E.Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.
• F.It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

• A.By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• B.The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• C.The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• D.The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
• E.The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
• F.The Oracle Grid Infrastructure installation must be owned by the grid user.

Comment: *

Name: *

Email: *

Verification: *

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

• A.The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.
• B.The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.
• C.RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
• D.The NOREDO clause can be used if the backups of the database being duplicated were taken when the database was in ARCHIVELOG mode.
• E.RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
• F.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.
• G.The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.
• H.RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Comment: *

Name: *

Email: *

Verification: *