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.
Illustrates the difference between a file server and database server?
Explain the two in order to importing users & groups from the supervisor?
Give brief introduction of the term breakpoint in SSIS?
Briefly explain the Dashboard in the business intelligence?
Explain the command line functions which export and import the DS jobs?
Write down the differentiation between view and materialized view?
Define the term data aggregation?
Why not the PHENIX, the Zelinka or Otwinoski libraries and so forth?
How to handle decimal places while importing a flatfile in informatica?
In Sybase illustrates the term Table Partitioning?
18,76,764
1947811 Asked
3,689
Active Tutors
1432278
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!