Database Reference
In-Depth Information
15.
Which method could be utilized to identify both DML operations and the SQL statements
needed to undo those operations for a specific schema owner? (Choose all that apply.)
A.
Query
DBA_TRANSACTION_QUERY
for
TABLE_NAME
,
OPERATION
, and
UNDO_SQL
. Limit
rows by
START_SCN
and
TABLE_OWNER
.
B.
Query
FLASHBACK_TRANSACTION_QUERY
for
TABLE_NAME
,
OPERATION
, and
UNDO_SQL
.
Limit rows by
START_SCN
and
TABLE_OWNER
.
C.
Query
FLASHBACK_TRANSACTION_QUERY
for
TABLE_NAME
,
OPERATION
, and
UNDO_SQL
.
Limit rows by
START_TIMESTAMP
and
TABLE_OWNER
.
D.
Query
DBA_TRANSACTION_QUERY
for
TABLE_NAME
,
OPERATION
, and
UNDO_SQL
. Limit
rows by
START_TIMESTAMP
and
TABLE_OWNER
.
16.
Flashback Database relies on which technologies to recover to a point in time?
A.
Flashback Data Archive
B.
Flashback logs in the fast recovery area
C.
Undo tablespace
D.
RMAN command line
E.
None of the above
17.
The ______________ writes the Flashback Database logs in the fast recovery area.
A.
FLSH
B.
FLDB
C.
RV W R
D.
RV RW
E.
FBDA
18.
Which of these are valid Flashback Database recovery point parameters? (Choose all
that apply.)
A.
SCN
B.
Timestamp
C.
Named recovery point
D.
Transaction ID
E.
Session ID
Search WWH ::
Custom Search