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.
Answer - A database is a structured collection of data.
Database can be thought as simple data file......
Answer - It is the process of organizing data into related
table. To normalize database, we divide database into tables.....
Answer - A transaction is a set of
operations that works as a single unit. The ransactions can be categorized into
explicit, autocommit, and implicit....
Truncate command is used to remove all rows of the column.The removed records
are not recorded in the transaction log......