1z0-043單項(xiàng)選擇題每日一練(2019.01.17)

來源：考試資料網(wǎng)

1 The listener has shut down unexpectedly. You want to view the listener log file and listener trace file to find the cause of the problem. How can you view the contents of the listener log file and the listener trace file？（）

點(diǎn)擊查看答案

2 An RMAN backup job fails， displaying the following error message：
ORA19809： limit exceeded for recovery files
Your analysis shows that the Flash Recovery area is full. What would you do to resolve the error？（）

點(diǎn)擊查看答案

3 You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M
SORT_AREA_SIZE = 100M
HASH_AREA_SIZE = 100M
BITMAP_MERGE_AREA_SIZE = 100M
CREATE_BITMAP_AREA_SIZE = 100M
Which statement is true？（）

點(diǎn)擊查看答案

4 You query the ORDERS table and discover that order number 1101 is missing. One of your reports， generated at 5：00 A.M. on April 23， 2005 using Oracle Reports， includes this order number in the output. You have inserted 100 new orders into the ORDERS table since generating this report. Which flashback technology would you use to recover order number 1101 into the ORDERS table without losing the 100 orders that you added after the report was generated？（）

點(diǎn)擊查看答案

5 You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）

點(diǎn)擊查看答案