Which two tasks can be performed in the NOMOUNT state? (Choose two.)

• A.re-creating control files
• B.full database recovery
• C.enabling online redo log archiving
• D.creating a database
• E.renaming data files

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the EMPLOYEES table:

Which query is valid?

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

Comment: *

Name: *

Email: *

Verification: *

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.Set AUTOEXTEND ON for data files in DATA
• D.Set DEFERRED_SEGMENT_CREATION to TRUE
• E.Drop other U1 objects in DATA
• F.Grant UNLIMITED TABLESPACE to U1

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about segment types in an Oracle Database?

• A.Table segments always have two or more extents.
• B.Temporary segments are only stored in a temporary tablespace.
• C.Undo segments are only stored in an undo tablespace.
• D.Index segments always have two or more extents.
• E.Cluster segments may contain data from multiple tables.

Comment: *

Name: *

Email: *

Verification: *

Evaluate these commands which execute successfully:

Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence?
(Choose two.)

• A.Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ
• B.If sequence ORD_SEQ is dropped then the default value for column ORD_NO will be NULL for rows inserted into ORD_ITEMS
• C.Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 times
• D.Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row is inserted into ORD_ITEMS and no explicit value is given for ORD_NO
• E.Sequence ORD_SEQ is guaranteed not to generate duplicate numbers

Comment: *

Name: *

Email: *

Verification: *