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.
Specify the designer tools used for creating the tranformations?
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
Define the Linked List in data structure?
Explain the relationship between JDBC and Sybase.
Where is the GRANT table option usually done after creating tables dynamically within the Teardata? While tables are newly created, what are the default role and default privileges that get assigned?
Determine the concept of Relation Schema and a Relation?
Write a short on the six database functions which occur during the systems development life cycle?
Define the term visual data mining.
Explain how do I choose which Tables to Partition in the Sybase?
Explain the term iConv and oConv?
18,76,764
1949577 Asked
3,689
Active Tutors
1418921
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!