Differential backups and SQL Server 2000
Describe the difference between differential backups and SQL Server 2000 complete?
Expert
A total backup creates a copy of the whole database. A differential backup creates a copy of the changes which have been made to the database as last complete backup. A complete backup must be completed before the first differential backup. Since the differential backups are much faster and they can be taken more often and chance of data loss is reduced. Complete backups take longer however are slightly simpler to employ for recovery.
Illustrates the term Merge Sort?
State difference between Passive and Active transformation?
Describe briefly the term SQL Server Analysis Services cubes?
What is meant by the Cardinality?What is meant by the Cardinality?
Write down the level of Granularity of a fact table?
Briefly describe the differentiation between data warehouse and OLAP?
What is Monopoly explain in brief?
Explain about the DBMS.
Describe the main characteristic of the database administrator?
18,76,764
1923400 Asked
3,689
Active Tutors
1432143
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!