Which two statements are true about the rules of precedence for operators? (Choose two.)

• A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
• B. Multiple parentheses can be used to override the default precedence of operators in an expression
• C. The + binary operator has the highest precedence in an expression in a SQL statement
• D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
• E. NULLS influence the precedence of operators in an expression

You currently have an active transaction in your session and have been granted select access to vstransaction.

In which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

• A. after successfully executing a commit or rollback followed by a select statement
• B. after successfully executing a create table as select statement followed by a select for update statement
• C. after successfully executing a commit or rollback followed by a DML statement
• D. after successfully executing a truncate statement followed by a DML statement
• E. after successfully executing a create table statement followed by a create index statement
• F. after successfully executing a DML statement following a failed DML statement

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1?
(Choose three.)

• A. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• B. The sales user must have been granted the CREATE SESSION privilege
• C. The sales user must have been granted the CREATE TABLE privilege
• D. The sales user must have a quota on the TEMP tablespace
• E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• F. The sales user must have their quota on the users tablespace removed

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

• A. The names and number of columns must be identical for all SELECT statements in the query.
• B. 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.
• C. The number, but not names, of columns must be identical for all SELECT statements in the query.
• D. 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.
• 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.