Explain the way to shrink a Database
Explain the way to shrink a Database?
Expert
This has historically been difficult to shrink any database except tempdb (since it is created fresh each boot time). The two ways commonly used have been:
1. Make sure that you have scripts for all your objects (several tools like SA Companion, dbschema.pl or DB Artisan from Sybperl can create scripts by an existing database), then bcp out your data, drop that database, recreate this smaller and run your scripts, as well as bcp in your data.
2. Utilize a third-party tool such as DataTool's SQL Backtrack, that in essence automates the first process.This technote draws a third possibility which can work in most cases.
Write down the employ of incremental aggregation?
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
What is Database testing?
Explain what are new in the BO 5.1?
Explain how the Chasm trap is solved?
Categorize the Hashing Functions based on the different methods through which the key value is found?
Describe briefly the difference between pessimistic locking and optimistic locking?
Define the term File Manager and Storage Manager in relational database management system.
Write down the level of Granularity of a fact table?
Define the term DataStage?
18,76,764
1928384 Asked
3,689
Active Tutors
1460415
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!