单项选择题
A. It collects statistics into the pending area in the data dictionary
B. It creates a virtual hidden column in the CUSTOMERS_OBE table
C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT
D. It creates a histogram to hold skewed information about the data in the columns
单项选择题 What is the output of this command?()
多项选择题 You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? ()
多项选择题 When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this?()