Oracle
1Z0-083 Exam
Oracle Database Administration II Exam
QUESTIONS & ANSWERS
(Demo Version)
Thank You For Downloading 1Z0-083 Exam PDF Demo
QuizDumps helps you to prepare Oracle Database exam. Get most Up-to-Date Oracle
1Z0-083 exam Questions and Answers and pass the 1Z0-083 exam in the first attempt.
Get Full 1Z0-083 Exam PDF Here
https://quizdumps.com/exam/1z0-083-dumps/
, Oracle
1Z0-083 Exam
Oracle Database Administration II Exam
,Questions & Answers PDF Page 2
Version: 4.0
Question: 1
Which two are true about flashback features in Oracle Database 19c and later releases?
A. Flashback logs are monitored and proactively deleted when beyond the retention period definedin
DB_flashback_retention_TARGET only after there is space pressure
B. Flashback logs are monitored and proactively deleted when beyond the retention period definedin
db_flashback_retention_target before there is space pressure.
C. Flashback logs are automatically purged whenever the value
Of DB_FLASHBACK_RETENTION_TARGET is changed.
D. Flashback logs are monitored for being older than the retention period defined
in db_flashback_retention_target and can be deleted by an administrator written event trigger.
E. Flashback logs are automatically purged when db_flashback_retention_target is set lower
than the time they have already been retained.
Answer: BD
Question: 2
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational
Database Management System (RDBMS)?
A. The Oracle Grid Infrastructure Installation must be owned by the grid user.
B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management
binaries.
C. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle
Inventory group.
D. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as
secondary groups.
E. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
E. By default, members of the OSASM group can access Automatic Storage Management and RDBMS
instances.
Answer: AE
,Questions & Answers PDF Page 3
Question: 3
Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true?
A. A container map exists for the revenue table, but Is not enabled.
B. The maptable table defines a logical partition key on a commonly used column for the revenue table.
C. The containers clause cannot be used in queries on the revenue table.
D. The revenue table partitions are not pruned across the PDBs automatically.
E. The maptable table is a metadata-linked table.
F. The revenue table must be a list-partitioned table.
Answer: AE
Question: 4
Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery
Manager (RMAN)?
A. It can be performed using an auxiliary instance managed by a DBA.
B. It can be used to recover a truncated table.
C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
D. RMAN always includes tablespaces containing undo segments in the recovery set.
E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
F. flashback database must be enabled for it to work.
G. It can be used to recover a dropped tablespace.
H. It can be performed using an auxiliary instance managed by RMAN.
Answer: AEFH
Question: 5
You are managing this configuration:
1. CDB1 is a container database.
2. BDB1 and PDB2 are two pluggable databases in CDB1.
3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.
, Questions & Answers PDF Page 4
Which two are true?
A. The inserts on USER1 . EMP were committed when the session connected to pdb2.
B. The insert on user2.dept is uncommitted.
C. The inserts on USER1. EMP were committed when the session inserted a row into user2 .dept.
D. The inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.
E. The insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.
F. The insert on user2.dept fails because of the active transaction in the parent container.
G. The inserts on USER1.EMP were rolled back when the session connected to pdb2.
Answer: BE
1Z0-083 Exam
Oracle Database Administration II Exam
QUESTIONS & ANSWERS
(Demo Version)
Thank You For Downloading 1Z0-083 Exam PDF Demo
QuizDumps helps you to prepare Oracle Database exam. Get most Up-to-Date Oracle
1Z0-083 exam Questions and Answers and pass the 1Z0-083 exam in the first attempt.
Get Full 1Z0-083 Exam PDF Here
https://quizdumps.com/exam/1z0-083-dumps/
, Oracle
1Z0-083 Exam
Oracle Database Administration II Exam
,Questions & Answers PDF Page 2
Version: 4.0
Question: 1
Which two are true about flashback features in Oracle Database 19c and later releases?
A. Flashback logs are monitored and proactively deleted when beyond the retention period definedin
DB_flashback_retention_TARGET only after there is space pressure
B. Flashback logs are monitored and proactively deleted when beyond the retention period definedin
db_flashback_retention_target before there is space pressure.
C. Flashback logs are automatically purged whenever the value
Of DB_FLASHBACK_RETENTION_TARGET is changed.
D. Flashback logs are monitored for being older than the retention period defined
in db_flashback_retention_target and can be deleted by an administrator written event trigger.
E. Flashback logs are automatically purged when db_flashback_retention_target is set lower
than the time they have already been retained.
Answer: BD
Question: 2
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational
Database Management System (RDBMS)?
A. The Oracle Grid Infrastructure Installation must be owned by the grid user.
B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management
binaries.
C. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle
Inventory group.
D. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as
secondary groups.
E. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
E. By default, members of the OSASM group can access Automatic Storage Management and RDBMS
instances.
Answer: AE
,Questions & Answers PDF Page 3
Question: 3
Your sales_root application container has two application PDBs.
The sales_app application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true?
A. A container map exists for the revenue table, but Is not enabled.
B. The maptable table defines a logical partition key on a commonly used column for the revenue table.
C. The containers clause cannot be used in queries on the revenue table.
D. The revenue table partitions are not pruned across the PDBs automatically.
E. The maptable table is a metadata-linked table.
F. The revenue table must be a list-partitioned table.
Answer: AE
Question: 4
Which four are true about performing Tablespace Point-In-Time Recovery (TSPITR) using Recovery
Manager (RMAN)?
A. It can be performed using an auxiliary instance managed by a DBA.
B. It can be used to recover a truncated table.
C. RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.
D. RMAN always includes tablespaces containing undo segments in the recovery set.
E. It can be performed repeatedly until the correct time is found without using an RMAN catalog.
F. flashback database must be enabled for it to work.
G. It can be used to recover a dropped tablespace.
H. It can be performed using an auxiliary instance managed by RMAN.
Answer: AEFH
Question: 5
You are managing this configuration:
1. CDB1 is a container database.
2. BDB1 and PDB2 are two pluggable databases in CDB1.
3. user1 .EMP Is a table In PDBI and user2.DEPT is a table in PDB2.
, Questions & Answers PDF Page 4
Which two are true?
A. The inserts on USER1 . EMP were committed when the session connected to pdb2.
B. The insert on user2.dept is uncommitted.
C. The inserts on USER1. EMP were committed when the session inserted a row into user2 .dept.
D. The inserts on USER 1 . EMP remain uncommitted when the session connected to pdb2.
E. The insert on user2.dept Is a recursive autonomous transaction by the child session and is committed.
F. The insert on user2.dept fails because of the active transaction in the parent container.
G. The inserts on USER1.EMP were rolled back when the session connected to pdb2.
Answer: BE
