CertsTopics Logo

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

1z0-083 Exam Results

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

Oracle Database Administration II Questions and Answers

Question 53

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

Options:

A.

It has the same common users defined as does CDB1.

B.

It has only local roles.

C.

It has the same number of roles as CDB1.

D.

Service PDB1 is created for remote logins to PDB1.

E.

It is in mount state after creation.

F.

It has no local users.

Question 54

Choose three. Which three are true in Oracle 19c and later releases?

Options:

A.

Tablespaces always remain in read/write mode during transportable tablespace operations.

B.

Tablespaces never remain in read/write mode during transportable tablespace operations.

C.

A transportable data pump import can leave a plugged-in tablespace in read-only mode.

D.

Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.

E.

A transportable data pump import can leave a plugged-in tablespace in read/write mode.

F.

An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.

Question 55

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

Options:

A.

cloning a remote container database in interactive mode

B.

cloning a remote pluggable database in silent mode

C.

relocating a remote pluggable database in interactive mode

D.

relocating a remote container database in silent mode

E.

cloning a remote container database in silent mode

F.

relocating a remote pluggable database in silent mode

G.

relocating a remote container database in interactive mode.

Question 56

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

Options:

A.

It recompiles all stored PL/SQL code by using utlrp.sql.

B.

It empties the RECYCLE BIN.

C.

It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

D.

It sets all user tablespaces to “read-only” before starting the upgrade.

E.

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

F.

It increases tablespace size, if required, to meet upgrade requirements.

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