有大神 能帮我解答一下,这几道题的答案为什么是选那几项么??
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400NO 0
Which two are true?
A)Transactions will wait until free space becomes available in the undo tablespace when they havefailed to allocate space
B)The undo tablespace will grow automatically if there is not enough space to retain active undo
C)Inactive undo will be retain for at least 15 minutes
D)Expired undo will be retained as long as possible within the limits of the current size of the undo
tablespace
E)Active undo will be retained as long as needed by the transactions
Answer:CE
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDONOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400YES 64000
Which two are true?
A)Inactive UNDO will be retained as long as possible within the limits of the current size of the UNDO
tablespace.
B)The UNDO tablespace can grow automatically if there is not enough space to retain active UNDO.
C)Active UNDO will be retained as long as needed by transactions.
D)Inactive UNDO will never be retained for more than 15 minutes.
E)Inactive UNDO will always be retained for at least 15 minutes.
Answer:CE
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDONOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400YES 64000
Which two are true?
A)Inactive expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace.
B)The UNDO tablespace can grow automatically if there is not enough space to retain active UNDO.
C)Active UNDO will be retained as long as needed by transactions.
D)Inactive expired UNDO will never be retained for more than 15 minutes.
E)Inactive expired UNDO will always be retained for at least 15 minutes.
Answer:BC
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400NO 0
Which three are true?
A)Active UNDO might be retained for 15 or more minutes.
B)Inactive UNDO might be retained for 15 or more minutes.
C)The UNDO tablespace is guaranteed to be retained for ever.
D)Expired UNDO might be retained for 15 or more minutes.
E)UNDO Blocks are retained for 900 days.
F)UNDO segments are guaranteed to be retained for ever.
Answer:ABD
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400NO 0
Which two are true?
A)Transactions will wait until free space becomes available in the undo tablespace when they havefailed to allocate space
B)The undo tablespace will grow automatically if there is not enough space to retain active undo
C)Inactive undo will be retain for at least 15 minutes
D)Expired undo will be retained as long as possible within the limits of the current size of the undo
tablespace
E)Active undo will be retained as long as needed by the transactions
Answer:CE
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDONOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400YES 64000
Which two are true?
A)Inactive UNDO will be retained as long as possible within the limits of the current size of the UNDO
tablespace.
B)The UNDO tablespace can grow automatically if there is not enough space to retain active UNDO.
C)Active UNDO will be retained as long as needed by transactions.
D)Inactive UNDO will never be retained for more than 15 minutes.
E)Inactive UNDO will always be retained for at least 15 minutes.
Answer:CE
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDONOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400YES 64000
Which two are true?
A)Inactive expired UNDO will be retained as long as possible within the limits of the current size of the UNDO tablespace.
B)The UNDO tablespace can grow automatically if there is not enough space to retain active UNDO.
C)Active UNDO will be retained as long as needed by transactions.
D)Inactive expired UNDO will never be retained for more than 15 minutes.
E)Inactive expired UNDO will always be retained for at least 15 minutes.
Answer:BC
Examine these SQL statements and their output:
SQL> select name,value
2from v$parameter
3where name like 'undo%';
NAMEVALUE
-------------------- ----------------
undo_management AUTO
undo_tablespace UNDO
undo_retention 900
SQL> select contents,retention
2from dba_tablespaces
3where tablespace_name='UNDO';
CONTENTSRETENTION
-------------- --------------------
UNDOGUARANTEE
SQL> select blocks,autoextensible,maxblocks
2from dba_data_files
3Where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
------------- ----- ----------
6400NO 0
Which three are true?
A)Active UNDO might be retained for 15 or more minutes.
B)Inactive UNDO might be retained for 15 or more minutes.
C)The UNDO tablespace is guaranteed to be retained for ever.
D)Expired UNDO might be retained for 15 or more minutes.
E)UNDO Blocks are retained for 900 days.
F)UNDO segments are guaranteed to be retained for ever.
Answer:ABD
...全文
相关推荐
几道亚马逊面试题参考答案
以前给别人写的几道亚马逊面试题参考答案。题目在源代码文件内。
初中物理竞赛资料系统整理:知识框架、模型卡片与备赛路径
物理竞赛备赛与课内学习最大的差异在于知识体系更完整、跨章节综合要求更高。面对庞杂的初中物理知识点,零散刷题往往效率低下,而系统整理学习资料能帮助学生构建清晰的知识框架。从力学、电学到光学,合理的模块划分与难度梯度设计,能让学习者明确每个阶段的进阶目标。模型卡片作为核心工具,将常见题型归纳为可复用的解题套路,配以例题和变式训练,有效提升独立分析能力。这套资料按照物理规律的内在逻辑重组内容,兼顾课内衔接与竞赛拓展,既适用于初中生系统备赛,也可作为竞赛班教师的讲义底稿。掌握系统整理的方法,才能真正让物理竞赛备考有
IBM公司面试的几道IQ题
IBM公司面试的几道IQ题 很多题型都是根据这几个演变过来的
矩阵分析引论书后题答案
矩阵分析引论书后习 题答案详解,非常详细,可以放心参考
逻辑思维题及答案
开发智力的题,一些公司面试必不可少的试题。


认证与考试
