Name two utilities that Oracle provides, which are use for backup and recovery?
Submitted by: AdministratorAlong with the RDBMS software, Oracle provides two utilities that you can use to back up and restore the database. These utilities are Export and Import.
The Export utility dumps the definitions and data for the specified part of the database to an operating system binary file. The Import utility reads the file produced by an export, recreates the definitions of objects, and inserts the data
If Export and Import are used as a means of backing up and recovering the database, all the changes made to the database cannot be recovered since the export was performed. The best you can do is recover the database to the time when the export was last performed.
Submitted by: Administrator
The Export utility dumps the definitions and data for the specified part of the database to an operating system binary file. The Import utility reads the file produced by an export, recreates the definitions of objects, and inserts the data
If Export and Import are used as a means of backing up and recovering the database, all the changes made to the database cannot be recovered since the export was performed. The best you can do is recover the database to the time when the export was last performed.
Submitted by: Administrator
Read Online RDBMS Job Interview Questions And Answers
Top RDBMS Questions
☺ | What is VDL (View Definition Language)? |
☺ | Difference between controlled and uncontrolled redundancy? |
☺ | What is RDBMS KERNEL? |
☺ | What is SDL (Storage Definition Language)? |
☺ | What is 5NF? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |