Below are some important Memory Management interview questions which are asked in most MNC company interviews for beginners or professionals.
51. What is the use of OWNER option in EXP command?
List of table accounts should be exported.
52. What is the use of TABLES option in EXP command?
List of tables should be exported.
53. What is the use of RECORD LENGTH option in EXP command?
Record length in bytes.
54. What is the use of INCTYPE option in EXP command?
Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL
55. 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.
56. 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.
57. What is the use of INDEXES option in IMP command?
A flag to indicate whether import should import index on tables or not.
58. What is the use of GRANT option in IMP command?
A flag to indicate whether grants on database objects will be imported.
59. What is the use of SHOW option in IMP command?
A flag to indicate whether file content should be displayed or not.
60. What is the use of FILE option in IMP command?
The name of the file from which import should be performed.
61. What is use of LOG (Ver 7) option in EXP command?
The name of the file which log of the export will be written.
51. What is the use of OWNER option in EXP command?
List of table accounts should be exported.
52. What is the use of TABLES option in EXP command?
List of tables should be exported.
53. What is the use of RECORD LENGTH option in EXP command?
Record length in bytes.
54. What is the use of INCTYPE option in EXP command?
Type export should be performed COMPLETE,CUMULATIVE,INCREMENTAL
55. 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.
56. 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.
57. What is the use of INDEXES option in IMP command?
A flag to indicate whether import should import index on tables or not.
58. What is the use of GRANT option in IMP command?
A flag to indicate whether grants on database objects will be imported.
59. What is the use of SHOW option in IMP command?
A flag to indicate whether file content should be displayed or not.
60. What is the use of FILE option in IMP command?
The name of the file from which import should be performed.
61. What is use of LOG (Ver 7) option in EXP command?
The name of the file which log of the export will be written.
More Questions & Answers :-
No comments:
Post a Comment