DBMS: Terminology & Concepts
DDL stands for Data Definition Language, which works on database schemas and descriptions, of how the data should be stored in the database.
- CREATE: to create a database and its objects
- ALTER: alters the structure of the existing database
- DROP: delete objects from the database
- TRUNCATE: remove all records from a table
- COMMENT: add comments to the data dictionary
- RENAME: rename an object
DML stands for Data Manipulation Language which deals with data manipulation and is used to store, modify, retrieve, delete and update data in a database.
- SELECT: retrieve data from a database
- INSERT: insert data into a table
- UPDATE: updates existing data within a table
- DELETE: Delete all records from a database table
- MERGE: UPSERT operation (insert or update)
- CALL: call a PL/SQL or Java subprogram
- EXPLAIN PLAN: interpretation of the data access path
- LOCK TABLE: concurrency Control
Video Courtesy: Dr. Andy Wicks Youtube Channel
Computer Basics Quiz No.1
Computer Basics Quiz No.2
Computer Basics Quiz No.3
Computer Basics Quiz No.4
Computer Basics Quiz No.5
MS Word Quiz
Online Quizzes with Certificate
also read:
HTML | DATA STRUCTURE |
DBMS | REASONING |
C PROGRAM | APTITUDE |
E-LEARNING |