-
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.
Oracle Memory Management Interview Questions
Ans