DEVFYI - Developer Resource - FYI

ORACLE Interview Questions and Answers

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36   37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99  100  101  102  103  104  105  106 

(Continued from previous part...)

342. What is the use of INDEXES option in IMP command ?

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


343. What is the use of GRANT option in EXP command?

A flag to indicate whether grants on databse objects will be exported or not. Value is 'Y' or 'N'.


344. What is the use of GRANT option in IMP command ?

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


345. What is the use of FULL option in EXP command ?

A flag to indicate whether full databse export should be performed.


346. What is the use of SHOW option in IMP command ?

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


347. What is the use of CONSTRAINTS option in EXP command ?

A flag to indicate whether constraints on table need to be exported.


348. 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.


349. What are the different methods of backing up oracle database ?

- Logical Backups
- Cold Backups
- Hot Backups (Archive log)


350. What is the difference between ON-VALIDATE-FIELD trigger and a POST-CHANGE trigger ?

When you changes the Existing value to null, the On-validate field trigger will fire post change trigger will not fire. At the time of execute-query post-change trigger will fire, on-validate field trigger will not fire.


351. When is PRE-QUERY trigger executed ?

When Execute-query or count-query Package procedures are invoked.

(Continued on next part...)

Part:   1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  34  35  36   37  38  39  40  41  42  43  44  45  46  47  48  49  50  51  52  53  54  55  56  57  58  59  60  61  62  63  64  65  66  67  68  69  70  71  72  73  74  75  76  77  78  79  80  81  82  83  84  85  86  87  88  89  90  91  92  93  94  95  96  97  98  99  100  101  102  103  104  105  106 

ORACLE Interview Questions and Answers