Oracle OCP 19c 认证1Z0-083考试(115-120题) #7月最新

 
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.) A. It recompiles all stored PL/SQL code by using utlrp.sql.

B.    It empties the RECYCLE BIN.

C.    It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

D.    It sets all user tablespaces to “read-only” before starting the upgrade.

E.    It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

F.    It increases tablespace size, if required, to meet upgrade requirements.

Answer: ABC

(解析:这道题考的很细,居然考升级中的某个具体细节。Prerequisities
There are a lot of potential prerequisites, which will vary depending on the functionality you are
using in your source version. Please check them in the documentation, or you may fail to upgrade your database successfully.

In addition to other prerequisites, you will always be asked to do the following actions 
Gather dictionary statistics. For a non-CDB database you will do the following from an SQL prompt. CONN / AS SYSDBA
EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;

For a container database you will use the following command to perform the action in all containers.

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -l /tmp -b gather_dict_stats    x"EXEC DBMS_STATS.gather_dictionary_stats"
Purge the recycle bin using the following from an SQL prompt. CONN / AS SYSDBA PURGE DBA_RECYCLEBIN
Compile all invalid objects. For a non-CDB database you will do the following from an SQL prompt. CONN / AS SYSDBA @?/rdbms/admin/utlrp.sql
For a container database you will use the following command to perform the action in all containers.

$ORACLE_HOME/perl/bin/perl    $ORACLE_HOME/rdbms/admin/catcon.pl    -l    /tmp    -b comp_invalid_objs    x"@?/rdbms/admin/utlrp.sql"
 
Reference: https://oracle-base.com/articles/12c/upgrading-to-12c 
78、

Which two are true about RMAN backups when usi