Important Computer Awareness Materials for IBPS Exams 2017 (Day-6)

Important Computer Awareness for IBPS Exams 2017 (Day-6) – DBMS Part-6:
Dear Readers, IBPS Exams are approaching shortly, we all knew that Computer Awareness is one of the important section, which will help you to increase your score easily.
Many of our followers were asking us to provide Important Computer Awareness Notes along with the model questions, here we have planned to provide the Topic wise Important Computer Awareness Materials on Daily basis, and also we will provide MCQs based on these topics daily. Kindly follow us regularly and make use of it.

Database Management Systems (DBMS) – PART 6

SQL (Structured Query Language):
·       Structured Query Language (SQL)is a widely-used programming language for working with relational databases.
·       SQL is specially designed programming language to regulate and manage the data stored in relational databases (RDBMS).
Sub division in SQL:
1. DDL (Data Definition Language):
   Defines structure of Database
2. DML (Data Manipulation Language):
   Data is been entered
3. DCL (Data Control Language):
    Data is been controlled
4. DQL (Data Query Language):
   Data is been retrieved/fetched
5. TCL (Transaction Control Language):
    About transactions
Data Definition Language (DDL):
The commands of DDL are:-
1. Create:A commonly used CREATE command is the CREATE TABLE command.
2. Alter:The ALTER statement modifies an existing database object.
3. Drop:The DROP statement destroys an existing database, table, index, or view.
4. Rename:The RENAME statement is used to rename a database table.
5. Truncate:The TRUNCATE statement is used to delete all data from a table. It’s much faster than DELETE.
Data Manipulation Language:
The commands of DML are:
1. SELECT:retrieve data from the database.
2. INSERT:insert data into a table.
3. UPDATE:update existing data within table.
4. DELETE:delete all records in the table,
5. MERGE:UPSERT operations (insert or update)
6. CALL: call a SQL or java program
7. LOCKTABLE:control concurrency
Data Control Language:
DCL used to control privilege in database.
To perform any operation in database, such as creating tables, sequences (or) views.
The commands of DCL are:
1. Grant:to allow specified users to perform specified tasks.
2. Revoke:to cancel previously granted or denied permissions.
Data Query Language:
It is the component of SQL statement that allows getting data from the database.
The command of DQL is:
1. Select:retrieve data from database.
Transaction Control Language:
Transaction Control Language (TCL) commands are used to manage transactions in database. These are used to manage the changes made by DML statements. It also allows statements to be grouped together into logical transactions.
 The commands of TCL are:
1. Commit:permanently save any transaction into database.
2. Rollback:restores the database to its last committed state.
3. Save point:temporarily save any transaction into database.
ONE LINER:
1. Defines structure of database:DDL
2. Data is fetched:DQL
3. Structure will be modified: ALTER
4. Data will be modified:UPDATE
5. Restores the database to its last committed state: ROLLBACK
6. Take back permissions: REVOKE
7. Temporarily save any transaction:SAVE POINT
8. Gives user access: GRANT
9. Data will be fetched is for :SELECT COMMAND