You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)

• A.It must be bigger than the largest SMALLFILE tablespace
• B.Additional data files may not be added
• C.It will always have a 32K blocksize
• D.AUTOEXTEND is possible for the datafile
• E.It will be a dictionary-managed tablespace by default

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• B.It must be the value of the SERVICE_NAMES parameter on the client side
• C.It must be the name of the database to whose instance HR wishes to connect
• D.It must resolve to a valid connect descriptor in the client's tnsnames.ora file
• E.It must be the name of the server running the database to whose instance HR wishes to connect

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 but does not give the required result
• B.It gives an error because the ALL keyword is not valid
• C.It gives an error because the GROUP BY clause is not valid
• D.It executes successfully and gives the required result

Comment: *

Name: *

Email: *

Verification: *

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

• A.The listener is not listening on the default port 1521
• B.The service DB01.abc.com is statically registered
• C.The service DB01.abc.com is dynamically registered
• D.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• E.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

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.Connect Time Failover requires the connect string to have two or more listener addresses configured
• 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.Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall

Comment: *

Name: *

Email: *

Verification: *