When we will Denormalize data?

Java database interview questions

(Continued from previous question...)

5. When we will Denormalize data?

Data denormalization is reverse procedure, carried out purely for reasons of improving performance. It maybe efficient for a high-throughput system to replicate data for certain data.

(Continued on next question...)

Other Interview Questions

• How do you call a Stored Procedure from JDBC?
• Is the JDBC-ODBC Bridge multi-threaded?
• Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
• What is cold backup, hot backup, warm backup recovery?
• When we will Denormalize data?
• What is the advantage of using PreparedStatement?
• What is a “dirty read”?
• What is Metadata and why should I use it?
• What are different types of Transaction Isolation Levels?
• What is 2-phase commit?
• How do you handle your own transaction ?
• What is the normal procedure followed by a java client to access the db.?
• What is a data source?
• What are collection pools? What are the advantages?
• How do you get Column names only for a table (SQL Server)?