|
INTERVIEW QUESTIONS
DATABASE
SQL SERVER
DETAILS
Question: What is SQL*Loader?
Answer: The SQL Loader is bulk loader utility which is used to move the data from a external file to database.One can use load data into database using sqlldr .
Ex:-
load data
infile 'C:
ahul.csv' into emp table
field are tarminated by "," optionaly inclose by' " ' (empnao,name,id,sal)
|
|
|
Category |
SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7762 users |
Added on |
7/25/2011 |
Views |
69134 |
Rate it! |
|
|
Question:
What is SQL*Loader?
Answer:
The SQL Loader is bulk loader utility which is used to move the data from a external file to database.One can use load data into database using sqlldr .
Ex:-
load data
infile 'C:
ahul.csv' into emp table
field are tarminated by "," optionaly inclose by' " ' (empnao,name,id,sal)
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 |
|
Difference between "VARCHAR" and "VARCHAR2" datatypes.
|
- SQL Server Interview Questions & Answers">
View Answer
|
|
What is the difference among "dropping a table”,” truncating a table" and deleting all records" from a table.
|
View Answer
|
|
Difference between "ORACLE" and "MICROSOFT ACCESS" databases.
|
- SQL Server Interview Questions & Answers">
View Answer
|
|
How to create a database link?
|
View Answer
|
|
What's the use of SQL Profiler?
|
View Answer
|
|
What is the use of database index (apart from fast searching of records);What is use of composite key ?
|
View Answer
|
|
What is SQL*Loader? Difference between
|
View Answer
|
|
What is the maximum value that can be stored for a datetime field?
|
View Answer
|
|
How to find out duplicate records in sql server.
|
View Answer
|
|
How many column maximum we can add in one table and how many foreign key maximum we can use in one table
|
View Answer
|
|
What is the code to create a table having a column named DATE, which takes date in the format dd/mm/yyyy, in SQL Server2000? Or any format of date.
|
View Answer
|
|
Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employye table and department table with employee having department no.
|
View Answer
|
|
Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause
|
View Answer
|