Q1. What is partitioning? Why is it useful? Give two methods of partitioning.

Respond in 50 words or less.

2737526 Sep 26, 2015 10:53 AM
Q2 Manage workloads.
Mark, update, and remove recommendations.
Peform 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/.