1Z0-045 試験問題を無料オンラインアクセス

Users complain that SQL 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?

• A.Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.
• B.Take the individual data file offline (not the wholetablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
• C.Take the individual data file (not the wholetablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
• D.Rebuild the index using the online option.

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down:
SQL> shutdown immediate;
What is the result of executing this command?

• A.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
• B.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
• C.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode.
• D.The ASM instance is still functional, but the other instances are shut down.
• E.The ASM instance is shut down, but the other instances are still running.
• F.All the instances, including the ASM instance, are shut down in the ABORT mode.

To which three elements is the size of the block change tracking file proportional? (Choose three.)

• A.number of old backups maintained by the block change tracking file
• B.size of the database in bytes
• C.number of enabled threads in a Real Application Cluster (RAC) environment
• D.number of DBWR processes
• E.number of archiving destinations
• F.number of redo log groups

Identify three key features of ASM. (Choose three.)

• A.Segment Advisor
• B.file striping
• C.automatic file size increment
• D.automatic undo management
• E.file mirroring
• F.automatic file creation
• G.automatic disk rebalancing

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_POWER_LIMIT = 1 ASM_DISKSTRING = '/dev/dsk/*s2','/dev/dsk/c1*' ASM_DISKGROUPS = dgroupA, dgroupB LARGE_POOL_SIZE = 8MB
While starting the ASM instance, 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?

• A.ASM_DISKGROUPS cannot have two values.
• B.ASM_POWER_LIMIT should be set to a higher value.
• C.ASM_DISKSTRING parameter should not contain any wildcard characters.
• D.DB_NAME parameter should have been defined and set to ASM.
• E.INSTANCE_TYPE parameter should have been defined and set to ASM.
• F.LARGE_POOL_SIZE should be set to a lower value.