Articles by Team EasyExamNotes

Team EasyExamNotes

Framing

by

To provide service to the network layer, the data link layer must use the service provided to it by the physical layer. As seen in … Read more

Oracle cursor

by

What is Cursor ? Cursor is a pointer in memory area called context area. What is context area ? Context area is a memory area … Read more

Trigger

by

What is Trigger ? A trigger is defined as an action taken by database when some database related events occur. Triggers are implicitly fired by … Read more

SQL Functions

by

Five Important aggregate functions are SUM, AVG, MIN, MAX and COUNT. They are called aggregate functions because they summarize the results of a query, rather … Read more

SQL Join

by

A SQL Join statement is used to combine data or rows from two or more tables based on a common field between them. Different types … Read more

RDBMS

by

A DBMS based on relational model is called relational database management system or RDBMS.RDBMS uses relational structures to store data. A relation is also called … Read more

OODBMS vs RDBMS

by

OODBMS RDBMS Stores data and methods Stores only data Main objective data encapsulation and data independence Main objective data independence Classes can be reorganized without … Read more

Serializability

by

What is Serializability ? Serializability is the concurrency scheme.  Serializability ensures that a schedule for executing concurrent transactions is equivalent to one that executes the … Read more