CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Oracle Database 12c 1z0-063 Full Course Free

Page: 8 / 10
Total 276 questions
Get 1z0-063 Full Access Download 1z0-063 PDF

Oracle Database 12c: Advanced Administration Questions and Answers

Question 29

Examine the parameters for your database instance:

NAME TYPE VALUE

------------------------------------------------

optimizer_adaptive_reporting_only boolean FALSE

optimizer_capture_sql_plan_baselines boolean FALSE

optimizer_dynamic_sampling integer 2

optimizer_features_enable string 12.1.0.1

Which three statements are true about the process of automatic optimization by using statistics feedback? (Choose three.)

Options:

A.

The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

B.

The optimizer can re optimize a query only once using cardinality feedback.

C.

The optimizer enables monitoring for cardinality feedback after the first execution of a query.

D.

The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

E.

After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Question 30

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

Options:

A.

A PDB must be in closed state before it can be unplugged.

B.

A PDB must have been opened at least once after creation.

C.

A PDB must be in MOUNT state before it can be unplugged.

D.

PDB data files are automatically removed from disk.

E.

An unplugged PDB can be plugged into the same or another container database (CDB).

Question 31

Which four actions are possible during an Online Datafile Move operation? (Choose four.)

Options:

A.

Creating and dropping tables in the datafile being moved

B.

Performing file shrink of the data file being moved

C.

Querying tables in the datafile being moved

D.

Performing Block Media Recovery for a data block in the datafile being moved

E.

Flashing back the database

F.

Executing DML statements on objects stored in the datafile being moved

Question 32

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:

Which statement is true about the execution of the last command?

Options:

A.

It succeeds and displays all the tablespaces that belong to the root database.

B.

It fails and returns an error because a connection is not made by using the SYSDBA privilege.

C.

It succeeds and displays all the tablespaces that belong to the root and pluggable databases.

D.

It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.

Page: 8 / 10
Total 276 questions
Get 1z0-063 Full Access Download 1z0-063 PDF