Free Oracle 1Z0-497 Exam Questions

Become Oracle Certified with updated 1Z0-497 exam questions and correct answers

Page: 1 / 31

Total 155 Questions | Updated On: Jun 05, 2025

Add To Cart

Question 1

You are about to apply a patch to a database. Which recommended action is incorrect?

A : You should check the patch conflict with installed patches before applying the patch

B : You should make sure that you have a good backup of the software, database, and configuration files.

C : You should install the latest O patch before applying the patch.

D : You should check the fifth digit of the release information to confirm that the Patch Set Update (PSU) is applied successfully.

E : You should stop all applications running from the software directory that is being patched.

Answer: B

Question 2

Which two statements about Database Express are true?

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 3

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)))

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 4

Which process is responsible for writing the contents of database buffers to data files?

A : Process Monitor process (PMON)

B : Listener Registration process (LREG)

C : System Monitor process (SMON)

D : Database Writer process (DBW)

E : Log Writer process (LGWR)

F : Checkpoint process (CKPT)