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

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 3

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 4

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 5

Examine the command:sqlplus /nologIn 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