|
INTERVIEW QUESTIONS
ORACLE
ORACLE ARCHITECTURE
DETAILS
Question: What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file
Answer: SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads.
When a control file is fed to an SQL*Loader, it writes messages to the log file, bad rows to the bad file and discarded rows to the discard file.
Control file The SQL*Loader control file contains information that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc. controlfile.sql should be used to generate an accurate control file for a given table.
Log File The log file contains information about the SQL*loader execution. It should be viewed after each SQL*Loader job is complete.
|
|
|
Category |
Oracle Architecture Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 6709 users |
Added on |
8/27/2014 |
Views |
68433 |
Rate it! |
|
|
Question:
What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file
Answer:
SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. SQL*Loader supports various load formats, selective loading, and multi-table loads.
When a control file is fed to an SQL*Loader, it writes messages to the log file, bad rows to the bad file and discarded rows to the discard file.
Control file The SQL*Loader control file contains information that describes how the data will be loaded. It contains the table name, column datatypes, field delimiters, etc. controlfile.sql should be used to generate an accurate control file for a given table.
Log File The log file contains information about the SQL*loader execution. It should be viewed after each SQL*Loader job is complete. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Explain SGA memory structures: Shared Pool, Database buffer Cache, Redo log Cache, Large Pool Java Pool.
|
View Answer
|
|
Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment.
|
View Answer
|
|
What is the function of SMON?
|
View Answer
|
|
Describe Oracle architecture in brief.
|
View Answer
|
|
What is the differnece between materialized view and snapshot
|
View Answer
|
|
What are the Large object types supported by Oracle?
|
View Answer
|
|
What is the diff b/w BTREE INDEX and BITMAP INDEX
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Oracle Architecture Interview Questions & Answers - Exam Mode /
Learning Mode
|