Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

• A.Oracle Managed Files (OMF)
• B.Online table segment shrink
• C.Online index segment shrink
• D.Automatic data file extension (AUTOEXTEND)
• E.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)

• A.Each SELECT statement in the compound query can have its own ORDER BY clause
• B.Each SELECT statement in the compound query must have its own ORDER BY clause
• C.Column positions must be used in the ORDER BY clause
• D.Only column names from the first SELECT statement in the compound query are recognized
• E.The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause

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: *

Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

• A.Directory Naming requires setting the TNS_ADMIN environment variable on the client side.
• B.Local naming can be used if Connect-Time Failover Is required.
• C.Local Naming requires setting the TNS_ADMIN environment variable on the client side.
• D.Easy Connect supports TCP/IP and SSL.
• E.Directory Naming can be used if Connect-Time Failover is required.
• F.A client can connect to an Oracle database instance even If no client side network admin has been configured.

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

• A.UNION
• B.INTERSECT
• C.UNION ALL
• D.SUBTRACT
• E.MINUS

Comment: *

Name: *

Email: *

Verification: *