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

Question 31

For which two requirements can you use the user_tablespaces clause with the create pluggable database command?

A.to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB

B.to specify a default tablespace in a PDB cloned from another PDB in the same CDB

C.to specify the list of user tablespaces to include when moving a non-CDB to a PDB

D.to include specific user tablespaces only when relocating a PDB

E.to exclude a temp tablespace when plugging in a PDB

F.to specify the list of tablespaces to include when creating a PDB from the CDB seed

Question 32

Which three are true about upgrading Oracle Grid Infrastructure?

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

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

C.An existing Oracle base can be used.

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

E.Only the grid user can perform the upgrade.

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

Question 33

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

A.Results are written to the alert log.

B.It runs automatically after each AWR snapshot.

C.It analyzes a period of time corresponding to the 12 hours of activity.

D.A DBA can run it manually.

E.It analyzes a period of time corresponding to the last day of activity.

Question 34

Examine this configuration:
* CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
* PDB$SEED is open READ ONLY
* PDB1 is open READ WRITE
* PDB2 is MOUNTED.
* ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release: