Online Access Free 1Z1-083 Practice Test

Which three are true about managing memory components in an Oracle database instance?
(Choose three.)

• A.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• B.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• C.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
• D.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• E.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• F.Automatic Memory Management must be used together with locking the System Global Area into physical memory.

Which three capabilities require the use of the RMAN recovery catalog? (Choose three.)

• A.using the KEEP FOREVER clause with the BACKUP command
• B.creating encrypted backups
• C.using RMAN stored scripts
• D.using the REPORT SCHEMA command to list a database's data files and tablespaces at times in the past
• E.using the REPORT SCHEMA command to list a database's current data files and tablespaces
• F.creating customized reports about a single database's backups

Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)

• A.The installer will prompt for the root or sudo password.
• B.The response file can specify the root or sudo password.
• C.The response file can specify the path of the sudo program.
• D.Silent install always runs operating scripts automatically.
• E.The response file must contain the root or sudo password.

A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLEDdatabase property is set to FALSEin the CDB.
Data file 24 of PDB2was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASEcommand while connected to CDB$ROOT.
Which three are true? (Choose three.)

• A.Data file 24 can be recovered while connected to CDB$ROOT.
• B.Data file 24 can be restored only while connected to PDB2.
• C.Data file 24 can be restored and recovered while connected to CDB$ROOT.
• D.Data file 24 can be recovered while connected to PDB2.
• E.Data file 24 can be restored only while connected to CDB$ROOT.
• F.Data file 24 can be recovered only while connected to PDB2.

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands:
SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;
SQL> AUDIT POLICY sales_pol;
Which statement is true about SALES_POL?

• A.Audit records are always stored in an external audit file.
• B.It is enabled for all users having SELECT privilege on SH.SALES.
• C.It is only enabled for user SH.
• D.Only successful queries of SH.SALES are written to the audit trail.