Q1. What is partitioning? Why is it useful? Give two methods of partitioning.
Q2. Manage workloads,
Mark, update, and remove recommendations.
Perform a quick tune using a single SQL statement.
Show how to make a materialized view fast refreshable.
Show how to change a materialized view such that general query rewrite is possible.
Resource:
[1] 17 SQL Access Advisor. (n.d.).Retrieved September 26, 2015, from http://docs.oracle.com/cd/B19306_01/server.102/b14211/advisor.htm#CHDEEBAI.
Q3. Static views are also known as data dictionary because they change infrequently, i.e., when there is a change to the data dictionary. There are three types of static views [1]:
Static Views
DBA_ view: displays all relevant information in the entire database. This view is inteded for administrators.
ALL_ view: displays all the information accessible to the current user, including information from the schema of the current user and information from objects in other schemas.
USER_ view: displays all the information from the schema of the current user.
Resource:
[1] Oracle views - Static Data Dictionary Views & Dynamic Performance Views - Take hold of IT technology trends - learn, practice, troubleshoot, blog. (n.d.).Retrieved September 22, 2015, from http://www.doxer.org/oracle-views-static-data-dictionary-views-dynamic-performance-views/.