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

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 3

Which two statements about Automatic Data Optimization (ADO) are true?

Options :

A : ADO policies can automatically compress data when it qualifies.

B : ADO policies can automatically move segments when necessary.

C : ADO is not dependent on Heat Map, and works even if Heat Map is disabled.

D : You cannot compress at block level, but you can compress at segment level.

E : You can compress at row level only for QUERY LOW.

Answer: D,E

Question 4

Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

Options :

A : 615 MB

B : 2.5 GB

C : 4 GB

D : 12 GB

E : 22 GB

Answer: B

Question 5

Which targets can be managed by using Enterprise Manager Cloud Control?

Options :

A : Hosts and databases

B : Hosts, databases, and application servers

C : Application servers and web applications

D : Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)

E : Databases, application servers, and web applications

F : Hosts, databases, application servers, web applications, OMS, and OMR

Answer: A

Higher Test Marks with Free Online 1Z0-497 Exam Practice

Buying Options: