Skip to main content

Database languages in DBMS| Explain with syntax - computer science fundamentals tutorial


Relational Database Management System languages and their commands


Database languages play an important role in Relational database management system. Database languages are used to read, update and store data in database. These database languages that can be used for this purpose one of them SQL.
Types of Database languages
There are five types of database language

 DDL: -Data Definition Language
DML: -Data Manipulation Language
DCL: -Data Control Language
SQL: -Structure Querying Language
TCL: -Transaction Control Language

         1)DDL(Data Definition Language):- Data Definition Language used for  specifying the data base ‘schema’. It is used for creating tables, schemas etc. in database. Commands of Data Definition Language(DDL) are given below
CREATE: - to create database instances. This commands use to create tables as follows:-
        
CRATE TABLE [name of table] ([definition of column]) [parameter of table]
                           
DROP: - to drop database instances. this command used to delete table or database and syntax is
            DROP type of object name of object

COMMENT: - to comment.

 ALTER: -to alter structure of database. this command used to modify properties  of database object. the syntax is
      ALTER  type of object     name of object

2)DML(Data Manipulation Language):-  Data Manipulation Language used for accessing and manipulating data in database. 
 Commands of Data Manipulation Language (DML) are

INSERT: - to insert record(s) into the table.
 UPDATE: - to update data into table.
 DELETE: - to delete record(s) into the table.
SELECT: -to read/retrieved record(s) from table.                                                         

         3)DCL( Data Control Language): -Data Control Language used for granting and revoking user access on a database. 
        Commands of  Data  Control Language(DCL) are given below

   GRANT: - to grant access to user.
  REVOKE: - to revoke access to user.

4)TCL( Transaction Control Language):- Transaction Control Languages are used to changes in the database that we made by using DML commands either performance or role backed by using TCL.  
Commands of Transaction Control Language(TCL) are given below


COMMIT: - to persist the changes made by DML command in database.
ROLL BACK: - to roll back the changes made to the database.


Labels:

Comments

Post a Comment

please subscribe my blog and let me suggest how I improve this site

Popular posts from this blog

type casting in C. - computer science fundamentals tutorial

Typecasting in C Typecasting is also known as "forced conversion". It refers to changing variable one data type to another data type.          Typecasting in can be certified into following two types: - 1) Implicit type casting. 2) Explicit type casting. Implicit type casting : - It is also known as "Automatic type conversion". It is done by compiler on its own without any external trigger from user. Generally takes place when in an expression more than one data type is present in such condition. Type conversion take places to avoid data lose. Example : - #include<stdio.h> main() {   char y = 'a';   int b = y; printf("%c",y); printf("%d",b); } Explicit Type casting : - This process also called 'Type casting' and it is user defined . Here the user can type cast the result to make it of particular data type. Example : - #include<stdio.h> main() { int m
Post a Comment
Read more

Important MCQ of RDBMS( Relational database management system)-FCST

Important MCQ of RDBMS  1. A RDBMS consists a collection of ? a. Tables b. Fields c. Records d. Keys  ANS/- a. table 2. The term attribute refers to a ___________ of a table a. Record b. Tuple c. Column d. Key   ans/- c. Column 3. In relational model, the row of table is known to be ?  a. Relation b. Entity field c. Tuple d. Attribute  ans/- C. Tuple 4. . Address field of a person should not be part of primary key, since it is likely to ? a. Dependent b. Too long c. Changed d. Not changed  ans/- c. Changed 5. The relational model is concerned with ? a. Data structure and Data integrity b. Data Manipulation c. Both a and b d. None of these  ans/- c. Both a and b 6. Which is the false statement from the following ? a. A veiw is a named derived table b. A name relation is variable c. A veiw is a named reation and is virtual d. None of these  ans/- d. None of these 7. The union of primary keys of the related entity sets becomes a
2 comments
Read more

Solve-write C program to find grade of student by using nested else-if statement

C program to find grade of student by using nested else-if statement Problem Description This program take input as your number then show your grade. Problem Solution 1. enter your marks as input. 2. then check your marks with 'If' block's condition. if it satisfied then show your grade as output. 3. if it not satisfied then it checks with all else-if block's condition repeatedly. 4. print the grade according to your given marks as input and exit. Program codes:-   #include<stdio.h> main() { int n; printf("\n enter the marks:"); scanf("%d",&n); if(n>89) printf("O"); else if(n>79) printf("E"); else if(n>69) printf("A"); else if(n>59) printf("B"); else if(n>49) printf("C"); else if(n>39) printf("D"); else printf("F"); } Program explanation:- 1. enter your marks. for example we take 70 .
Post a Comment
Read more