Which of the following is not modification of the database?Select one:a.Deletionb.Sortingc.Insertiond.Updating
Question
Which of the following is not modification of the database?Select one:a.Deletionb.Sortingc.Insertiond.Updating
Solution
The answer is b. Sorting. Sorting a database does not modify it, it only changes the order in which the data is displayed. Deletion, insertion, and updating all involve changing the data in some way, so they are considered modifications.
Similar Questions
Which SQL statement is used to update data in a database?Question 15Answera.UPDATEb.SETc.CHANGEd.MODIFY
Consider the following database table:PartNo Description CustID Name QuantityOrdered2361 Pens 7810 J. Smith 222371 Paper Clips 7810 J. Smith 10002914 Pens 7914 K. Jones 900If we were to delete the third row, all information about customer 7914 would be lost. Which of the following is this an example of?Select one:a.A deletion anomalyb.An update anomalyc.An insertion anomalyd.A modification anomal
Which Java statement is used to update data in a database table?Question 5Answera.ALTER TABLEb.UPDATEc.MODIFYd.CHANGE
2. Describe the differences between the SQL UPDATE and DELETE statements. When would you use one over the other, and what precautions should be taken?
________________ is a unit of program execution that accesses and updates different data items in the database.a)Updationb)Insertionc)Manipulationd)Deletione)Transaction
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.