You execute the following PL/SQL:

Which two statements are true? (Choose two.)

• A.Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.
• B.FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.
• C.FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.
• D.FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

• A.OMF cannot be used in a database that already has data files created with user-specified directions.
• B.The file system directions that are specified by OMF parameters are created automatically.
• C.OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• D.OMF automatically creates unique file names for table spaces and control files.
• E.OMF may affect the location of the redo log files and archived log files.

Comment: *

Name: *

Email: *

Verification: *

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A.Assign the appropriate operatingsystem groups to SYSBACKUP, SYSDG, SYSKM.
• B.Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C.Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the
  FORCE argument set to No.
• D.Re-create the password file withSYSBACKUP, SYSDG, and SYSKM privilege, and
  FORCE arguments set to Yes.
• E.Re-create the password file in the Oracle Database 12c format.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using flashback database in a multitenant container database (CDB)?
(Choose three.) (Choose three.)

• A.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
• B.To enable flashback database, the CDB must be mounted.
• C.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• D.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
• E.Individual PDBs can be flashed back without flashing back the entire CDB.

Comment: *

Name: *

Email: *

Verification: *

Your database is configured in ARCHIVELOGmode, and a daily full database backup is taken by using
RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)

• A.active online redo log file group
• B.a data file belonging to the default temporary tablespace
• C.all the control flies
• D.inactive online redo log file group
• E.server parameter file (SPFILE)
• F.a data file belonging to the SYSAUXtablespace

Comment: *

Name: *

Email: *

Verification: *