Database Basic Terminology

Database Basic Terminology

1) Database :- Database is a collection of schemas
2) Schema :-  Collection of objects under one user is called its schema.
3) Instance :- Instance is a memory architecture of Oracle Database.It is also known as SGA (System Global Area). More than one databases can be configured under one instance.
4) RDBMS :- RDBMS is a software which can manage relation database.
5) Transaction :- Collection set of statements between login to TCL command or between any two TCL commands.
6) Table:-Table is the basic unit for storing data. Table is a structure with collection of columns.