| Team Fly | |
5. For which of the following SQL commands is parallel processing not enabled by default?
A. select
B. insert
C. create
D. alter
6. What is meant by ''degree of parallelism"?
7. What new analytic feature can be used to forecast values based on existing measures?
8. What two methods can be used to run the SQLAccess Advisor utilities for materialized views?
9. Which of the following are components of an RAC system? (Select all that apply.)
A. Parallel Execution Server
B. Cluster Manager
C. Shared Storage
D. ASM Instance
E. Global Cache Service
10. In a grid computing envrionment, the _______________ instance of a node manages the disk groups and maintains a map of data files and disks.
11. ________________ partitioning allows you to control the placement of records in specified partitions based on sets of partition key values.
12. What analytic function would you use to assign each row from a query to one of five buckets?
13. What are the database components involved in grid computing?
14. What are the two types of windows that can be used in analytic functions?
15. The _______________ automatically collects workload and performance statistics used for database self-management activities.
16. When creating partitioned tables, what option should you use to ensure that rows are redistributed to their correct partition if their partition key is updated?
| Team Fly | |