Technical Discussion :: DBMS
Home > Freshers > Technical Interview Questions > DBMS
108. What is extension and intension?
Answer:
The description of data base is called in tension or database schema,which is specified during database design and is not expected to change frequently.
The actual data in a database may change quite frequently.The data in a database at a particular moment in time is called a extension or database state or snapshot.
Source:- Extension and intension
Asked In :: Accenture
Extension : It is the number of tuples present in a table at any instance. This is time dependent.
Intension : It is a constant value that gives the name, structure of the table and the constraints laid on it.
Intension : It is a constant value that gives the name, structure of the table and the constraints laid on it.
The description of data base is called in tension or database schema,which is specified during database design and is not expected to change frequently.
The actual data in a database may change quite frequently.The data in a database at a particular moment in time is called a extension or database state or snapshot.
Source:- Extension and intension