1z0-083 Exam Questions and Answers | Exam-Dumps.net (Page: 3)

QUESTION: 11

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
FLASHBACK drop requires undo to retrieve all versions of a row that existed two points in time.
FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

Answer(s): A,B,F

Reveal Solution Next Question

QUESTION: 12

Which two are prerequisites for performing Flashback Transaction?

Fast Recovery Area must be enabled for the database
The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.
Undo retention guarantee must be configured for the database.
A supplemental log must be enabled for the primary key.
A supplemental log must be enabled for the primary key.

Answer(s): B,D

Reveal Solution Next Question

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement: SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR; What is the outcome?

All historical data older than two years, if any, is purged from the flashback archive FDA1.
An error is returned because the retention period cannot be reduced.
All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years
All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time.

Answer(s): A

Reveal Solution Next Question

QUESTION: 14

Which three statements are true about Flashback Data Archive?

To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database
While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

Answer(s): C,D,E

Reveal Solution Next Question

QUESTION: 15

Examine the statements that use flashback technologies:

FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYYMM¬DD HH:MI:SS');
SELECT * FROM customers AS OF SCN 123456; FLASHBACK TABLE customers TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP TO TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
ALTER TABLE customers FLASHBACK ARCHIVE;

Which set of statements depends on the availability of relevant undo data in the undo tablespace?

1,3,6
1,2,5
3,4,5
2,3,5,6

Answer(s): B

Reveal Solution Next Question

Oracle 1z0-083 Exam (page: 3)
Oracle Database Administration II
Updated on: 29-Aug-2025

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

QUESTION: 15

Oracle 1z0-083 Exam (page: 3) Oracle Database Administration II Updated on: 29-Aug-2025

QUESTION: 11

QUESTION: 12

QUESTION: 13

QUESTION: 14

QUESTION: 15

Oracle 1z0-083 Exam (page: 3)
Oracle Database Administration II
Updated on: 29-Aug-2025