Explain the way to swap a db device along with other
Explain the way to swap a db device along with other.
Expert
Now there are four approaches. Before attempting any of the given: Backup, Backup and Backup.
Dump and Restore
1. Backup the databases upon the device drop the devices, drop the databases.2. Rebuild the newly devices.3. Rebuild the databases (ensure you recreate the fragments correctly - for a sp which helps you do this while you have lost your notes. Failure to do it will possibly lead to data upon log segments and log on the data segments).4. Reload that database dumps!
For only brave experts handle the Data Dictionary-
1. Shut down the server.2. Do a physical dump (by using dd(1), or that utility) of the device to be moved.3. Load the dump to newly devices4. Edit the data dictionary that is sysdevices.physname, to point to the new device.
Is it possible that Table Partitioning Require User-Defined Segments in the Sybase?
Explain the term Contexts?
Explain what is meant by the term catalog and its types in the cagonos?
Specify the options in the target session of the update strategy transformation?
Explain all the types of Jobs you developed?
Name the triggers which support SQL Server 2000?
Write a short note on the differences between vertical and horizontal portioning?
Write a brief note on the market basket analysis?
Identify those statements are true about a foreign key?
Clarify briefly why dimension tables is de-normalized in the nature?
18,76,764
1932409 Asked
3,689
Active Tutors
1435368
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!