052(三十五）

最新推荐文章于 2025-08-17 21:38:20 发布

转载最新推荐文章于 2025-08-17 21:38:20 发布 · 107 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/huanhuanang/p/5366508.html

文章标签：

#数据库

本文探讨了Oracle数据库中撤销保留参数的应用场景、数据结构排列、外部文件访问、命名方法及撤销数据的需求等核心概念。通过理解这些概念，读者可以更好地掌握数据库管理的关键方面。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

171、

171.In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value? 
A. When the data file of the undo tablespace is autoextensible 
B. When there are more than one undo tablespace available in the database 
C. When the undo tablespace is of a fixed size and retention guarantee is not enabled 
D. When the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C

View Code

172、

172.Note the following structures in your database server: 
1. Extents 
2. OS Blocks 
3. Tablespace 
4. Segments 
5. Oracle Data Block 
Which option has the correct arrangement of these structures from the smallest to the largest? 
A. 2, 5, 1, 4, 3 
B. 1, 2, 3, 4, 5 
C. 5, 2, 1, 3, 4 
D. 2, 1, 5, 4, 3

Answer: A

View Code

173、

173.You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?
A. CLOB 
B. BLOB 
C. BFILE 
D. LONG RAW

Answer: C

View Code

174、

174.Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client 
while connecting to the database instance from a remote machine? 
A. Host naming method 
B. Local naming method 
C. External naming method 
D. Directory naming method

Answer: B

View Code

175、

175.Which three operations require undo data? (Choose three.) 
A. Committing a transaction 
B. Flashing back a transaction 
C. Recovering a failed transaction 
D. Running a read-consistent query 
E. Changing a tablespace status from READ ONLY to READ WRITE