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/3/6 14:45:17
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.)

• A.Increase U1's quota sufficiently in DATA
• B.Add a data file to DATA
• C.Drop other U1 objects in DATA
• D.Set DEFERRED_SEGMENT_CREATION to TRUE
• E.Grant UNLIMITED TABLESPACE to U1
• F.Set AUTOEXTEND ON for data files in DATA

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about single row functions? (Choose two.)

• A.MOD : returns the quotient of a division operation
• B.FLOOR : returns the smallest integer greater than or equal to a specified number
• C.TRUNC : can be used with NUMBER and DATE values
• D.CONCAT : can be used to combine any number of values
• E.CEIL : can be used for positive and negative numbers

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
* Compress rows for all DML statements on that table
* Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR QUERY LOW
• B.ROW STORE COMPRESS BASIC
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.ROW STORE COMPRESS ADVANCED

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SYSTEM_EVENT
• B.V$SESSION_WAIT
• C.V$SESSION
• D.V$SESSION_EVENT
• E.V$SESSION_WAIT_CLASS

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query is valid?

• A.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• B.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id, join_date;
• C.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

Comment: *

Name: *

Email: *

Verification: *