1z0-043单项选择题每日一练(2019.01.17)

单项选择题
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？（）
A. Open the file at the location specified by the BACKGROUND_DUMP_DEST parameter in the pfile.
B. Open the file at the location specified by the USER_DUMP_DEST parameter in the pfile.
C. Issue the SERVICES command at the LSNRCTL> prompt.
D. Issue the STATUS command at the LSNRCTL> prompt.
单项选择题
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？（）
A.increase the value of UNDO_RETENTION
B.change the value of WORKAREA_SIZE_POLICY to AUTO
C.increase the value of DB_RECOVERY_FILE_DEST_SIZE
D.increase the value of CONTROL_FILE_RECORD_KEEP_TIME
单项选择题
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？（）
A. All the *_AREA_SIZE parameters are ignored.
B. The Automatic PGA Memory Management feature cannot be disabled.
C. The total Program Global Area （PGA） memory cannot be manually increased above 800M.
D. The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.
单项选择题
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？（）
A. Flashback Table
B. Flashback Query
C.Flashback Version Query
D. Flashback Transaction Query
单项选择题
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？（）
A. V$SYSSTAT
B. V$SESSSTAT
C. V$RSRC_PLAN
D. V$RSRC_CONSUMER_GROUP