OCP 考试日记 031 20041018

最新推荐文章于 2025-10-21 22:09:11 发布

原创最新推荐文章于 2025-10-21 22:09:11 发布 · 1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#database #archive #system #file #initialization #command

OCP 专栏收录该内容

1 篇文章

订阅专栏

博客围绕Oracle数据库日志文件展开，包含多道选择题及操作步骤排序题。涉及记录数据库变更的文件、ARCn进程数量、V$LOGFILE视图状态码、日志文件磁盘数量、OMF使用、自动归档查询、日志文件名格式、多路复用命令及重命名步骤等内容。

8. Which file records all changes made to the database and is used only
when recovering an instance?
A. Archive log file
B. Redo log file
C. Control file
D. Alert log file

答案:B

10. How many ARCn processes can be associated with an instance?
A. Five
B. Four
C. Ten
D. Operating system dependent

答案:C

11. Which of the following is an invalid status code in the V$LOGFILE view?
A. STALE
B. Blank
C. ACTIVE
D. INVALID

答案: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

答案:D

15.
Which of the following statements is NOT true regarding the use of
OMF for redo logs?
A.
Dropping log files with OMF automatically 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 statement.
D.
A log file group managed with OMF can be dropped by specifying
only the log group number.

答案: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

答案:C

17. If you need to have your archive log files named with the log sequence
numbers as arch_0000001, arch_0000002, and so on (zero filled,
fixed width), what should be the value of the LOG_ARCHIVE_FORMAT
parameter?
A. arch_%S
B. arch_%s
C. arch_000000%s
D. arch_%0%s

答案:A

19. Which of the following 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.

答案: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. ALTER DATABASE OPEN
F. Backup the control file.
答案:
18. B, A, D, C, E, and F. The correct order is:
1. 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.