Cold backup in case of Oracle
Illustrates the cold backup in case of Oracle?
Expert
Cold Backup:
This is copying the three sets of files as database files, control file and redo logs while the illustration is shut down. It is a straight file copy, generally from the disk directly to tape. You should shut down the case to guarantee a consistent copy.
While a cold backup is performed, the simply option obtainable in the event of data file loss is restoring each file from the latest backup. Each work performed upon the database when the last backup is lost.
Describe the difference between a regular sub query and a correlated sub query?
Distinguish between the query answering and direct query answering.
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Briefly explain the functional differentiations between COGNOs and BO?
Describe briefly the term ADO.NET?
Justify whether all the Business Objects users build the data providers?
Describe a surrogate key and also explain the ideal primary key and illustrate how surrogate keys meet up this ideal?
Write down the level of Granularity of a fact table?
What are the difficulties faced by the database developer during implementing pre compiled statements?
18,76,764
1925473 Asked
3,689
Active Tutors
1444782
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!