What is the difference between the SQL*Loader an

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

54. What is the difference between the SQL*Loader and IMPORT utilities?

These two Oracle utilities are used for loading data into the database. The difference is that the import utility relies on the data being produced by another Oracle utility EXPORT while the SQL*Loader utility allows data to be loaded that has been produced by other utilities from different data sources just so long as it conforms to ASCII formatted or delimited files.

(Continued on next question...)

Other Job Interview Questions

• Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why?
• What are the built-ins used for Getting cell values?
• What is the “LOV of Validation” Property of an item? - What is the use of it?
• What is a DBA?
• What other parts of your organization do you interact with and how?
• How would you change all occurrences of a value using VI?
• What is a SQL * NET?
• Does a grouping done for objects in the layout editor affect the grouping done in the data model editor?
• Name a tablespace automatically created when you create a database.
• What are the basic element of Base configuration of an oracle Database?
• More...