Team Fly 

Page 343

Progress Check Image

1. In an RAC system, what component connects the nodes to the shared storage?

2. When a disk is added to an ASM disk group, what happens to the existing data in the group?

3. True or False: A database instance in an ASM system accesses the disk groups?

4. What component of a self-managing database contains workload and performance statistics used for self-management activities?

5. What are the database-related components that are part of grid computing?

6. What is the function of the Cluster Manager in RAC systems?

CRITICAL SKILL 9.9
Use SQL Aggregate and Analysis Functions

Once your database has been loaded with data, your users or applications will, of course, want to use that data to run queries, perform analysis, produce reports, extract data, and so forth. Oracle Database 10g provides many sophisticated aggregation and analysis functions that can help ease the pain sometimes associated with analyzing data in large databases.

Progress Check Answers

1. The Global Cache Service (or Cache Fusion) connects the nodes to the shared storage.

2. The existing data is automatically redistributed among all disks in the disk group.

3. False. The database instance communicates with the ASM instance to determine which ASM files to access directly. Only the ASM instance works with the disk groups.

4. The Automatic Workload Repository contains workload and performance statistics used for self-management activities.

5. RAC, ASM, and OEM are the database components that are part of grid computing.

6. The Cluster Manager monitors the status of each database instance in the cluster and enables communication between the instances.

Team Fly 
0362-CRITICAL SKILL 9.9 Use SQL Aggregate and Analysis Functions