Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A.Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B.All DDL commands are logged in the alert log file.
• C.All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D.Only DDL commands that resulted in the creation of new segments are logged.
• E.All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

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

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:

Description of cncpt358.png follows
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: *

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)

• A.The valid time columns employee_time_start and employee_time_end are automatically created.
• B.The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C.The valid time columns are not populated by the Oracle Server automatically.
• D.The valid time columns are visible by default when the table is described.
• E.Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Comment: *

Name: *

Email: *

Verification: *

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

• A.Tracking the most recent read time for a table segment in a user tablespace
• B.Tracking the most recent write time for a table segment in a user tablespace
• C.Tracking insert time by row for table rows
• D.Tracking the most recent write time for a table block
• E.Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F.Tracking the most recent write time for a table segment in the SYSAUX tablespace

Comment: *

Name: *

Email: *

Verification: *

You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

• A.Enable supplemental logging for the database.
• B.Specify undo retention guarantee for the database.
• C.Create a Flashback Data Archive in the tablespace where the tables are stored.
• D.Create a Flashback Data Archive in any suitable tablespace.
• E.Enable Flashback Data Archiving for the tables that require tracking.

Comment: *

Name: *

Email: *

Verification: *