Set - 4

Question 46 :

What is the use of FULL option in EXP command ?

Answer :

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


Question 47 :

What is the use of SHOW option in IMP command ?

Answer :

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


Question 48 :

What is the use of CONSTRAINTS option in EXP command ?

Answer :

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


Question 49 :

What is the use of CONSISTENT (Ver 7) option in EXP command ?

Answer :

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


Question 50 :

What are the different methods of backing up oracle database ?

Answer :

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