What is a valid conclusion about index usage in the above 4 SQL statements?
A. All 4 SQL statements will use an index. B. Statements 1, 2 & 3 will use an index, and in statement 4 the index will be ignored. C. Statements 1, 3 & 4 will use an index, and in statement 2 the index will be ignored. D. None of the SQL statements will use an index. E. Statements 1 & 3 will use an index, and in statement 2 & 4 the index will be ignored. F. Only statement 1 will use an index, and in statement 2, 3 & 4 the index will be ignored. Answer(s) E Q. Which statement is valid regarding index clusters? A. Index clusters can only be used for tables with low cardinality columns. B. Index clusters are generally well suited for tables that have many full table scans. C. Normal B-Tree indexes do not store null key values, whereas cluster indexes store null keys. D. A cluster index always takes up much more storage space than a normal index for the same set of key values. Answer(s) C Q. Which four statements are true regarding materialized views? (Choose four) A. Materialized views ca
