043题目疑问

QUESTION 25
You set the recovery window to seven days and the backup optimization to ON using the
CONFIGUREcommand of Recovery Manager (RMAN). The most recent backup of the
TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.
On February 21, when you execute a command to back up all the tablespaces to disk, you find that
RMAN backs up the TOOLStablespace also, even though the contents of the tablespace have not
changed after the backup on January 3. Because there are no changes made to the
TOOLStablespace, you decide that the tablespace should not be backed up by RMAN. What
can you do to skip backing up the TOOLStablespace without changing the current backup
optimization setting?
A. configure a default device for RMAN backups
B. temporarily disable the retention policy for RMAN backups
C. configure automatic channel allocation for RMAN backups
D. use the CONFIGURE command to reconfigure the recovery window to 60 days

答案到底是B还是D？


------------------------------------------------------------------

QUESTION 51
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL
statements in your development environment. Which three sources can you select for the advisor to
analyze? (Choose three.)
A. Top SQL
B. snapshots
C. SQL Tuning sets
D. index access path
E. optimizer statistics
F. materialized view logs

答案是ABC，还是ACD？

[[i] 本帖最后由 web1master 于 2008-8-6 10:50 编辑 [/i]]

25  B

51  ABC

为什么不对呢

二楼答案好像是错的

[[i] 本帖最后由 web1master 于 2008-8-6 10:51 编辑 [/i]]

不知道楼主在哪看的不对，那你的答案又是什么呢

在043一份题库   25：D       51：ACD

D-没有禁用这一说

ABC

Sources for SQL Tuning Advisor to analyze:
– Top SQL: Analyzes the top SQL statements
currently active
– SQL Tuning Sets: Analyzes a set of SQL statements
you provide
– Snapshots: Analyzes a snapshot
– Baselines: Analyzes a baseline

[[i] 本帖最后由 hoplite 于 2008-8-6 12:06 编辑 [/i]]

ABC是正确的

25 b 51 abc

Question 25 mentioned "without change the setting" if you change rentention time from 30 days to 60 days, you can achieve the result, but not subject to question requirement.

51. in answer d, i think index path access advice should be provided by SQL Access Advisor, not SQL Tuning Advisor. So I will select ABC

25题还是有疑问 "without changing the current backup optimization setting?" 是否指recovery window

140 181 185题库的答案有几道是各不相同，谁能说说准确的啊！

without changing the current backup optimization setting?

所以是B

第二题就没什么了，SG上面写得非常清楚，就是ABC
lz看的是185的那个题库吧，里面错误真实不少。
对于比较疑惑的问题
还是参考一下SG比较稳妥一些。

那位大牛出一个修订版就好了

[quote]原帖由 [i]ora1403[/i] 于 2008-8-6 19:57 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=11180020&ptid=1033915][img]http://www.itpub.net/images/common/back.gif[/img][/url]
without changing the current backup optimization setting?

所以是B

第二题就没什么了，SG上面写得非常清楚，就是ABC
lz看的是185的那个题库吧，里面错误真实不少。
对于比较疑惑的问题
还是参考一下SG比较稳妥一些。

那位大牛出一个修订版就好了 [/quote]


我支持答案B，非要说不对也只能说是retention policy只能是设置none，而不能说是disable

62题：

When performing a backup using Recovery Manager (RMAN), which four types of files can be
backed up with the RMAN BACKUP command? (Choose four.)
A. data file
B. password file
C. archivelog file
D. temporary file
E. online redo log file
F. the current control file
G. the tnsnames.ora file
H. current server parameter file
Answer: A, E, F, H

答案应该是acfh吧，e怎么会是对的

对62应该是acfh