1Z0-082Preview

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

Which two statements are true about the DUAL table? (Choose two.)

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER.
Examine these SQL statements:
Statement 1:
SELECT MAX(unit_price * quantity) Maximum Order
FROM order_items;
Statement 2:
SELECT MAX(unit_price * quantity) Maximum Order

FROM order_items -
GROUP BY order_id;
Which two statements are true?

Which three statements are true about views in an Oracle database? (Choose three.)

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

Which statement is true about aggregate functions?

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

Which three statements are true about the DESCRIBE command? (Choose three.)

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

Which two statements are true about the rules of precedence for operators? (Choose two.)

In which three situations does a new transaction always start? (Choose three.)

Which two statements are true about UNDO and REDO? (Choose two.)

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

Which two statements are true about the SET VERIFY ON command? (Choose two.)

Examine this command:

Which two statements are true? (Choose two.)

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE
User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:

SQL> CREATE TABLE t1 AS -
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA'
Which are three actions any one of which the DBA could take to resume the session? (Choose three.)