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 ...

Which three statements are true about a self join? A. It must be an inner join. B. It must be an equijoin. C. The query must use two different aliases for the table. D. The on clause can be used. E. ...

Which two are true about granting privilege on objects? A. The owner of an object acquires all object privilege on that object by default. B. The WITH GRANT OPTION clause can be used only by DBA users ...

Which two statements are true about Oracle synonyms? A. A synonym can have a synonym. B. A synonym has an object number. C. Any user can create a public synonym. D. All private synonym names must be u ...