CMS专题
多选题Which two statements are true regarding undo tablespaces（）AThe database can have more than one undo tablespace.BThe UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.CUndo segments automatically grow and shrink as needed， ac
题目
The database can have more than one undo tablespace.
The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
参考答案和解析
sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO
EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected.
B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误
相似问题和答案
第1题：
A. Tunnels are initiated by the LAC
B. Tunnels are initiated by the LNS
C. By default, subscriber authentication occurs on the LNS
D. By default, subscriber authentication occurs on the LAC
第2题：
Which two statements are true regarding high-availability chassis clustering？（）
- A、A chassis cluster consists of two devices.
- B、A chassis cluster consists of two or more devices.
- C、Devices participating in a chassis cluster can be different models.
- D、Devices participating in a chassis cluster must be the same models
正确答案:A,D
第3题：
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?（）
A. The data is decrypted during SORT and JOIN operations.
B. The data remains encrypted when it is read into memory.
C. The data remains encrypted when it is stored in the redo logs.
D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.
第4题：
Which two statements are TRUE regarding Coherence Indexes ？ （）
- A、 indexes are maintained by cache entry ownes
- B、 an application should not suggest an index that another aplication had suggested
- C、 indexes cannot be sorted
- D、 each application using Coherence may suggest the same set of indexes when it starts
正确答案:A,D
第5题：
Which two statements regarding asymmetric key encryption are true？（）
- A、The same key is used for encryption and decryption.
- B、It is commonly used to create digital certificate signatures.
- C、It uses two keys： one for encryption and a different key for decryption.
- D、An attacker can decrypt data if the attacker captures the key used for encryption
正确答案:A,B
第6题：
Which two statements are true regarding the role of the Routing Engine (RE)?（）
- A、The RE controls and monitors the chassis.
- B、The RE manages the Packet Forwarding Engine (PFE).
- C、The RE receives a copy of the forwarding table from the forwarding plane.
- D、The RE implements class of service (COS).
正确答案:A,B
第7题：
Which two statements are true regarding L2TP? （）(Choose two.)
- A、Tunnels are initiated by the LAC
- B、Tunnels are initiated by the LNS
- C、By default, subscriber authentication occurs on the LNS
- D、By default, subscriber authentication occurs on the LAC
正确答案:A,C
第8题：
A. The same key is used for encryption and decryption.
B. It is commonly used to create digital certificate signatures.
C. It uses two keys: one for encryption and a different key for decryption.
D. An attacker can decrypt data if the attacker captures the key used for encryption.
第9题：
Which two statements are true regarding undo tablespaces（）
- A、The database can have more than one undo tablespace.
- B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.
- C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.
- D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
正确答案:A,C
第10题：
Which two statements are true regarding subqueries? （）
- A、A subquery can retrieve zero or more rows
- B、Only two subqueries can be placed atone level
- C、A subquery can be used only in SQL query statements
- D、A subquery can appear on either side of a comparison operator
- E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
正确答案:A,D