Which of the following is a requirement when merging modified data into a DataSet ?
Correct answer: C. A primary key must be defined on the DataTable objects
- A. The DataSet schemas must match in order to merge
- B. The destination DataSet must be empty prior to merging
- C. A primary key must be defined on the DataTable objects
- D. A DataSet must be merged into the same DataSet that created it.
Explanation
During a merge, a primary key lets ADO.NET match modified source rows with their corresponding destination rows instead of treating them as new rows. Matching schemas or an empty destination is not generally required.
Last updated
Practise Database Systems
49 free Database Systems MCQs from Software Engineering, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Exams that ask Software Engineering questions like this
Software Engineering is on this paper prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for it.
Related questions
A CD-RW disk ______________________?
A count of the number of students who earned A, B, C, D, and F grades in a given course would be an example of a(n) ?
A data item which is not broken down into smaller units is _____________________?
A data warehouse is which of the following ?
A file that includes an index directory to facilitate random access is__________________?