Author Archives: Sumit Thakur - Page 4
DATABASE RECOVERY IN DBMS AND ITS TECHNIQUES
DATABASE RECOVERY IN DBMS AND ITS TECHNIQUES: There can be any case in database system like any computer system when database failure happens. So data stored in database should be…
Set Operations In SQL With Examples: UNION, UNION ALL, INTERSECT, MINUS
Set Operations In SQL With Examples: The set operators are availed to combine information of similar type from one or more than one table. The set operators look similar to…
SQL Server CONSTRAINTS With Examples
SQL Server CONSTRAINTS With Examples: Constraints are the principles enforced on the information columns of a table. This ensures the accuracy and dependability of the information within the info. SQL…
Different Sql Functions With Examples
Different Sql Functions With Examples: Functions are used to perform actions on a single value or a table. Functions accept values, take action on it and then give desired results.…
Explain Data Manipulation Language (DML) with Examples in DBMS.
Explain Data Manipulation Language (DML) with Examples in DBMS.: Data Manipulation Language (DML) can be defined as a set of syntax elements that are used to manage the data in…
Explain Data Control Language (DCL) with Examples in DBMS
Explain Data Control Language (DCL) with Examples in DBMS: A Data Control Language (DCL) can be defined as a computer language that is used for controlling privilege in the database.…
Data Definition language (DDL ) in DBMS with Examples
Data Definition language(DDL) in DBMS with Examples: Data Definition Language can be defined as a standard for commands through which data structures are defined. It is a computer language that…
What is SQL, its Applications, Advantages and Disadvantages?
SQL fully abbreviated as Structured Query Language can be defined as a domain-specific language used to manage the relational databases and performs different operations on the data stored in them.…
B-TREE Indexing in DBMS: Why we use B-Tree
B-TREE Indexing in DBMS With PDF: Before we proceed to B-tree indexing lets understand what index means. An Index can be simply defined as an optional structure associated with a…
Explain DBMS Transactions
Explain DBMS Transactions: Transaction management is a very interesting and important concept in DBMS as it is related to our daily life. We withdraw the amount, deposit the cash, also…