Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

• A.The root password cannot be specified in a response file.
• B.The sudo password must be specified in a response file.
• C.root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.
• D.orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.
• E.root.sh can be executed automatically by the Database installer only by using sudo credentials.
• F.The sudo password can be specified in a response file.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Database Point-in-Time Recovery? (Choose three.)

• A.The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
• B.The database must be in MOUNT state when performing Database Point-in-Time Recovery.
• C.Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• D.The Database must be in ARCHIVELOG mode.
• E.The target point for the recovery must be specified as a stime or System Change Number (SCN).
• F.The database must be open RESETLOGS after Database Point-in-Time Recovery.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A.It can be run only manually.
• B.It is part of the DBMS_ADVISORpackage.
• C.It can recommend changes to improve the statistics gathering process.
• D.It always analyzes all schemas in the database.
• E.It runs automatically every night by default.
• F.It is part of the DBMS_STATSpackage.

Comment: *

Name: *

Email: *

Verification: *

Choose two. Some archived log backups have been accidentally deleted from storage. Which two commands should be used to update the status of backups in the recovery catalog to display only the missing backups?

• A.CROSSCHECK BACKUP OF ARCHIVELOG ALL
• B.LIST ARCHIVELOG ALL
• C.LIST EXPIRED
• D.RESYNC CATALOG
• E.REPORT OBSOLETE
• F.LIST ARCHIVELOG

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. The ORCLdatabase data files are in Automatic Storage Management (Oracle ASM) disk group +DATA.
2. ORCLuses disk group +FRAfor the Fast Recovery Area.
3. LISTENER is the listener for ORCL.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:

What is the outcome?

• A.The ORCL database, the Oracle ASM instances, the +DATAand +FRAdisk groups, and the LISTENER are started.
• B.Only the ORCLdatabase and the ASM instances are started.
• C.Only the ORCL database instance is started.
• D.Only the ORCLdatabase instance, the Oracle ASM instance, and the +DATAand +FRAdisk groups are started.
• E.Only the ORCLdatabase instance and the +DATAand +FRAdisk groups are started.

Comment: *

Name: *

Email: *

Verification: *