Oracle Updated 1z0-082 Exam Questions and Answers by dalia

when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session

when issuing a TRUNCATE statement after a SELECT statement was issued in the same session

when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session

when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session

when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session

when issuing a DML statement after a DML statement failed in the same session

when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT

when a CREATE INDEX statement is executed successfully in the same session

when a COMMIT statement is issued by the same user from another session in the same database instance

when the session logs out successfully

when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT

when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

The data dictionary is created and maintained by the database administrator

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Base tables can be queried directly

It is owned by the SYSTEM user

Usernames of all users including database administrators are stored in the data dictionary

WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')

WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'

WHERE order_date > TO_DATE

WHERE order_date IN (TO_DATE ('Oct 21 2018', 'Mon DD YYYY'), TC_CHAR('Nov 21 2018', 'Mon DD YYYY'))

WHERE order date > TO DATE('JUL 10 2018', *MON DD YYYY')