Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 0 Answers
- 2621 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is system r?
What is trigger in dbms?
What is the purpose of a database?
What is database normalization? Explain types of it.
Explain the advantages of rdbms?
What is Library in Forms 4.0 ?
8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?
How can we tune if buffer busy wait issue comes in oracle?
What is the difference between SQL and NoSQL databases
What are database data types?
What do you understand by sub-queries in sql?
What is the use of Snapshot?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
