Q. 1. Which type of optimization is most commonly used today in the Oracle database?
a. Rule-based optimization
b. Cost-based optimization
c. Execution-based optimization
d. Run-based optimization
Q. 2. Which procedure of the DBMS_STATS
package can be used to gather statistics for all the tables in one given schema?
a. GATHER_TABLE_STATS
b. ANALYZE_TABLE_STATS
c. GATHER_SCHEMA_STATS
d. ANALYZE_DATABASE_STATS
Q. 3. The auto optimizer stats collection job
is enabled for our Companylink
database. However, we notice that statistics are not being collected for all of the tables in our database. What could be the cause of the missed statistics?
a. The objects being missed are not within a single schema.
b. The objects being missed are in separate tablespaces.
c. The job is not completing within the Autotask scheduled window.
d. The Autotask feature has not been enabled using DBMS_STATS
.
Q. 4. If the collection of new statistics causes a degradation of performance from the previous statistics...