What is the purpose of the IMPORT option IGNORE?

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

(Continued from previous question...)

What is the purpose of the IMPORT option IGNORE? What is it?s default setting?

Level: Low
Expected Answer: The IMPORT IGNORE option tells import to ignore "already exists" errors. If it is not specified the tables that already exist will be skipped. If it is specified, the error is ignored and the tables data will be inserted. The default value is N.

(Continued on next question...)

Other Job Interview Questions

• How to remove duplicate records from a table?
• Explain materialized views and how they are used.
• A tleast how many set of data must a data model have before a data model can be base on it?
• Can a repeating frame be created without a data group as a base?
• You have just compiled a PL/SQL package but got errors, how would you view the errors?
• How will you copy the structure of a table without copying the data?
• Is it possible to insert comments into sql statements return in the data model editor?
• What is the mechanism provided by ORACLE for table replication?
• What is the use of FILE option in IMP command?
• How can we reduce the network traffic?
• More...