#2. Your boss at Company.com wants you to clarify Oracle 10g. Which two steps are performed the first time any UPDATE statement is issued after the instance is started? Choose two
#3. You work as a database administrator for Company.com. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?
#5. You work as a database administrator for Company.com. You started the instance using the init.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task?
#6. You work as a database administrator for Company.com. you find that the database performance degrades while you backup the database using recovery manager (rman). the database is running in shared server mode. the database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation?
#7. You work as a database administrator for Company.com. You decided to manage client and server connections using Local Naming method in Company.com. When you try to connect to the database you get the following error: ERROR: ORA-12154: TNS:could not resolve service name Which network configuration files would you look into to resolve this error? Choose two.
#8. You work as a database administrator for Company.com. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user's connections. Which activity must you have completed before accomplishing this task?
#9. Your Company.com database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM table space has become corrupted. Up to what point can you recover the database?
#10. You work as a database administrator for Company.com. The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct?
gen. 0.2
Forum
Master braindump