20:00

PDF|

Guide for Oracle Database Administration II

Quiz Oracle Database Administration II

Free Test
/ 10

Quiz

1/10
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common
tables of the SALES APP application. Examine these steps:
Install the SALES_APP application, induding the common tables, in the application root.
Install the SALES_APP application in the application root and the common tables in both the CDB root
and the application root.
Create an application seed.
Install the SALES_APP application in the application seed.
Create the SALES_APP1 and SALES_APP2 application PDBs.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
Sync the application seed with the application root. Which are the minimum required steps in the
correct sequence?
Select the answer
1 correct answer
A.
1,3,5,7
B.
2,5,6
C.
1,5,6
D.
3,4,1.6,8
E.
1,3,5,6,7

Quiz

2/10
A container database, CDB1, contains a pluggable database PDB1. Another container database is
called CDB2. You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three
are required?
Select the answer
3 correct answers
A.
CDB2 must be in shared UNDO mode only.
B.
CDB2 must be in archivelog mode.
C.
CDB1 must be in archivelog mode.
D.
CDB1 and CDB2 must both be in local UNDO mode.
E.
CDB1 must be in shared UNDO mode only.A container database, CDB1, contains a pluggable database PDB1.
F.
CDB1 and CDB2 must be in shared UNDO mode.

Quiz

3/10
Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?
Select the answer
2 correct answers
A.
A PDB snapshot depends on an existing storage snapshot of the source PDB.
B.
APDB snapshot can be a full copy of a source PDB.
C.
A PDB snapshot can be a sparse copy of a source PDB
D.
A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.
E.
A snapshot copy PDB can be a full copy of a source PDB

Quiz

4/10
Which two are true about creating RMAN backups for an Oracle container database?
Select the answer
2 correct answers
A.
Online Redo Log backups can be created while connected to CDB$ROOT
B.
Control file backups can be created while connected to CDB$ROOT.
C.
The BACKUP TABLESPACE command can back up a pDB tablespace even if RMAN is connected to CDB$ROOT.
D.
Archived Redo Log backups can be created while connected to PDB
E.
Control file backups can not be created while connected to a PDB

Quiz

5/10
Which three are true about Automatic Workload Repository (AWR) snapshots?
Select the answer
3 correct answers
A.
They can be retained forever.
B.
They are always created automatically.
C.
They are always created manually.
D.
They are generated if STATISTICS LEVEL is set to TYPICAL.
E.
They are generated if STATISTICS LEVEL is set to BASIC.
F.
They are generated if STATISTICS LEVEL is set to ALL.

Quiz

6/10
Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone a remote
pluggable database (PDB) starting from Oracle 19c?
Select the answer
2 correct answers
A.
creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
B.
creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
C.
backing up the cloned PDB
D.
opening the cloned PDB
E.
leaving the cloned PDB in mount state

Quiz

7/10
Which three are true about thresholds, metrics, and server-generated alerts? (Choose three.)
Select the answer
3 correct answers
A.
All metrics are instance related.
B.
Cleared stateful alerts are displayed by querying DBA_ALERT_HISTORY.
C.
A space usage management alert is automatically cleared after the underlying problem is resolved
D.
They are generated by SMON when a tablespace is 97% full.
E.
Metrics are statistical counts for a specific unit.
F.
STATISTICS_LEVEL must be set to ALL to generate alerts.

Quiz

8/10
Choose three. In which three situations can you use threshold server-generated alerts to help
diagnose and fix problems?
Select the answer
3 correct answers
A.
when free space in a dictionary managed tablespace falls below a specified percentage
B.
when free space in a locally managed tablespace falls below a specified percentage
C.
when the total number of locked user account exceeds a specific value
D.
when the number of logons per second exceeds a specific value
E.
when a resumable statement is suspended
F.
when the total number of logons exceeds a specific value

Quiz

9/10
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.)
Select the answer
2 correct answers
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.

Quiz

10/10
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE
DATABASE command? (Choose two.)
Select the answer
2 correct answers
A.
to specify a default tablespace in a PDB cloned from another PDB in the same CDB
B.
to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
C.
to include specific user tablespaces only when relocating a PDB
D.
to specify the list of user tablespaces to include when moving a non-CDB to a PDB
E.
to exclude a temp tablespace when plugging in a PDB
F.
to specify the list of tablespaces to include when creating a PDB from the CDB seed
Looking for more questions?Buy now

Oracle Database Administration II Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Oracle Database Administration II practice test! Further deepen your knowledge on Oracle Simulator; by unlocking the full version of our Oracle Database Administration II Simulator you will be able to take tests with over 282 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 282 questions.

BUY NOW

What to expect from our Oracle Database Administration II practice tests and how to prepare for any exam?

The Oracle Database Administration II Simulator Practice Tests are part of the Oracle Database and are the best way to prepare for any Oracle Database Administration II exam. The Oracle Database Administration II practice tests consist of 282 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Oracle Database Administration II database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Oracle Database Administration II Simulator will also give you an idea of the time it will take to complete each section of the Oracle Database Administration II practice test . It is important to note that the Oracle Database Administration II Simulator does not replace the classic Oracle Database Administration II study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Oracle Database Administration II exam.

BUY NOW

Oracle Database Administration II Practice test therefore represents an excellent tool to prepare for the actual exam together with our Oracle practice test . Our Oracle Database Administration II Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Oracle Database Administration II Simulator and how our unique Oracle Database Administration II Database made up of real questions:

Info quiz:

  • Quiz name:Oracle Database Administration II
  • Total number of questions:282
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Oracle Database Administration II exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Oracle Database Administration II Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Oracle Database Administration II Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Oracle Database Administration II practice tests which consist of 282 questions and also provide study material to pass the final Oracle Database Administration II exam with guaranteed success. Our Oracle Database Administration II database contain hundreds of questions and Oracle Tests related to Oracle Database Administration II Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW