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 6 out of 8 pages
Viewing questions 51-60 out of questions
Questions # 51:

A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') END; All users have their default set of system privileges. For which three situations will data not be redacted?

Options:
A.

SYSsessions,regardlessoftherolesthataresetinthesession

B.

SYSTEMsessions,regardlessoftherolesthataresetinthesession

C.

SCOTT sessions, only if the MGR role is set in the session

D.

SCOTT sessions, only if the MGR role is granted to SCOTT

E.

SCOTTsessions,becauseheistheownerofthetable

F.

SYSTEM session, only if the MGR role is set in the session

Expert Solution
Questions # 52:

You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges. The statistics_level parameter is PDB modifiable. As the user sys, execute the following command on pdb2: SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE; Which statement is true about the result of this command?

Options:
A.

The statistics_level parameter is set to all when any of the PDBs is reopened.

B.

The statistics_level parameter is set to all only for PDB2 when it is reopened.

C.

The statistics_level parameter is set to all when the root database is restarted.

D.

The statement is ignored because there is no SPFILE for a PDB.

Expert Solution
Questions # 53:

Which three statements are true about Flashback Database?

Options:
A.

Flashback logs are written sequentially, and are archived.

B.

Flashback Database uses a restored control file to recover a database.

C.

The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.

D.

Flashback Database can recover a database to the state that it was in before a reset logs operation.

E.

Flashback Database can recover a data file that was dropped during the span of time of the flashback.

F.

Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Expert Solution
Questions # 54:

Examine this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are pluggable databases in CDB1. You execute these commands successfully: Which two are true? (Choose two.)

Options:
A.

PDB1 and PDB2 are in MOUNT state.

B.

Redo logs are opened.

C.

PDB1 and PDB2 are in READ ONLY state.

D.

CDB$ROOT is in MOUNT state.

E.

PDB$SEED is in READ ONLY state.

Expert Solution
Questions # 55:

Which two are true about gathering optimizer statistics? (Choose two.)

Options:
A.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

B.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

C.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

D.

System statistics can be gathered only while connected to CDB$ROOT.

E.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

Expert Solution
Questions # 56:

HR_ROOT is an application container with the HR_APP application installed. No application PDBs and no application seed have yet been created in HR_ROOT. An application PDB, PDB1,must be created so that the HR_APP application's common objects are accessible to it. Which two methods can be used?

Options:
A.

Create the PDB1 application PDB and synchronize it with poB$SEED.

B.

Create the PDB1 application PDB and synchronize it with HR_ROOT.

C.

Create the PDB1 application PDB and install HR_APP in it.

D.

Create an application seed, and install HR_APP in it.

E.

Create an application seed, synchronize it with HR_ROOT, and then create the PDB1.application PDB.

Expert Solution
Questions # 57:

Identify three benefits of Unified Auditing.

Options:
A.

Decreased use ofstorage to store audit trail rowsin the database.

B.

It improves overall auditing performance.

C.

It guarantees zero-loss auditing.

D.

The audit trail cannot be easily modified because it is read-only.

E.

It automatically audits Recovery Manager (RMAN) events.

Expert Solution
Questions # 58:

Choose three. Which three are true about upgrading an application in an application container?

Options:
A.

An application root clone gets created automatically.

B.

The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

C.

After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

D.

The upgrade must be performed when connected to CDB$ROOT.

E.

An application name and version number must be specified to upgrade the application.

F.

After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

Expert Solution
Questions # 59:

Choose two. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?

Options:
A.

The response file can specify the path of the sudo program.

B.

The response file must contain the root or sudo password.

C.

Silent install always runs operating scripts automatically.

D.

The response file can specify the root or sudo password.

E.

The installer will prompt for the root or sudo password.

Expert Solution
Questions # 60:

Which two are prerequisites for performing Flashback Transaction?

Options:
A.

Fast Recovery Area must be enabled for the database

B.

The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

C.

Undo retention guarantee must be configured for the database.

D.

A supplemental log must be enabled for the primary key.

E.

A supplemental log must be enabled for the primary key.

Expert Solution
Viewing page 6 out of 8 pages
Viewing questions 51-60 out of questions