Free Access Oracle.1Z0-083.v2022-02-19.q163 Practice Test (Page 21)

Question 96

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A.A snapshot copy PDB can be created from a stand-alone clone PDB.

B.A PDB snapshot is always a full copy of the source PDB.

C.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.

D.A PDB snapshot depends on a storage snapshot which can be stored on any file system.

E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.

F.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.

G.A PDB snapshot is always a sparse copy of the source PDB.

Question 97

Examine this configuration:

To recover from this critical failure, you execute these commands:

What will be the outcome?

A.Option

B.Option

C.Option

D.Option

E.Option

Question 98

Examine this output:

Which two are true? (Choose two.)

A.PDB3 can use all available parallel execution processes at times.

B.PDB1is always limited to 40% of the available system resources regardless of demand.

C.Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

D.Any PDB not specified in the plan will be unable to execute statements in parallel.

E.PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

F.PDB2is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Question 99

Which three are located by using environment variables? (Choose three.)

A.the maximum number of database files that can be opened by a database instance

B.the temporary disk space used by Oracle Installer during installation

C.the location of Oracle Net Services configuration files

D.the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.

E.the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup

F.default directories for temporary files used by temporary tablespaces

Question 100

Examine this output:

Which two are true?

A.Any PDB not specified in the plan will be unable to execute statements in parallel.

B.PDB3 can use all available parallel execution processes at times.