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

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
(Choose two.)

• A.WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
• B.The WHERE clause can be used to exclude rows after dividing them into groups
• C.Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
• D.The WHERE clause can be used to exclude rows before dividing them into groups
• E.The HAVING clause can be used with aggregating functions in subqueries

Comment: *

Name: *

Email: *

Verification: *

Examine this command:
CREATE UNDO TABLESPACE undotbs01
DATAFILE 'undotbs_01.dbf'
SIZE 100M
AUTOEXTEND ON;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A.Add the SEGMENT SPACE MANAGEMENT AUTO clause
• B.Add the NOLOGGING clause
• C.Add the ONLINE clause
• D.Make certain that the database operates in automatic undo management mode
• E.Set UNDO_TABLESPACE to UNDOTBS01

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, join_date;
• B.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;
• C.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;
• D.SELECT dept_id, MAX(AVG(salary)) FROM employees GROUP BY dept_id;

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Change the standard block size of an existing database
• B.Configure a nonstandard block size for a new database
• C.Configure incremental backups for a new database
• D.Register a new database with an available Enterprise Manager Management server
• E.Enable flashback database for an existing database

Comment: *

Name: *

Email: *

Verification: *