What is Index Organized Table (IOT)

Index-Organized Tables – Tables stored in an index structure are called as “Index-Organized Tables” (IOT). Unlike heap-organized tables, where data (rows) gets stored randomly at any available free space, the index-organized tables store the data sorted on the primary key. This organization does not make any change in the SQL though. Organization of a table […]

What is a DataBase Management System (DBMS)

What is DataBase Management Systems (DBMS) – A DataBase Management System is a most important part of any commercial data based application development. At very minimum it is know as a computer system application facilitating capturing, storing and manipulating the data. However for working professionals a comprehensive and scientific approach is required towards defining this […]

Definition of Database Terms For Campus Interview

DBMS – Collection of interrelated data and a set of programs to access those data. Data Abstraction – Abstraction are the methods (levels) to simplify users’ interactions with the database system by hiding the complexities of actual data storage and access methodologies. There are three levels of Data Abstraction. Physical Level – The lowest level […]