SQL * LOADER

1) What is SQL * Loader and why we are using SQL * LOADER?

2) What are the files we are using in SQL * Loader?

3) What is difference between Badfile, Logfile and Discard files.

4) How to Insert two tables using one data file?

5) What is FILLER and SKIP Option in SQL * LOADER?

6) What are the options available in SQL * LOADER?

7) How to insert data in one table using two data files?

8) SQL*Loader is auto commit or Not?

Oracle Tuning:

1) What are the tuning methodologies you are suing?

2) What is SQL TRACE and How to Enable SQL TRACE?

3) What is explain plan. how do you read it.

4) What are the things trace file contain?

5) Where we can find a trace file and what is the trace file extension?

6) What is TKPROF?

7) How to reduce a cost in Cost based tuning and what are the things you are following?