Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

• A.The data type group of each column returned by the second query must match the data type of the corresponding column returned by the first query.
• B.The number, but not names, of columns must be identical for all SELECT statements in the query.
• C.The names and number of columns must be identical for all SELECT statements in the query.
• D.The data type of each column returned by the second query must exactly match the data type of the corresponding column returned by the first query.
• E.The data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the configuration and use of UNDO_RETENTION with GURANTEED RETENTION? (Choose two.)

• A.Active UNDO is always retained.
• B.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
• C.UNDO_RETENTION specifies how long all types of UNDO are retained.
• D.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• E.Unexpired UNDO is always retained.

Comment: *

Name: *

Email: *

Verification: *

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)
SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100

• A."DUES" FROM transactions;
  SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100
• B.'DUES AMOUNT' FROM transactions;
• C.transactions;
  SELECT customer_id AS 'CUSTOMER-ID', transaction_date AS DATE, amount + 100
• D.100 "DUES AMOUNT" FROM transactions;
  SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM
• E.DUES FROM transactions;
  SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount +

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user
• B.It can display multiple rows but only a single column
• C.It can display multiple rows and columns
• D.It consists of a single row and single column of VARCHAR2 data type
• E.It can be used to display only constants or pseudo columns
• F.It can be accessed by any user who has the SELECT privilege in any schema

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

• A.MINUS
• B.UNION ALL
• C.UNION
• D.SUBTRACT
• E.INTERSECT

Comment: *

Name: *

Email: *

Verification: *