Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)?

• A.There must be an equal number of columns in each SELECT list.
• B.The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.
• C.The FOR UPDATE clause cannot be specified.
• D.Each SELECT statement in the query can have an ORDER BY clause.
• E.None of the set operators can be used when selecting CLOB columns.

Comment: *

Name: *

Email: *

Verification: *

Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

• A.Remove the single quotation marks enclosing the character literal string in the SELECT clause
• B.Use the escape character to negate the single quotation mark within the literal character string in the SELECT clause
• C.Enclose the character literal string in the SELECT clause within double quotation marks
• D.Use the Oracle (q) operator and delimiter to allow the use of a single quotation mark within the literal character string in the SELECT clause

Comment: *

Name: *

Email: *

Verification: *

The first DROP operation is performed on PRODUCTS table using this command:
DROP TABLE products PURGE;
Then a FLASHBACK operation is performed using this command:
FLASHBACK TABLE products TO BEFORE DROP;
Which is true about the result of the FLASHBACK command?

• A.It recovers only the table structure.
• B.It recovers the table structure, data, and the indexes.
• C.It recovers the table structure and data but not the related indexes.
• D.It is not possible to recover the table structure, data, or the related indexes.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the ORDERS table:
Which three statements execute successfully?

• A.SELECT ORDER_ID INVOICE_ID ORDER-DATE FROM ORDERS
  MINUS
  SELECT INVOICE_ID INVOICE_DATA FROM INVOICE ORDER BY INVOICE_ID;
• B.SELECT * FROM ORDERS ORDER BY ORDER_ID
  UNION
  SELECT * FROM INVOICES;
• C.SELECT ORDER_ID ORDER_DATE FROM ORDERS
  UION ALL
  SELECT INVOICE_ID, INVOICE_DATE FROM INVOICE ORDER BY ORDER_ID;
• D.SELECT * FROM ORDERS ORDER BY ORDER_ID
  INTERSECT
  SELECT * FROM INVOICE ORDER BY INVOICE_ID;
• E.(SELECT * FROM ORDERS

Comment: *

Name: *

Email: *

Verification: *

Which two are true about virtual columns?

• A.They can be referenced in the set clause of an update statement as the name of the column To be updated.
• B.They can be referenced In the where clause of an update or debete statement.
• C.They can be referenced in the column expression of another virtxial column.
• D.They can be indexed.
• E.They cannot have a data type explicitly specified.

Comment: *

Name: *

Email: *

Verification: *