Question 1

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?

Options :

A : It must be the name of the database to whose instance HR wishes to connect.

B : It must resolve to a valid connect descriptor in the client-s tnsnames.ora file.

C : It must be the name of the server running the database to whose instance HR wishes to connect.

D : It must resolve to a valid connect descriptor in the server-s tnsnames.ora file.

E : It must be the value of the SERVICE_NAMES parameter on the client side.

Answer: B

Question 2

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?

Options :

A : Connect Time Failover requires the use of Transparent Application Failover (TAF).

B : Source Routing requires the use of encrypted connections.

C : Connect Time Failover requires the connect string to have two or more listener addresses configured.

D : Load Balancing requires the use of a name server.

E : Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.

Answer: C,E

Question 3

Which two account management capabilities can be configured using Oracle profiles?

Options :

A : The maximum number of sessions permitted for a user before the password must be changed.

B : The maximum amount of CPU time allowed for a user’s sessions before their account is locked.

C : The number of days for which an account may be logged in to one or more sessions before it is locked.

D : The ability to prevent a password from ever being reused.

E : The number of days for which an account may be inactive before it is locked.

Answer: D,E

Question 4

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

Options :

A : Dependent indexes become UNUSABLE.

B : The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.

C : Only queries are allowed on ORDERS while SHRINK is executing.

D : The high-water mark (HWM) of ORDERS is adjusted.

E : Queries and DML statements are allowed on ORDERS while the SHRINK is executing.

F : The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

Answer: E,F

Question 5

Which two statements are true about the tools used to configure Oracle Net Services?

Options :

A : The lsnrctl utility requires a listener.ora file to exist before it is started.

B : Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

C : The Oracle Net Configuration Assistant is only used when running the Oracle installer.

D : Oracle Net Manager can be used to locally configure naming methods on a database server.

E : Oracle Net Manager can be used to centrally configure listeners on any database server target.

Answer: B,D