Online 1Z0-497 Practice Test

Question 1

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

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 4

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