Skip to content


DBMS/U5 Topic 2 DBMS Object

A database object is any defined object in a database that is used to store or reference data.Anything which we make from create command is known as Database Object.It can be used to hold […]

DBMS/U5 Topic 3 Basic Database Administration

Database administration refers to the whole set of activities performed by a database administrator to ensure that a database is always available as needed. Other closely related tasks and roles […]

DBMS/U5 Topic 4 Remote Data Access

Remote database access (RDA) is a protocol standard for database access. Despite early efforts to develop proof of concept implementations of RDA for major commercial RDBMSs (including Oracle, Rdb, NonStop […]

DBMS/U4 Topic 1 Data Mining

There is a huge amount of data available in the Information Industry. This data is of no use until it is converted into useful information. It is necessary to analyze […]

DBMS/U4 Topic 2 Data Warehousing

The term “Data Warehouse” was first coined by Bill Inmon in 1990. According to Inmon, a data warehouse is a subject oriented, integrated, time-variant, and non-volatile collection of data. This […]

DBMS/U3 Topic 11 Oracle- Package

PL/SQL package is a logical grouping of a related subprogram (procedure/function) into a single element. A Package is compiled and stored as a database object that can be used later. […]

DBMS/U3 Topic 10 Oracle – Functions

A function is a subprogram that is used to return a single value. You must declare and define a function before invoking it. It can be declared and defined at […]

DBMS/U3 Topic 9 Oracle- Procedures

A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method or a third-generation language routine […]

DBMS/U3 Topic 8 Oracle- Triggers

Triggers are stored programs that are fired automatically when some events occur. The code to be fired can be defined as per the requirement. Oracle has also provided the facility […]

DBMS/U3 Topic 7 Oracle – Cursor

A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or DML statements like INSERT, UPDATE, DELETE or MERGE. Cursor is […]

DBMS/U3 Topic 6 Oracle – Indexes & Sequences

Unique and Nonunique IndexesUnique indexes guarantee that no two rows of a table have duplicate values in the key column (or columns).For performance reasons, Oracle recommends that unique indexes be […]

DBMS/U3 Topic 4 Oracle- Inserting Rows

In Oracle, INSERT statement is used to add a single record or multiple records into the table. Syntax: (Inserting a single record using the Values keyword): INSERT INTO table   (column1, column2, … column_n )   VALUES (expression1, expression2, … expression_n );    […]