Utilities of Oracle utilize for backup and recovery
What are the utilities Oracle gives, which are utilize for backup and recovery?
Expert
With the relational database management system software, Oracle gives two utilities that you can use to back up and restore the database. such utilities are as Export and Import.
Export:
This utility dumps the definitions and data for the given part of the database to an operating system binary file.
Import:
This utility reads the file produced through an export, recreates the descriptions of objects, and then inserts the data
When Export and Import are used like a means of backing up and recovering the database, every changes made to the database can’t be recovered when the export was performed. The most excellent you can do is recovering the database to the time while the export was previous performed.
State the difference between OLTP and OLAP?
What do you understand by the term foreign key in DBMS, and why is it employed for?
Explain the term Vdisk and how this will communicate along with physical data storage at the time of data retrieval by AMP?
Illustrates the term data structure node class?
Illustrate in brief some of the products of the Sybase?
Provide a brief differentiation between independent and dependent data warehouse?
Illustrates the term Table Partitioning in detail? Answer: If you wish for to decrease page contention you do not require multiple devices. You should use multiple d
Describe truncate commands.
State the benefits of the Business Objects over the other DSS?
Describe the inconsistent values problem? Comprise an appropriate example?
18,76,764
1947079 Asked
3,689
Active Tutors
1440033
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!