#32. You decided to use multiple buffer pools in the database buffer cache of your database. You set the sizes of the buffer pools with the DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE parameters and restarted your instance. What else must you do to enable the use of the buffer pools?
#34. Your database contains a locally managed uniform sized tablespace with automatic segmentspace management, which contains only tables. Currently, the uniform size for the tablespace is 512 K. Because the tables have become so large, your configuration must change to improve performance. Now the tables must reside in a tablespace that is locally managed, with uniform size of 5 MB and automatic segment-space management. What must you do to meet the new requirements?
#35. You need to create an index on the PASSPORT_RECORDS table. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator. Which type of index would be best for this type of table?
#38. The users pward and psmith have left the company. You no longer want them to have access to the database. You need to make sure that the objects they created in the database remain. What do you need to do?
#39. You examine the alert log file and notice that errors are being generated from a SQL*Plus session. Which files are best for providing you with more information about the nature of the problem?
#40. Your developers asked you to create an index on the PROD_ID column of the SALES_HISTORY table, which has 100 million rows. The table has approximately 2 million rows of new data loaded on the first day of every month. For the remainder of the month, the table is only queried. Most reports are generated according to the PROD_ID, which has 96 distinct values. Which type of index would be appropriate?
gen. 0.069
Forum
Master braindump