You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
Which initialization parameter must you set to enable automatic archiving? ()
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?()
You specified segment space management as automatic for a tablespace. What effect would this have on space management?()
You work as a database administrator for Supportcenter.cn. You want to create your database with the automatic undo management feature enable.Which two tasks must you perform to achieve this?()
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? ()
You issued the following statement in your SQL*Plus session: SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600; Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database?()
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
You need to recommend a solution for configuring the Automatic Updates settings on the VMs. What should you include in the recommendation?()
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; statement to enable the block change tracking feature. What information will be written in the change tracking file?()
You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? ()
Which two initialization parameters would you set to enable Automatic Shared Memory Management?()
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below: SGA_TARGET= 10GB SGA_MAX_SIZE = 14GB STREAMS_POOL_SIZE = 1GB SHARED_POOL_SIZE = 3GB Which two statements are correct in this scenario? ()
In Oracle 11g,by default which one of the following conditions implicitly enables Automatic PGA Memory Management?()
Where do you enable the CRS engine?()
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()
Which three resource plan parameters are used to enable Automatic Consumer Group Switching to estimate job execution times automatically, and to perform a switch to a low priority consumer group before they are initiated?()
Which of the following would you use to enable automatic media recovery for a database?()
You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()
You want to use the automatic management of backup and recovery operations features for your database. Which configuration must you set?()
You are developing a Windows Communication Foundation (WCF) service. You enable logging in
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode
You are administering a database stored in Automatic Storage Management (ASM). You use RMA