Select one of the answers to the multiple-choice question below, and write 100-2

Question

Select one of the answers to the multiple-choice question below, and write 100-200 words explaining why you believe this is the correct answer:

You are running a database for a University and need to perform regular updates on the database from an athletic association roster of students who are on sports teams. The roster can change week to week, and as such you need to have the data update once per week. Which method is best for bringing this new roster data into the tables within your database:

a) Upsert

b) Append

c) Drop & Replace

Explanation / Answer

Answer)

b) Append -- This is a very powerful tool which can help to query by combining the data's from different tables and perform the query with results.

To append a value is to first chevk if the value is present in the record, if not present then update.

If the value is present then append the new value with separation.

Hit like/ upvote if you find the answer useful. Your response is important to us and is much needed.

Hope this answer helps. Happy to help. :)

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.