I have 2 tables with 1 million rows each.
I have updated 1 row in first and 1 million update on second table.
Now I commit both the updates. Which one will commit fast and Why?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Database Management Interview Questions

What are five advantages of a database?

0 Answers  


What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

0 Answers  


What is user and end user?

0 Answers  


1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

0 Answers  


What do you mean by query evaluation engine?

0 Answers  






Explain atomicity and aggregation?

0 Answers  


Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.

0 Answers  


What is the purpose of using a model?

0 Answers  


Which database is best for storing large data?

0 Answers  


Define object-oriented model.

0 Answers  


When would you use a database?

0 Answers  


what is datapump? Difference between exp and expdp?

2 Answers   Capital IQ, TCS, WNS,


Categories