Oracle PLSQL and SQL basic questions for 3 years experienced

SET 1

1. Syntax for Bitmap index. What is the purpose of Bitmap index. Which scenarios do we use it.
2. What is data dictionary. What are its classifications and privileges.
3. What is correlated subquery. Eg?
4. How do we migrate data from one table to another. How do we capture exceptions during that. (try to explain with bulk collect and saved expection cos thats what they look for)
5. If your query doesnt use indexes how do you tell the query to make use of the index you created. (here you need to explain about oracle hints)
6. what is correlated update.
7. Connect by Prior.
8. What are the uses of regular expressions. Learn few important functions of regular expressions. They may ask few real time questions on the spot to write a query using regular expressions.

SET 2

1.  What is cursor. types of cursor.  Why do we have referential cursor.

2.  What are the types of collections (Nested table, varray, associate array).  Difference between them.  Prepare some stored procedures for all these and execute them and check the output.

3.  What are saved exceptions.  Why should we use it.

4.  Difference between materialized view and normal view.

5.  Use of force view.

6.  Difference between stored procedure and function

7.  Difference between truncate and delete and drop.

8.  Prepare a stored procedure for bulk collect and give some sample values and execute.

10.  What are indexes.  types of it.  why do we use indexes.

11.  What are oracle hints why do we go for it.

12.  What is the use of NOCOPY passing parameter in the stored procedure.