Examine the description of the members table:

Examine the partial query:
SELECT city, last__name 1NAME FROM members
You want to display all cities that contain the string an. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

• A.WHERE city = =%AN%'
• B.ORDER BY 1, 2
• C.WHERE city LIKE *%AN%*
• D.ORDER BY last_narae DESC, city ASC
• E.ORDER BY 1, LNAME DESC
• F.WHERE city IN (*%AN%')

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 regarding single row subqueries?

• A.They must be placed on the right side of the comparison operator or condition.
• B.They must return a row to prevent errors in the SQL statement.
• C.They can be used in the where clause.
• D.They must be placed on the left side of the comparison operator or condition.
• E.A SQL statement may have multiple single row subquery blocks.
• F.They can be used in the having clause.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about smallfile tablespaces?

• A.Extent location metadata is stored in the data dictionary by default.
• B.Segments can span multiple data files.
• C.The number of data files is constrained only by the size of the storage array.
• D.Maximum file size can be set to unlimited only if the logical volume manager supports striping.
• E.Segments can span multiple tablespaces.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about a self-join? (Choose three.)

• A.It must be an equi join
• B.It must be an inner join
• C.The query must use two different aliases for the table
• D.The ON clause can be used
• E.The ON clause must be used
• F.It can be an outer join

Comment: *

Name: *

Email: *

Verification: *