Which two statements are true about Oracle network connections? (Choose two.)

• A. The listener always spawns a new server process to deal with each new connection.
• B. A server process checks a user's authentication credentials and creates a session if the credentials are valid.
• C. The listener continuously monitors a connection after the user process connects to a service handler.
• D. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.
• E. A listener may listen on behalf of only one database instance at a time.

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. 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.
• 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 visible by default when the table is described.
• D. The valid time columns are not populated by the Oracle Server automatically.
• E. The valid time columns employee_time_start and employee_time_end are automatically created.

Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

• A. No data file needs to be specified
• B. It loads data faster than conventional SQL*Loader
• C. It requires Enterprise Manager Express to be configured
• D. It can load data in parallel
• E. It loads data more efficiently than conventional SQL*Loader

You execute this command:

Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

• A. The PCTFREE storage parameter has no effect on segments created in this tablespace.
• B. The PCTUSED storage parameter has no effect on segments created in this tablespace.
• C. Space utilization inside segments is mapped by bitmaps.
• D. Segments are automatically shrunk and compressed when rows are deleted.

In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?
(Choose three.)

• A. when a resumable statement is suspended
• B. when the total number of locked user account exceeds a specific value
• C. when free space in a dictionary managed tablespace falls below a specified percentage
• D. when the total number of logons exceeds a specific value
• E. when the number of logons per second exceeds a specific value
• F. when free space in a locally managed tablespace falls below a specified percentage