Online 1Z0-497 Practice Test

Question 1

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

Question 2

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

Options :

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)

Answer: D

Question 3

Several tables are accidentally deleted from a PDB. Which database would you immediately connect to, and as which user, to recover these tables?

Options :

A : the CDB as the ROOT user

B : the CDB as the CDBADMIN user

C : the PDB as the ROOT user

D : the PDB as the PDB Admin user

Answer: A

Question 4

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 5

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

EXPERTY DESIGNED 1Z0-497 PRACTICE TEST