Oracle 1Z0-083 Quiz 9 Topic 5 Questions 41-45

Question: 1

Which three are true about SGA memory management in a multitenant database? (Choose three.)

ASetting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for
that PDB.

BThe SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the
root container.

CSetting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that
PDB.

DThe SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

ESetting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

FSGA_MIN_SIZE cannot be set for a PDB.

Show Answer

Question: 2

Which three actions will add a resource to an Oracle Restart configuration? (Choose three.)

Acreating an Oracle Database service by modifying the SERVICE_NAMES parameter

Bcreating a disk group using the CREATE DISKGROUP SQL statement

Ccreating a database using the CREATE DATABASE SQL statement

Dcreating a database service using DBMS_SERVICE.CREATE_SERVICE

Ecreating a database service using Oracle Database Configuration Assistant (DBCA)

Fcreating an Oracle Automatic Storage Management (ASM) instance with ASM Configuration Assistant
(ASMCA)

Show Answer

Question: 3

Which three are true about creating container databases (CDBs) and pluggable databases (PDBs) in Oracle

19c and later releases? (Choose three.)

AA PDB snapshot can be a sparse copy of a source PDB.

BA PDB snapshot depends on an existing storage snapshot of the source PDB.

CA CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting
the duplication.

DA CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no
configuration required before starting the duplication.

EA PDB snapshot can be a full copy of a source PDB.

FA snapshot copy PDB can be a full copy of a source PDB.

GA snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

Show Answer

Question: 4

Which two are true about Oracle Grid Infrastructure for a Standalone Server? (Choose two.)

AIt supports volume management, file system, and automatic restart capabilities.

BIt must be installed before the Oracle database software is installed.

CThe CSS daemon runs from the Grid Infrastructure home.

DIt can manage database resources on the server where it is installed or on a different server.

EIt requires Oracle Automatic Storage Management (ASM) components to be installed separately.

Show Answer

Question: 5

Which two are true about an RPM-based Oracle Database installation? (Choose two.)

AIt uses a service configuration script to create a single-instance database as part of the installation.

BFrom Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single
instance.

CIt performs a software-only Oracle Database installation.

DIt includes the Oracle Preinstallation RPM.

EIt requires an Unbreakable Linux Network (ULN) subscription.

Show Answer

Oracle 1Z0-083 Quiz:9 Topic:5 Questions:41-45