Online Access Free 1Z1-182 Practice Test

Which two statements are true about the configuration and use of UNDO?

• A.UNDO_RETENTION specifies how long all types of UNDO are retained.
• B.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
• C.Unexpired UNDO is always retained.
• D.Active UNDO is always retained.
• E.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Which three are benefits of using temp UNDO when performing DML on global temporary tables?

• A.It permits DML on global temporary tables even if the database is opened read-only.
• B.It reduces I/Os to the SYSTEM tablespace.
• C.It reduces I/Os to the SYSAUX tablespace.
• D.It reduces the amount of UNDO stored in the UNDO tablespace.
• E.It reduces the amount of redo generated.

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?

• A.Only in the SPFILE
• B.Only in memory
• C.In the SPFILE, PFILE, and memory
• D.In the SPFILE and memory
• E.In the SPFILE and PFILE

Which three actions are ways to apply the principle of least privilege?

• A.Revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the roles/users (assuming typo for duplicate option).
• B.Enabling Unified Auditing.
• C.Using Access Control Lists (ACLs).
• D.Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE.
• E.Setting the REMOTE_OS_AUTHENT parameter to TRUE.

You unplugged a PDB to plug it into another CDB with the following command: SQL> ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?

• A.PDB archive file and only the user-defined tablespaces must be copied to the target CDB.
• B.The PDB archive file must be copied to the target CDB.
• C.The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.
• D.The PDB manifest and all the datafiles must be copied to the target CDB.