What are two main advantages of using bitmap indexes?
(Choose two) A. Bitmap indexes use less storage space. B. Bitmap indexes offer maximum concurrency. C. Bitmap indexes are easy to maintain when you issue DML statements. D. Bitmap segments are updated upon COMMIT, at the end of the transaction. E. Bitmap indexes work very fast with multiple predicates that are combined with AND, OR, and NOT operators. Answer(s) A,E Q. The DBA’s task of building a well performing database often begins with selecting proper data storage structures. DBAs should be aware of what types of storage structures are appropriate for various data access methods. Which three data access methods will enhance database performance when combined with the appropriate types of application? (Choose three) A. Cluster B. Advanced Queue C. Materialized view D. Advanced Replication E. Index-organized table F. Real Application Cluster Answer(s) A,C,E Q. Which two statements correctly describe the use of the REFRESH option when creating materialized views? (Choose two) A. Use t
