Online 1Z0-497 Practice Test

Question 1

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

Question 2

Which two statements are true about the B-tree Index?

Options :

A : The leaf blocks in the index are doubly linked.

B : The leaf node stores a bitmap for each key value

C : Rows with a NULL value in key columns also have entries in the Index.

D :

The deletion of a row from the table causes a logical deletion in the index leaf block and the space becomes available for a new leaf entry.

Answer: B,D

Question 3

Which two statements about Database Express are true?

Options :

A : It uses internal infrastructure components, such as XDB and SQL*Net.

B : It can perform actions outside the database.

C : It has background tasks and processes that periodically collect information via FTP.

D : It has two new features: Performance Hub and Composite Active Reports.

E : cIt is not supported on Standard Edition (SE) and Express Edition (XE).

Answer: A,D

Question 4

Which statement about the Queryable Patch inventory feature is false?

Options :

A : It is used to retrieve installed patch information from a SQL prompt.

B :

It uses the PREPROCESSOR feature, which allows users to preprocess input data before it is sent to the access drivers

C : DBMS_QOPATCH provides a PL/SQL or SQL interface to view the database patches installed.

D :

It works in an Oracle database instance that is mounted. Therefore, it works in ASM instances and DG instances.

Answer: A

Question 5

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

EXPERTY DESIGNED 1Z0-497 PRACTICE TEST