Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

• A. SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
• B. SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK
• C. SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK
• D. SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• E. SELECT prod_id I I q' ('s not available) ?'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
• F. SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

Which three statements are true about Deferred Segment Creation in Oracle databases?

• A. Indexes inherit the deferred or immediate segment creation attribute from their parent table
• B. Sessions may dynamically switch back and forth from deferred to immediate segment creation.
• C. It is supported for SYS-owned tables contained in locally managed tablespaces.
• D. It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• E. It Is the default behavior for tables and indexes.

Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

• A. control files
• B. dump files
• C. bad files
• D. input files
• E. password files

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A. no segments are created
• B. T1 only
• C. T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• D. T1, an index segment for the primary key, and a LOB segment only
• E. T1 and an index segment created for the primary key only

Examine the description of the employees table:

Which query requires explicit data type conversion?

• A. SELECT join_date I I ' ' II salary FROM employees;
• B. SELECT join_date + '20' FROM employees; SELECT salary * '120.50' FROM employees;
• C. SELECT SUBSTR<join_date, 1, 2) - 10 FROM employees;
• D. SELECT join_date FROM employees WHERE join_date > '10-02-2018';