Examine these statements executed in a single Oracle session:

Which three statements are true?

Which statement correctly grants a system privilege?
GRANT CREATE VIEW

Which two statements are true regarding views? (Choose two.)

Examine the data in the CUST_NAME column of the CUSTOMERS table.

You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:

Which two queries give the required output?

Examine these statements which execute successfully:
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24 MI: SS'
ALTER SESSION SET TIME_ ZONE = '-5:00';
SELECT DBTIMEZONE, SYSDATE FROM DUAL
Examine the result:

If LOCALTIMESTAMP was selected at the same time what would it return?