Oracle Memory Management Interview Questions

What is the use of tables option in exp command ?

 list of tables should be exported.

What is the use of record length option in exp command ?

 record length in bytes.

What is the use of inctype option in exp command ?

 type export should be performed complete,cumulative,incremental.

What is the use of record option in exp command?

 for incremental exports, the flag indirects whether a record will be stores data dictionary tables recording the export.

What is the use of parfile option in exp command ?

 name of the parameter file to be passed for export.

What is the use of analyse ( ver 7) option in  exp command ?

 a flag to indicate whether statistical information about the exported objects should be written to export dump file.

What is the use of consistent (ver 7) option in  exp command ?

 a  flag  to indicate whether  a read consistent version of all the exported objects should be maintained. 

What is use of log (ver 7) option in  exp command ?

 the name of the file which log of the export will be written.

What is the use of file option in  imp command ?

 the name of the file from which import should be performed.

What is the use of show option in imp command ?

 a flag to indicate whether file content should be displayed or not.

What is the use of ignore option in imp command ?

 a flag to indicate whether the import should ignore errors encounter when issuing create commands.

What is the use of grant option in imp command ?

 a flag to indicate whether grants on database objects will be imported.

What is the use of indexes option in imp command ?

 a flag to indicate whether import should import index on tables or not.

What is the use of rows option in imp command ?

 a flag to indicate whether rows should be imported. If this is set to 'n' then only DDL for database objects will be executed.