052(三十五）

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

Answer: BCD

View Code

 

转载于:https://www.cnblogs.com/huanhuanang/p/5366508.html