Which Oracle Database component is audited by default if the unified Auditing option is enabled?

• A.Oracle Recovery Manager (RMAN)
• B.Oracle Database Vault
• C.Oracle Label Security
• D.Oracle Real Application Security
• E.Oracle Data Pump

Comment: *

Name: *

Email: *

Verification: *

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

• A.The database is created as a non-CDB and can never contain a PDB.
• B.The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
• C.The database is created as a non-CDB and can never be plugged into a CDB.
• D.The database is created as a non-CDB but can be plugged into an existing CDB.
• E.The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Correct Answer: A,D

Explanation/Reference:
Explanation:
A (not B,not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
D: You can create a PDB by plugging in a Non-CDB as a PDB.
The following graphic depicts the options for creating a PDB:

Incorrect:
Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Flashback Database?

• A.Flashback logs are written sequentially, and are archived.
• B.Flashback Database uses a restored control file to recover a database.
• C.The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D.Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E.Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F.Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by
using SQL Developer.
Which statement is true?

• A.The CDB must be open.
• B.The CDB must be in the mount stage.
• C.The CDB must be in the nomount stage.
• D.Alt existing PDBs must be closed.

Comment: *

Name: *

Email: *

Verification: *

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)

• A.Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
• B.Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• C.Data is never redacted for the EMP_V.SAL column.
• D.Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• E.Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

Comment: *

Name: *

Email: *

Verification: *