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.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

• A.It requires the use of fast recovery area (FRA).
• B.The control file is backed up automatically each time the SPFILE is backed up manually.
• C.The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.
• D.The control file is backed up whenever a new table is created.
• E.The control file is backed up whenever a new tablespace is created.
• F.The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

• A.The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
• B.Oracle DBCA templates can store only logical structure and not database files.
• C.New templates can only be created by modifying an existing user-created template.
• D.The Data Warehouse template is most suitable when transaction response time is the key criterion.
• E.Oracle DBCA templates can be used to create new databases and duplicate existing databases.

Comment: *

Name: *

Email: *

Verification: *

A database is configured in archivelog mode.
A full RMAN backup exists but no control file backup to trace has been taken.
A media failure has occurred.
In which two scenarios is incomplete recovery required?

• A.after losing a sysaux tablespace data file
• B.after losing an undo tablespace that is in use
• C.after losing all members of an inactive online redo log group
• D.after losing all members of the current online redo log group
• E.after losing all copies of the control file

Comment: *

Name: *

Email: *

Verification: *

Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1:
CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES=(CONNECT)
CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1';
Which three are true about PDB1? (Choose three.)

• A.It has the same number of roles as CDB1.
• B.It is in mount state after creation.
• C.It has only local roles.
• D.It has the same common users defined as does CDB1.
• E.It has no local users.
• F.Service PDB1 is created for remote logins to PDB1.

Comment: *

Name: *

Email: *

Verification: *