Oracle 1z0-040: Oracle Database 10g: New Features for Administrators
#161. You want to implement ASM for the existing database instances and define the following parameters in the parameter file of the ASM instance. DB_UNIQUE_NAME = +ASM ASM_POEWR_LIMIT = 1 ASM_DISKSTRING = '/dev/dsk/*s2','?/dev/dsk/c1*' ASM_DISKGROUPS = dgroupA, dgroup B LARGE_POOL_SIZE = 8MB While starting the ASM interface, you get the following error message: ORA-15021: parameter "asm_diskstring" is not valid in RDBMS instance. And the instance startup fails. What causes the instance startup to fail?
#165. Oracle provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing the dbms _ redefinition. start _redef_table procedure call? (Choose two)
#166. Users complain that SOL statements using a particular index fail Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recovery strategy available in Oracle 10g?
#167. When you are performing a backup, the Flash Recovery Area is low on free space. Under which two circumstances would warnings be issued to you? (Choose two.)
#168. You want the database to send an e-mail to the senior database administrator whenever the Warning threshold for the Database CPU time metric is reached. Which option would you use to accomplish this activity?
gen. 0.065
Forum
Master braindump