1. List components of an Oracle instance?
2. Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?
3. What is the maximum number of database writer processes allowed in an Oracle instance?
4. Which background process is not started by default when you start up the Oracle instance?
5. Describe a parallel server configuration.
6. Choose the right hierarchy, from largest to smallest, from this list of logical database structures.

What is normalization? What are different type of normalization?

What is denormalization ?

What is a candidate key ?

What are different types of joins and whats the difference between them ?

What are indexes and What is the difference between clustered and nonclustered
indexes?

How can you increase SQL performance ?

What is the use of OLAP ?

What’s a measure in OLAP ?

What are dimensions in OLAP ?

What are levels in dimensions ?

What is normalization
-    What is an index and types of indexes. How many number of indexes can be used per table
-    What is a constraint. Types of constraints
-    What are code pages
-    What is referential integrity
-    What is a trigger
-    What are different types of joins
-    What is a self join
-    Authentication mechanisms in Sql Server
-    What are user defined stored procedures.
-    What is INSTEAD OF trigger

1. What is the data type of the surrogate key?
2. What are the steps to build the data warehouse?
3. What are the different architectures of data warehouse?
4. What are the advantages data mining over traditional approaches?
5. What is the difference between view and materialized view?
6. What is the main difference between Inmon and Kimball philosophies of data warehousing?
7. What is junk dimension? what is the difference between junk dimension and degenerated dimension?