Category: DBMS

PL/SQL architecture defines how the PL/SQL blocks are executed in Oracle. Oracle provides PL/SQL engine that executes the Procedural Language part of a block. When an application program or a…

DBMS PL/SQL

An important aspect of database systems is creation of external schemas for different users and their needs. These are also known as external views for users. One way of doing…

DBMS SQL

DBMS SQL

DBMS SQL

DBMS

DBMS

In database systems many times you need to summarize the data stored in tables in answer to adhoc queries of the users. For this SQL Aggregate Functions can be used.…

DBMS

Why Database Recovery Techniques are important?

Database are prone to failures due to inconsistency, network failure, errors or any accidental damage. Reliable database recovery techniques are highly important to bring a database back into a working state after a failure. Recovery includes the procedures of restoring database to the earlier and previously existing condition.

DBMS