#41. While the DBWn process writes blocks from the database buffer cache to data files, you want the Oracle database to detect any kind of corruption that is caused by the underlying disk or storage system. Which task would you perform to achieve this?
#42. You need to identify the top five events with the highest average wait time during the last 24 hours. Which option would you use to get the desired information?
#45. You are working in an OLTP environment. You wish to reduce the virtual memory requirements for the Oracle instance due to Operating system paging or swap overheads. You need to determine whether the buffer cache is oversized and could tolerate being reduced. In which two cases can you afford to reduce the buffer cache size? (Choose two.)
#46. Which two statements correctly describe the performance benefits of having large block size in a decision support system (DSS) environment? (Choose two.)
#47. You are working in an online transaction processing (OLTP) environment. The NORTH_SALES table contains one million rows. In which case would you issue the following command:
#48. You want to condense the space of an index on one of the important tables in your database. You used the ALTER INDEX COALESCE statement to achieve this task. Which requirement would have forced you to use this method instead of rebuilding the index? (Choose all that apply.)
#49. View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in DSS system. You decide to prepare an index on zone column to enhance the performance ob the queries on ZONE column. Which type of index would you select?
gen. 0.095
Forum
Master braindump