Which three are true about privileges and roles? A. A role is owned by the user who created it. B. System privileges always set privileges for an entire database. C. All roles are owned by the SYS sch ...

Which three are true about multiple INSERT statements? A. They can be performed only by using a subquery. B. They can be performed on relational tables. C. They can be performed on views. D. They can ...

Which two statements are true regarding the UNION ALL operators? A. NULLS are not ignored during duplicate checking. B. Duplicates are eliminated automatically by the UNION ALL operator C. The names o ...

What is true about non-equijoin statement performance? A. The between condition always performs less well than using the >= and = and

Examine the description of the transactions table: Name NULL? TYPE TRANSACTION_ID NOT NULL V ARCHAR2(6) TRANS ...

Which three statements are true about Data Manipulation Language (DML)? A. delete statements can remove multiple rows based on multiple conditions. B. insert statements can insert nulls explicitly int ...

Which two statements are true about the order by clause when used with a sql statement containing a set operator such as union? A. column positions must be used in the order by clause. B. The first co ...

Which two statements are true about the results of using the intersect operator in compound queries? A. intersect ignores nulls. B. Reversing the order of the intersected tables can sometimes affect t ...