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

• A.Column names in each SELECT in the compound query can be different
• B.The number of columns in each SELECT in the compound query can be different
• C.Reversing the order of the intersected tables can sometimes affect the output
• D.INTERSECT returns rows common to both sides of the compound query
• E.INTERSECT ignores NULLs

Comment: *

Name: *

Email: *

Verification: *

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

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

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-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.Set AUTOEXTEND ON for data files in DATA
• B.Set DEFERRED_SEGMENT_CREATION to TRUE
• C.Increase U1's quota sufficiently in DATA
• D.Add a data file to DATA
• E.Drop other U1 objects in DATA
• F.Grant UNLIMITED TABLESPACE to U1

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Deferred Segment Creation in Oracle databases?

• A.It is supported for SYS-owned tables contained in locally managed tablespaces.
• B.Indexes inherit the deferred or immediate segment creation attribute from their parent table
• C.Sessions may dynamically switch back and forth from deferred to immediate segment creation.
• D.It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• E.It Is the default behavior for tables and indexes.

Comment: *

Name: *

Email: *

Verification: *

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

• A.CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B.SYSDATE can be queried only from the DUAL table
• C.CURRENT_DATE returns the current date and time as per the session time zone
• D.SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E.SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F.CURRENT_TIMESTAMP returns the same date as CURRENT_DATE

Comment: *

Name: *

Email: *

Verification: *