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
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
Answer: C
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
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
Answer: A
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
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
Answer: C
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
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
Answer: B
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
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
Answer: BCD