Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

• A.Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
• B.Source Routing requires the use of a name server
• C.Connect Time Failover requires the use of Transparent Application Failover (TAF)
• D.Connect Time Failover requires the connect string to have two or more listener addresses configured
• E.Load Balancing requires the use of a name server
• F.Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration

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

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It displays values for variables prefixed with &&
• B.It can be used in SQL Developer and SQL*Plus
• C.It displays values for variables used only in the WHERE clause of a query
• D.It displays values for variables created by the DEFINE command
• E.It can be used only in SQL*Plus

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.You can no longer monitor it
• B.You can reattach to it and monitor it
• C.It is paused and can be resumed
• D.It continues to run in the background
• E.It terminates

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about Enterprise Manager Database Express? (Choose two.)

• A.It can be used to switch a database into ARCHIVELOGMODE
• B.The same port number can be used for Database Express configurations for databases on different hosts
• C.It can be used to perform database recovery
• D.The same port number can be used for multiple Database Express configurations for multiple databases on the same host
• E.It is available only when the database is open

Comment: *

Name: *

Email: *

Verification: *