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
What are five advantages of a database?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
What is user and end user?
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????
What do you mean by query evaluation engine?
Explain atomicity and aggregation?
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.
What is the purpose of using a model?
Which database is best for storing large data?
Define object-oriented model.
When would you use a database?
what is datapump? Difference between exp and expdp?
2 Answers Capital IQ, TCS, WNS,