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 7 out of 8 pages
Viewing questions 61-70 out of questions
Questions # 61:

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

Options:
A.

The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

B.

Oracle DBCA templates can store only logical structure and not database files.

C.

New templates can only be created by modifying an existing user-created template.

D.

The Data Warehouse template is most suitable when transaction response time is the key criterion.

E.

Oracle DBCA templates can be used to create new databases and duplicate existing databases.

Expert Solution
Questions # 62:

Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

Options:
A.

By default, AWR snapshots are taken every 60 minutes.

B.

Its collection level is determined by the value of the STATISTICS_LEVEL database parameter.

C.

By default, AWR snapshots are retained for 7 days.

D.

The taking of AWR snapshots can be disabled.

E.

AWR data is stored in the SYSTEM tablespace.

Expert Solution
Questions # 63:

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

Options:
A.

Flashback logs are not archived.

B.

Flashback logs are maintained in redo log files.

C.

Flashback logs are maintained in the Flash Recovery Area.

D.

Flashback logs are used to maintain Flashback Database related errors.

E.

Flashback logs need to be cleared manually after you disable Flashback Database.

Expert Solution
Questions # 64:

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Options:
A.

It will create a multitenant container database (CDB) with only the root opened.

B.

ItwillcreateaCDBwithrootopenedandseedreadonly.

C.

It will create a CDB with root and seed opened and one PDB mounted.

D.

It will create a CDB that must be plugged into an existing CDB.

E.

ItwillcreateaCDBwithrootopenedandseedmounted.

Expert Solution
Questions # 65:

Which three are true? (Choose three.)

Options:
A.

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

E.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

F.

Application-common OLS policies can be created in an application root inside an install/patch BEGIN¬END block.

G.

Unified auditing can be automatically synchronized to all application PDBs in an application container.

Expert Solution
Questions # 66:

Choose three. Which three activities are possible for PDBs?

Options:
A.

converting an application seed to an application PDB

B.

converting a regular PDB to an application PDB

C.

converting an application PDB to an application root

D.

copying an application container into another application container in the same CDB

E.

copying an application container into another application container in a different CDB

F.

converting an application PDB to an application seed G) converting an application PDB to a regular PDB

Expert Solution
Questions # 67:

Choose three. Which three are true about Data Pump in an Oracle multitenant environment?

Options:
A.

It can be used to transport data from a non-CDB to a PDB.

B.

It can be used to clone a CDB.

C.

It can be used to transport data between PDBs.

D.

It can be used to transport data from a PDB to a non-CDB.

E.

It can be used to create a new PDB.

Expert Solution
Questions # 68:

Choose two. Which two are true about creating RMAN backups for an Oracle container database?

Options:
A.

Control file backups can be created while connected to the root container.

B.

Archived Redo Log backups can be created while connected to an application root CDB.

C.

Control file backups can be created while connected to a nonroot container.

D.

Online Redo Log backups can be created while connected to the root container.

E.

The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

Expert Solution
Questions # 69:

Choose three. In a single-instance, multitenant container database (CDB), which three are only ever defined in or part of CDB$ROOT?

Options:
A.

redo logs

B.

control files

C.

all data dictionary metadata

D.

user-defined PL/SQL packages

E.

temporary tablespaces

F.

mandatory Oracle-supplied PL/SQL packages

G.

undo tablespaces

Expert Solution
Questions # 70:

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck. FORCE LOGGING is enabled for the database. Which two could improve read performance? (Choose two.)

Options:
A.

Increase the size of tape I/O buffers.

B.

Disable FORCE LOGGING for the database.

C.

Increase the size of the database buffer cache.

D.

Enable asynchronous disk I/O.

E.

Increase the level of RMAN multiplexing.

Expert Solution
Viewing page 7 out of 8 pages
Viewing questions 61-70 out of questions