下沙论坛

 找回密码
 注册论坛(EC通行证)

QQ登录

QQ登录

下沙大学生网QQ群8(千人群)
群号:6490324 ,验证:下沙大学生网。
用手机发布本地信息严禁群发,各种宣传贴请发表在下沙信息版块有问必答,欢迎提问 提升会员等级,助你宣传
新会员必读 大学生的论坛下沙新生必读下沙币获得方法及使用
查看: 2752|回复: 0
打印 上一主题 下一主题

Oracle试题:032的23-30题

[复制链接]
头像被屏蔽

该用户从未签到

跳转到指定楼层
1
发表于 2009-4-20 11:47:05 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
最新Oracle 9i DBA题库:03223-30$ y0 Q3 G1 M* t  u
认证名称:orcacle9l database:fundamentals ii- F' ]% R- i, |; ]9 V
23.Which usermanaged
backup performed on your database can be labeled as consistent?
A.a backup performed when the database is open
B.a backup performed on a tablespace after putting the tablespace into backup mode
C.a backup performed when the database is closed by using the SHUTDOWN ABORT command
D.a backup performed when all data files and control files are checkpointed with respect to the same
system change number (SCN)
Answer : D
24.Which two file types must be included in a closed database backup taken with operating system
commands? (Choose two.)
A.data files
B.control file
C.password file
D.online redo log files
E.initialization parameter file
Answer : AB
25.You plan to take a closed database backup using operating system commands. Which three
SHUTDOWN options are appropriate for this type of backup? (Choose three.)
A.ABORT
B.NORMAL
C.IMMEDIATE
D.TRANSACTIONAL
Answer : BCD
26.You work on a database that is used for application development and operates in NOARCHIVELOG
mode. The database has 10 tablespaces out of which two are read only. As a DBA, you know that
database downtime can be tolerated and have designed a backup strategy containing a weekly closed
database backup. Which files can you exclude from the weekly usermanaged
backup? (Choose all that
apply.)
A.control files
B.sqlnet.ora file
C.tnsnames.ora file
D.data files associated with readonly
tablespaces
E.data files associated with read/write tablespaces
Answer : BCD
27.You work on a database that is used for application development and operates in ARCHIVELOG mode.
As a DBA, you know that database downtime can be tolerated and have designed a backup strategy
containing a weekly closed database backup. The local naming method is used by clients to connect to
the database.
Which files should you include in this weekly usermanaged
backup? (Choose all that apply.)
A.control file
B.sqlnet.ora file
C.archived log files
D.tnsnames.ora file
E.listener configuration file
Answer : AC
28.You issue this SQL command to perform an online backup of the USER_DATA tablespace: ALTER
TABLESPACE user_data BEGIN BACKUP;
Next, you issue an operating system command to back up user_data01.dbf, the file that belongs to the
USER_DATA tablespace.
You then experience an instance failure. Which three statements are true? (Choose three.)
A.The user_data01.dbf file needs to be restored from an earlier backup and recovered.
B.The online backup of the USER_DATA tablespace can be ended with an ALTER DATABASE command.
C.The backup of user_data01.dbf is unusable for future recoveries if the operating system copy was not
completed before the instance failure.
D.The database open fails because the header of the user_data01.dbf data file is not synchronized with
the other database files.
E.The user_data01.dbf file is corrupted because of the instance failure during the online backup of the
data file.
Answer : BCD
29.You just completed a manual open database backup. However there seems to be a problem with the
database performance. You discover that the database is generating many log switches and the LGWR is
consuming lots of CPU time. You have an idea of what the problem is and you begin looking at the
information in V$BACKUP and in V$DATAFILE_HEADER.
What do you suspect is the problem?
A.One or more data files have a status of ACTIVE.
B.One or more data files have a status of ONLINE.
C.One or more data files have a status of OFFLINE.
D.One or more data files have a status of NOT ACTIVE.
Answer : A
30.Because your business requirements do not permit you to shut down the database to perform
backups, you decide to perform online backups. You use the ALTER TABLESPACE .. BEGIN BACKUP
command to perform the backups. The command returns the following error:
ERROR at line 1:
ORA01123:
cannot start online backup; media recovery not enabled
What could be the reason for this error?
A.The database is in the MOUNT state.
B.The database is in NOARCHIVELOG mode.
C.The command was executed on the SYSTEM tablespace.
D.The command was executed on a temporary tablespace.
E.The command was executed on a readonly
tablespace.
Answer : B
分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 分享分享 顶 踩

本版积分规则

关闭

下沙大学生网推荐上一条 /1 下一条

快速回复 返回顶部 返回列表