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

Examine the command:

sqlplus /nolog

In which scenario would this command execute successfully?

Options :

A : only from the server, if the database instance is not up

B : from either a client or server, even if the database instance is not up

C :

from either a client or server, only if the database instance is up, and the command connects the session to the instance

D :

from either a client or server, only if the database instance is up, but the command does not connect the session to the instance

Answer: B

Question 3

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 4

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 5

YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?c

Options :

A : FULL

B : SCHEMAS

C : TRANSFORM

D : REMAP_SCHEMA

E : REMAP_TABLESPACE

Answer: D

Free 1Z0-497 Mock Exam – Practice Online Confidently

Buying Options: