CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Oracle Database 19c 1z0-083 Oracle Study Notes

Page: 16 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 61

Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

Options:

A.

Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance.

B.

A connection to an auxiliary instance is always required.

C.

A subset of the target database can be duplicated.

D.

A new DBID is always created for the duplicated database.

E.

A connection to the recovery catalog instance is always required.

F.

A backup of the target database is always required.

G.

Duplication can be done by having the target database instance push copies to the auxiliary database instance.

Question 62

Choose the best answer. Which statement correctly describes the SQL profiling performed by the SQL Tuning Advisor?

Options:

A.

It is a set of recommendations by the optimizer to change the access methods used.

B.

It is auxiliary information collected by the optimizer for a SQL statement to eliminate estimation error.

C.

It is a set of recommendations by the optimizer to restructure a SQL statement to avoid suboptimal execution plans.

D.

It is auxiliary information collected by the optimizer for a SQL statement to help use better joins orders.

E.

It is a set of recommendations by the optimizer to create new indexes.

Question 63

Choose two. Examine this configuration: 1. CDB1 and CDB2 are two container databases. 2. PDB1 is a pluggable database in CDB1. 3. PDB1_C1_SRV is a service for PDB1. 4. CDB1_LINK is a database link in CDB2 referring to PDB1. 5. CDB2 is also an entry in tnsnames.ora pointing to the CDB2 database default service. You execute these commands successfully: $ sqlplus sys/oracle_4U@cdb2 as sysdba SQL> CREATE PLUGGABLE DATABASE PDB1 FROM PDB1@CDB1_LINK SERVICE_NAME_CONVERT= ('PDB1_C1_SRV', 'PDB1_C2_SRV') ; Which two are true?

Options:

A.

PDB1_C2_SRV will be created but not started.

B.

PDB1 will be created in CDB2 and automatically opened.

C.

PDB1_C1_SRV in CDB1 will be renamed PDB1_C2_SRV.

D.

PDB1 will be created in CDB2 and left in MOUNT state.

E.

PDB1_C2_SRV will be created and started automatically.

Question 64

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

Options:

A.

defining primary keys for all tables to speed up all queries

B.

using check constraints to speed up updates

C.

defining foreign keys for all tables to speed up joins

D.

the physical data model

E.

the configuration of storage arrays

Page: 16 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF