8. Which file records all changes Made to the database and is buy om
WHEN Recovering an instance?
A. Archive Log File
B. Redo Log File
C. Control File
D. Alert log file
Answer: B
10. How Many Arcn Processes Can Be Associated with An Instance?
A. FIVE
B. Four
C. Ten
D. Operating System Dependent
Answer: c
11. Which of the following is an an information?
A. Stale
B. Blank
C. ACTIVE
D. INVALID
Answer: c
12. If You Have Two Redo Log Groups with Four MEMBERS EACH, HOW MANY
Disks does Oracle Recommend to Keep The Redo Log Files?
A. Eight
B. TWO
C. One
D. Four
Answer: D
15.
Which of the folloading statements is not true regarding the user
OMF for Redo Logs?
A.
Dropping log files with omf automaticly Drops the Related
Operating system file.
B.
OMF Manages Archived Redo Log Files Using The Initialization
Parameter DB_CREATE_ARCHIVE_LOG_DEST_N.
C.
A New Log File Group Can Be Added WITHOUT SPECIFYING A FileName in
The alter database stat.
D.
A log file group management with omf can be dropped by Specifying
Only the log group number.
Answer: B
16. Querying Which View Will Show WHether Automatic Archiving IS
ENABLED?
A. V $ archive_log
B. V $ database
C. V $ Parameter
D. V $ log
Answer: c
17. If you need to have your archive log files named with the log sequence
NumBers as arch_00000000000000001, Arch_0000002, And So ON (Zero Filled,
Fixed width, what shouth be the value of the log_archive_format
Parameter?
A. ARCH_% S
B. ARCH_% s
C. ARCH_000000% S
D. Arch_% 0% s
Answer: a
19. Which of the folloading commands is a key step in Multiplexing Redo
LOG FILES USING AN SPFILE?
A. ALTER System SET Control_Files =
'/U01/oradata/prd/cntrl01.ctl',
'/U01/oradata/prd/cntrl02.ctl' scope = SPFILE;
B. Alter system set control_files = '/ u01 / oradata / prd / cntrl01.ctl',
'/U01/oradata/prd/cntrl02.ctl' scope = memory;
C. ALTER System SET Control_Files =
'/U01/oradata/prd/cntrl01.ctl',
'/U01/oradata/prd/cntrl02.ctl' scope = Both;
D. The Number of Control Files Is Fixed When the Database Is Created.
Answer: a
18. Following Are The Steps Needed to Rename A Redo Log File. Order THEM
In The Proper Sequence.
A. Use an operating system command to rename the redo log file.
B. Shut Down The Database.
C. Alter Database Rename File 'Oldfile' To 'Newfile'
D. Startup Mount
E. ALTABASE OPEN
F. Backup The Control File.
answer:
18. B, A, D, C, E, AND F. The Correct ORDER IS:
SHUT DOWN The DATABASE.
2. Use an operating system command to rename the redo log file.
3. Startup Mount
4. ALTER DATABASE RENAME FILE 'Oldfile' to 'Newfile'
5. ALTER DATABASE OPEN
6. Back Up The Control File.
