Database Partitioning

Database Partitioning interview questions

<<Previous  Next>> What is database partitioning? Database partitioning involves dividing logical database into distinct independent units to improve its performance, manageability and availability. Explain how is partitioning an important part of database optimization. <<Previous  Next>> Also read Describe in brief Databases and SQL Server Databases Architecture. Answer - A database is a structured collection of data. Database can be thought as simple data file...... Define Normalization and De- Normalization. Answer - It is the process of organizing data into related table. To normalize database, we divide database into tables..... Define transaction and transaction isolation levels. Answer - A transaction is a set of operations that works as a single unit. The ransactions can be categorized into explicit, autocommit, and implicit.... Define Truncate and Delete commands. Answer - Truncate command is used to remove all rows of the column.The removed records are not recorded in the transaction log...... Write your comment - Share Knowledge and Experience