1. Home
  2. Oracle
  3. Oracle Database 19c
  4. 1z0-083
  5. Oracle Database Administration II Questions and Answers

Pass the Oracle Oracle Database 19c 1z0-083 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 8 pages
Viewing questions 1-10 out of questions
Questions # 1:

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------0 SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1); SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE -------------1 After changing the value, you notice that FULL redaction continues to redact numeric data with zero.What must you do to activate the new default value for numeric full redaction?

Options:
A.

Re-enableredactionpoliciesthatuseFULLdataredaction.

B.

Re-createredactionpoliciesthatuseFULLdataredaction.

C.

Re-connect the sessions that access objects with redaction policies defined on them.

D.

Flushthesharedpool.

E.

Restart the database instance. Correct

Questions # 2:

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

Options:
A.

to allow database duplication without a connection to the target instance.

B.

to store backup metadata that would cause the controlfile to become too large.

C.

to store backups that would cause the controlfile to become too large.

D.

to report on the database schema at an earlier point in time.

E.

to allow database duplication without a connection to the auxiliary instance.

Questions # 3:

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

Options:
A.

If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

B.

In a PDB plan, subplans may be used with up to eight consumer groups.

C.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

D.

If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

E.

If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Questions # 4:

A container database called CDB1 is OMF-enabled. PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1: CREATE PLUGGABLE DATABASE pdb1 USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT = (‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’);

Which two are true? (Choose two.)

Options:
A.

PDB1 data files already exist in the correct location.

B.

DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.

C.

PDB_FILE_NAME_CONVERT must be set before executing the command.

D.

/u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data files for PDB1.

E.

PDB1 must be dropped from CDB1.

Questions # 5:

Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully to PDB2: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)

Options:
A.

The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.

B.

The inserts on USER1.EMP were committed when the session inserted a row into USER2. DEPT.

C.

The insert on USER2.DEPT fails because of the active transaction in the parent container.

D.

The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.

E.

The inserts on USER1.EMP were rolled back when the session connected to PDB2

F.

The insert on USER2.DEPT is uncommitted.

G.

The inserts on USER1.EMP were committed when the session connected to PDB2.

Questions # 6:

Which two are true about RMAN encryption? (Choose two.)

Options:
A.

RMAN encryption keys are stored in a database keystore.

B.

RMAN can encrypt the Oracle Database password file.

C.

Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.

D.

The SET ENCRYPTION command overrides encryption settings specified by the CONFIGURE ENCRYPTION command.

E.

Password encryption can be persistently configured using the CONFIGURE ENCRYPTION command.

Questions # 7:

Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?

Options:
A.

They can view data from any data dictionary view or dynamic performance view.

B.

They can drop any tablespace.

C.

They can view data from any user-defined tables.

D.

They can create any table.

E.

They cannot create restore points.

F.

They cannot drop tablespaces.

Questions # 8:

Choose three. Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases?

Options:
A.

The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.

B.

The target PDB must be registered in both the base catalog and the Virtual Private Catalog.

C.

The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.

D.

The base catalog must be enabled for Virtual Private Catalog use.

E.

The target PDB must be registered in a Virtual Private Catalog.

F.

The target PDB must be registered in a base catalog.

Questions # 9:

Choose three. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

Options:
A.

Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.

B.

After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new ORACLE_HOME.

C.

Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.

D.

The new extended data type capability must be enabled by running the utlrp.sql script

E.

The Oracle Application Express configuration should be updated after upgrading Oracle Database.

Questions # 10:

choose two Which two are benefits of unified auditing in full mode?

Options:
A.

All audit data is written to both the traditional locations and to the unified location.

B.

The audit trail is in a single format.

C.

Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

D.

The audit trail is read-only.

E.

The audit trail uses less space.

Viewing page 1 out of 8 pages
Viewing questions 1-10 out of questions