Which three are true about the Oracle Optimizer? (Choose three.)

• A.It can re-optimize execution plans after previous executions detect suboptimal plans.
• B.It determines the optimal table join order and method.
• C.It can optimize only SELECT statements.
• D.It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• E.It updates stale object statistics in the Data Dictionary.
• F.It will only generate SQL Plan Directives specific to a given SQL statement.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• A.The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• B.The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• C.It supports diagnostics for Automatic Storage Management (ASM)
• D.It supports diagnostics for Oracle Clusterware
• E.It is held inside an Oracle database schema

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.Add a data file to DATA
• D.Grant UNLIMITED TABLESPACE to U1
• E.Drop other U1 objects in DATA
• F.Increase U1's quota sufficiently in DATA

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning logical and physical database structures? (Choose three.)

• A.All tablespaces may have one or more data files
• B.The extents of a segment must always reside in the same datafile
• C.A segment can span multiple data files in some tablespaces
• D.Segments can span multiple tablespaces
• E.A segment might have only one extent
• F.A segment's blocks can be of different sizes
• G.A smallfile tablespace might be bigger than a bigfile tablespace

Comment: *

Name: *

Email: *

Verification: *

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

• A.They can be used only in the WHERE clause of a SELECT statement
• B.The argument can be a column name, variable, literal or an expression
• C.The data type returned can be different from the data type of the argument
• D.They can be nested to any level
• E.They can accept only one argument
• F.They return a single result row per table

Comment: *

Name: *

Email: *

Verification: *