Online 1Z0-497 Practice Test

Question 1

What must you do to an application for it to take advantage of partitioning?

Options :

A : recompile it

B : rewrite its SQL queries

C : relink

D : rework the applications schema

E : nothing; it is transparent

Answer: E

Question 2

Examine the command:

sqlplus /nolog

In which scenario would this command execute successfully?

Options :

A : only from the server, if the database instance is not up

B : from either a client or server, even if the database instance is not up

C :

from either a client or server, only if the database instance is up, and the command connects the session to the instance

D :

from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Answer: B

Question 3

You execute some DMLcommands, followed by a COMMITStatement Which option correctly describes how the logwriter (LGWR) process takes part in the transaction commit?

Options :

A : 1. LGWR writes the commit record to disk.

2. LGWR writes all redo entries from Redo Log Buffer to disk.

B : 1. GWR writes only the transaction's redo entries from Redo Log Buffer to disk.

2. LGWR writes the commit record to disk.

C : 1. LGWR puts the commit record to Redo Log Buffer.

2. IGWR writes all redo entries from Redo Log Buffer to disk.

D : 1. LGWR puts the commit record to Redo Log Buffer.

2. If the activity is high, LGWR waits three seconds for other transactions to commit.

3. LGWR writes all redo log entries from Redo Log Buffer to disk.

E : 1. LGWR puts the commit record to Redo Log Buffer.

2. LGWR signals the database writer (DBW) process to write dirty blocks to disk.

3. LGWR writes all redo entries from Redo Log Buffer to disk.

Answer: B

Question 4

Which option represents a function of Global Data Services (GDS)?

Options :

A : performs data replication

B : performs database failovers

C : replaces the functionality of Oracle Clusterware and Oracle RAC

D : coordinates site failovers

E : works seamlessly with Oracle Site Guard

Answer: A,B

Question 5

Which statement is true regarding this connect string?

(DESCRIPTION

(FAILOVER=on)

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=sales-east1) (port=1522) )

(ADDRESS=(host=sales-east2)(port=1522))

(ADDRESS=(host=sales-east3) (port=1522) ))

(ADDRESS_LIST=

(LOAD_BALANCE=ON)

(ADDRESS=(host=sales-west1) (port=1522) )

(ADDRESS=(host=sales-west2) (port=JS22))

(ADDRESS=(host=sales-west3) (port=lS22) ) )

(CONNECT_DATA=

(SERVICE_NAME=sales)

(REGION=east)))

Options :

A : It contains three global service managers in the client's local region (east).

B :

Client-side load balancing has been enabled only for the global service managers within the client's buddy (west).

C : Connect-time failover between regions has not been enabled.

D : The REGION parameter is optional.

Answer: D

EXPERTY DESIGNED 1Z0-497 PRACTICE TEST