Interview Questions.

Question 1. What Is Sql*loader And What Is It Used For?

Answer :

SQL Loader is a bulk loader software used for moving data from outside files into the Oracle database. Its syntax is similar to that of the DB2 load utility, but comes with more options. SQL*Loader helps numerous load codecs, selective loading, and multi-desk masses.

SQL Loader (sqlldr) is the utility to use for excessive overall performance information loads. The statistics can be loaded from any textual content document and inserted into the database.

Question 2. How Can One Get Sql*loader To Commit Only At The End Of The Load File?

Answer :

One cannot, however via placing the ROWS= parameter to a massive price, committing can be reduced. Make sure you've got big rollback segments equipped while you use a excessive fee for ROWS.

PL/SQL Interview Questions
Question three. Can One Improve The Performance Of Sql*loader?

Answer :

A quite simple however without difficulty overlooked trace isn't to have any indexes and/or constraints (number one key) in your load tables throughout the weight technique. This will appreciably gradual download times even with ROWS= set to a excessive value.
Add the subsequent alternative within the command line: DIRECT=TRUE. This will correctly skip most of the RDBMS processing. However, there are cases when you can not use direct load. For information, seek advice from the FAQ about the differences among the traditional and direct course loader below.
Turn off database logging by using specifying the UNRECOVERABLE choice. This choice can handiest be used with direct facts hundreds.
Run more than one load jobs simultaneously.
Question four. What Is The Difference Between The Conventional And Direct Path Loader?

Answer :

The conventional direction loader basically masses the information via using fashionable INSERT statements. The direct course loader (DIRECT=TRUE) bypasses a great deal of the logic worried with that, and loads without delay into the Oracle statistics documents. More facts approximately the restrictions of direct direction loading may be received from the Oracle Server Utilities Guide.
Some of the restrictions with direct route loads are:
Loaded statistics will now not be replicated
Cannot continually use SQL strings for column processing inside the control report.
Adv Java Tutorial
Question five. How Does One Use Sql*loader To Load Images, Sound Clips And Documents?

Answer :

SQL*Loader can load statistics from a "primary information report", SDF (Secondary Data record - for loading nested tables and VARRAYs) or LOBFILE. The LOBFILE method affords an clean manner to load documents, pics, pics and audio clips into BLOB and CLOB columns. Look at this situation:

Given the subsequent table:

CREATE TABLE image_table (

       image_id   NUMBER(5),

       file_name  VARCHAR2(30),

       image_data BLOB);

Control File:

LOAD DATA

INFILE *

INTO TABLE image_table

REPLACE

FIELDS TERMINATED BY ','

(

 image_id   INTEGER(5),

 file_name  CHAR(30),

 image_data LOBFILE (file_name) TERMINATED BY EOF

)

BEGINDATA

001,image1.Gif

002,image2.Jpg

003,image3.Jpg

Adv Java Interview Questions
Question 6. How Does One Load Ebcdic Data?

Answer :

Specify the person set WE8EBCDIC500 for the EBCDIC facts.

The following example shows the SQL*Loader controlfile to load a fixed length EBCDIC document into the Oracle Database:

LOAD DATA

CHARACTERSET WE8EBCDIC500

INFILE records.Ebc "restore 86 buffers 1024"

BADFILE records.Terrible'

DISCARDFILE statistics.Dsc'

REPLACE

INTO TABLE temp_data

(

 field1    POSITION (1:four)     INTEGER EXTERNAL,

 field2    POSITION (5:6)     INTEGER EXTERNAL,

 field3    POSITION (7:12)    INTEGER EXTERNAL,

 field4    POSITION (13:42)   CHAR,

 field5    POSITION (forty three:72)   CHAR,

 field6    POSITION (seventy three:seventy three)   INTEGER EXTERNAL,

 field7    POSITION (74:74)   INTEGER EXTERNAL,

 field8    POSITION (seventy five:seventy five)   INTEGER EXTERNAL,

 field9    POSITION (seventy six:86)   INTEGER EXTERNAL

Question 7. What Is The Sql*loader?

Answer :

SQL Loader is a device to lead information from record to a database desk.

SQL Database Tutorial SQL Database Interview Questions
Question 8. What Is The Difference Between The Conventional And Direct Path Loads?

Answer :

The direct direction load loads records at once into datafiles while conventional direction load uses general insert statements.
There are a few restrictions with direct path loads. The records loaded the usage of direct path does now not replicate.
Question nine. What Is The Difference Between The Sql*loader And Import Utilities?

Answer :

Import and SQL*Loader each can be used to load statistics in a database.
However, import works in combination with export and might read documents generated by export only.
SQL DBA Interview Questions
Question 10. Can You Load Data Into Multiple Tables At Once?

Answer :

Yes.

Question eleven. How You Improve The Performance Of Sql*loader?

Answer :

You can use direct route load to improve the performance.
Indexes and constraints make inserts slow. Removing indexes and constraints improve performance of inserts; and therefore, of SQL*Loader.
PL/SQL and Informatica Interview Questions
Question 12. How Can You Load Microsoft Excel Data Into Oracle?

Answer :

You can shop the records in text report with proper separators from Microsoft Excel.

PL/SQL Interview Questions
Question 13. Can You Skip Header Records While Loading?

Answer :

You can use the SKIP parameter to skip range of statistics. In addition, you can use SKIP = 1 to skip the header document.

Question 14. How Can You Load Multi Line Records?

Answer :

You can use the CONCATENATE or CONTINUEIF function to sign up for more than one bodily records to shape a unmarried logical file.
However, CONTINUEIF is used if a situation indicates that a couple of information need to be treateed as one. For example, a # character in the first column.
Question 15. How Can You Get Sql*loader To Commit Only At The End Of The Load File?

Answer :

You can not make certain a commit only at the cease of the weight report however you can boom the price of ROWS parameter to make certain the devote after positive variety of rows.

Oracle apps Interview Questions
Question sixteen. Can You Selectively Load Only Those Records That You Need?

Answer :

Yes, you could use the WHEN clause to specify the choice standards. However, it does no longer will let you use the OR clause; as an alternative, you can best use the AND clause.

Question 17. How Does Sql*loader Handles Newline Characters In A Record?

Answer :

SQL*Loader expects a record to be in a unmarried line; consequently, whenever it encounters a newline individual in a record, it treats the record as a new report and both throws an mistakes bases on the limitations of a table or inserts erroreous facts with out throwing any mistakes.

Oracle AOL (Application Object Library) Interview Questions