.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Interview Question >> Sql Server >> Post New Question Subscribe to Interview Questions

what are the methods of moving data

Posted By :parthiban     Posted Date :July 27, 2010    Points :10   Category :Sql Server 
There are different methods of moving data

(1)BACKUP and RESTORE
(2)detaching
(3)Attaching databases
(4)Replication
(5) DTS
(6)BCP
(7)logshipping
(8) INSERT...SELECT
(9)SELECT...INTO
(10) creating INSERT scripts to generate data.

You can also find related Interview Question to what are the methods of moving data  below: 

What are different switching methods used by a switch to send data?

  
Switch adopts two methods foe sending data,

Cut Through Switching:-
In this method of switching data frames are send to the destination computer without error and integrity checking.

Store and Forward Switching:-
In this method the switch sends the data frames after receiving all the frames well as after error and integrity checking. (More...)

Which of the following methods is used to collect and interpret data from end users to design an application. ?

  
1, Coherence
2, Contextual design
3, Participatory design
4, Ethnography

Answer : 2 (More...)

Which of the following methods is used to collect and interpret data from end users to design an application?

  
1, Coherence
2, Contextual design
3, Participatory design
4, Ethnography

Answer : 1
(More...)

What are basic methods of Data adapter?

  
Fill :- Executes the SelectCommand to fill the DataSet object with data from the data source. It an also be used to update (refresh) an existing table in a DataSet with changes made to the data in the original datasource if there is a primary key in the table in the DataSet.
FillSchema :- Uses the SelectCommand to extract just the schema for a table from the data source, and creates an empty table in the DataSet object with all the corresponding constraints.
Update:- Calls the respective InsertCommand, UpdateCommand, or DeleteCommand for each inserted, updated,or deleted row in the DataSet so as to update the original data source with the changes made to the content of the DataSet. This is a little like the UpdateBatch method provided by the ADO Recordset object, but in the DataSet it can be used to update more than one table. (More...)

What is Method used to bind the data into gridview ?

  
DataBind() Method used to bind the data into gridview (More...)

What is the .NET that allows the retrieval of data by a unique key?

  
HashTable is the .NET collection class that allows the retrieval of data by a unique key (More...)

What is managed code and managed data?

  
Managed code is code that is written to target the services of the Common Language Runtime (see What is the Common Language Runtime?). In order to target these services, the code must provide a minimum level of information (metadata) to the runtime. All C#, Visual Basic.NET, and _JScript.NET code is managed by default. Visual Studio.NET C++ code is not managed by default, but the compiler can produce managed code by specifying a command-line switch (/CLR).
Closely related to managed code is managed data-data that is allocated and de-allocated by the Common Language Runtime's garbage collector. C#, Visual Basic, and _JScript.NET data is managed by default. C# data can, however, be marked as unmanaged through the use of special keywords. Visual Studio.NET C++ data is unmanaged by default (even when using the /CLR switch), but when using Managed Extensions for C++, a class can be marked as managed by using the __gc keyword. As the name suggests, this means that the memory for instances of the class is managed by the garbage collector. In addition, the class becomes a full participating member of the .NET Framework community, with the benefits and restrictions that brings. An example of a benefit is proper interoperability with classes written in other languages (for example, a managed C++ class can inherit from a Visual Basic class). An example of a restriction is that a managed class can only inherit from one base class. (More...)

What is data structure?

  
A data structure is a way of organizing data that considers not only the items stored, but also their relationship to each other. Advance knowledge about the relationship between data items allows designing of efficient algorithms for the manipulation of data. (More...)

List out the areas in which data structures are applied extensively?

  
1.Compiler Design,
2.Operating System,
3.Database Management System,
4.Statistical analysis package,
5.Numerical Analysis,
6.Graphics,
7.Artificial Intelligence,
8.Simulation (More...)

Quick Links For Interview Questions Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net  
Sql Server   SharePoint   Silverlight   OOPs   JQuery   JavaScript/VBScript
Biztalk Patten/Practices .IIS WCF WPF WWF
Networking Aptitude Others   All      

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

 
Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.


Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend