Category: DBMS

Data Definition Language (DDL) is used to specify or create database schema like new database or tables creation along with

Functional Dependency is a relationship between one attribute to another attribute in a Database. Typically, a non-key attribute is dependent

Entity  An Entity is a real-world object which may have a physical existence like any person, student, etc., or may

Concurrency Control in Database Management System is a  procedure of managing simultaneous operations without conflicting with each other. It is

SQL Commands stands for Structured Query Language Commands. In the era when massive volumes of data are generated, there is

Database Architecture Database Architecture is a representation of DBMS design. It uses programming languages to design a particular type of

Sr No. Delete Command  Truncate Command 1. It is a DML (Data Manipulation Language) command. It is a DDL (Data

Sr No. Intension Database Extension Database 1. .The intension corresponds to what is specified in the relational schema. The intension

Lock VSAM record-level sharing has multiple lock structures that are defined in the active storage management subsystem (SMS) configuration. The