Which two statements are true about the DUAL table? (Choose two.)

• A.It can be accessed only by the SYS user
• B.It consists of a single row and single column of VARCHAR2 data type
• C.It can display multiple rows but only a single column
• D.It can be used to display only constants or pseudo columns
• E.It can be accessed by any user who has the SELECT privilege in any schema
• F.It can display multiple rows and columns

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

• A.Undo segments can extend when a transaction fills the last extent of the undo segment
• B.An undo segment may be used by multiple transactions simultaneously
• C.Undo segments must be stored in a BIGFILE tablespace
• D.A single transaction may use multiple undo segments simultaneously
• E.Undo segments must be stored in a SMALLFILE tablespace
• F.Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
• G.Undo segments have a minimum of three extents

Comment: *

Name: *

Email: *

Verification: *

What is true about non-equijoin statement performance? (Choose two.)

• A.Table aliases can improve performance
• B.The BETWEEN condition always performs better than using the >= and <= conditions
• C.The join syntax used makes no difference to performance
• D.The BETWEEN condition always performs less well than using the >= and <= conditions
• E.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

Comment: *

Name: *

Email: *

Verification: *

View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.
You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.
Examine this SQL statement:

Exhibit 1.

Exhibit 2.

What will be the result?

• A.It executes successfully and gives the required result
• B.It gives an error because the ALL keyword is not valid
• C.It executes successfully but does not give the required result
• D.It gives an error because the GROUP BY clause is not valid

Comment: *

Name: *

Email: *

Verification: *