1Z0-043 10g DBA Braindump
ExamSoon 1Z0-043 Exams
Oracle Oracle Database 10g: Administration II
O rder : 1Z0-043 Exam
Practice Exam: 1Z0-043
Exam Number/Code: 1Z0-043
Exam Name: Oracle Database 10g: Administration II
Questions and Answers: 217 Q&As
Free 1Z0-043 Braindumps
Exam : Oracle 1Z0-043
Title : Oracle Database 10g: Administration II
1. These are the details about V$FLASHBACK_DATABASE_STAT:
SQL> DESC V$FLASHBACK_DATABASE_STAT
name Null? Type
------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true? (Choose two.)
A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
Answer: CD
2. View the Exhibit and examine the Flashback SCNs.
A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback
Table functionality to rectify the erroneous inserts. While performing the recovery, you chose 2004343 as the
Flashback SCN.
Which two statements are correct in this scenario? (Choose two.)
A. Only the row with DEPARTMENT_ID 290 would be flashed back.
B. The rows with DEPARTMENT_ID 290 and 300 would be flashed back.
C. The rows with DEPARTMENT_ID 290 and 280 would be flashed back.
D. You would have taken the USERS tablespace offline before starting the Flashback Table operation.
E. You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.
Answer: BE
3. You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHAR