Examine this partial command:

Which two clauses are required for this command to execute successfully? (Choose two.)

• A.the LOCATIONclause
• B.the access driver TYPEclause
• C.the DEFAULT DIRECTORYclause
• D.the ACCESS PARAMETERSclause
• E.the REJECT LIMITclause

Comment: *

Name: *

Email: *

Verification: *

View the exhibit and examine the structure of the PROMOTIONS table.

You have to generate a report that displays the promo name and start date for all promos that started after the last promo in the 'INTERNET' category.
Which query would give you the required output?

• A.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date > ALL (SELECT promo_begin_dateFROM promotionsWHERE promo_category = 'INTERNET');
• B.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date IN (SELECT promo_begin_dateFROM promotionsWHERE promo_category= 'INTERNET');
• C.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date> ANY (SELECT promo_begin_dateFROM promotionsWHERE promo_category= 'INTERNET');
• D.SELECT promo_name, promo_begin_date FROM promotionsWHERE promo_begin_date> ALL (SELECT MAX (promo_begin_date)FROM promotions) ANDpromo_category= 'INTERNET';

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding external tables?

• A.ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.
• B.The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table.
• C.The default REJECT LIMIT for external tables is UNLIMITED.
• D.The data and metadata for an external table are stored outside the database.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true regarding the INTERSECT operator?

• A.The number of columns and data types must be identical for all SELECT statements in the query.
  INTERSECT Returns only the rows that occur in both queries' result sets, sorting them and removing duplicates.
  The columns in the queries that make up a compound query can have different names, but the output result set will use the names of the columns in the first query.
• B.Reversing the order of the intersected tables alters the result.
• C.The names of columns in all SELECT statements must be identical.
• D.It ignores NULLs.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true regarding subqueries? (Choose three.)

• A.Multiple columns or expressions can be compared between the main query and subquery.
• B.Subqueries can contain ORDER BY but not the GROUP BY clause.
• C.Main query and subquery can get data from different tables.
• D.Subqueries can contain GROUP BY and ORDER BY clauses.
• E.Main query and subquery must get data from the same tables.
• F.Only one column or expression can be compared between the main query and subquery.

Comment: *

Name: *

Email: *

Verification: *