Category: DBMS LAB

0

EX.NO: 4.d     CREATION OF INDEXES

Aim: To create the indexes on the attributes for fast retrieval of records. Description Indexes are special lookup tables that the database search engine can use to speed up data retrieval. An index helps speed...

0

Ex.No: 4.c SEQUENCES

Aim : To create and use the sequences for auto-numbering. Description: The Oracle SEQUENCE function allows you to create auto-numbering fields by using sequences. An Oracle sequence is an object that is used to generate...

0

EX.NO: 4.b CREATION OF SAVEPOINT

Aim: To create and execute the savepoint and rollback commands. Description Savepoint: savepoint marks and saves the current point in the processing of a transaction. When a savepoint is used with a rollback statement, parts...

0

Ex.No: 4.a    CREATION OF VIEWS

Aim: To create an updatable view and read only view on different tables. PROCEDURE * A view created using already existing table. * If there is any updation or insertion is performed in existing table,the...

0

EX.No: 3   CONSTRAINTS

AIM To work on various constraints in DBMS CONSTRAINTS Constraints are part of the table definition that limits and restriction on the value entered into its columns. TYPES OF CONSTRAINTS: 1) Primary key 2) Foreign...

0

Ex:no:2 Data Manipulation Language

Aim: To perform insertion, deletion, modification of records based on some conditions and to execute the DCL and TCL commands Insert command: Insert command is used to insert single or multiple rows in the table....

0

Ex: NO:1 SQL QUERIES FOR CREATION OF DATABASE

Aim: To execute the queries to create and alter the schema of the database. Data Definition in SQL Creating Tables: The SQL command for creating an empty table has the following form: Syntax: create table...

0

PREREQUISITES FOR THE DBMS LAB

The prerequisites of the lab are: 1. Oracle-Sql 2. Visual Basic 6.0 SQL:          In relational database systems (DBS) data are represented using tables (relations). A query issued against the DBS also...