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

Which three statements are true about single row functions? A. They can be used only in the where clause of a select statement. B. They can accept only one argument. C. They return a single result row ...

Which two statements are true about selecting related rows from two tables based on entity relationship diagram (ERD)? A. Relating data from a table with data from the same table is implemented with a ...

Which three queries use valid expressions? A. SELECT product_id,(unit_price * 0.15 / (4.75 + 552.25)) FROM products; B. SELECT product_id,(expiry_date - delivery_date) * 2 FROM products; C. SELECT pro ...

W hich four statements are true regarding primary and foreign key constraints and the effect they can have on table data? A. Only the primary key can be defined at the column and table level. B. The f ...

Which two queries execute successfully? A. SELECT NULLIF(100, 100) FROM DUAL； B. SELECT COALESCE(100, NULL, 200) FROM DUAL； C. SELECT NULLIF(100, 'A') FROM DUAL； D. SELECT NULLIF(NULL, 100) FROM DU ...