Рет қаралды 542
DDL
DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
CREATE - to create database and its objects like (table, index, views, store procedure, function and triggers)
ALTER - alters the structure of the existing database
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
COMMENT - add comments to the data dictionary
RENAME - rename an object
DML
DML is short name of Data Manipulation Language which deals with data manipulation, and includes most common SQL statements such SELECT, INSERT, UPDATE, DELETE etc, and it is used to store, modify, retrieve, delete and update data in database.
SELECT - retrieve data from the 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
DCL
DCL is short name of Data Control Language which includes commands such as GRANT, and mostly concerned with rights, permissions and other controls of the database system.
GRANT - allow users access privileges to database
REVOKE - withdraw users access privileges given by using the GRANT command
TCL
TCL is short name of Transaction Control Language which deals with transaction within a database.
COMMIT - commits a Transaction
ROLLBACK - rollback a transaction in case of any error occurs
SAVEPOINT - to rollback the transaction making points within groups
SET TRANSACTION - specify characteristics for the transaction.
If you’ve enjoyed this video. Like and Subscribe to my channel for more similar informatica interview videos and tutorials.
Got any questions about informatica interview? Ask me in the comment section below.
------------------------------
Why should you watch my channel?
Informatica is the market leader in the ETL segment. I am working as senior ETL developer for 10+ years in North Carolina, USA and want to help and share realtime and scenario based tutorial to prepare for interview.
Who should watch this video?
If you are fresher or already working but looking to refresh SQL, Informatica, ETL, Data warehousing concepts for interview.
For more Information:
Please visit my other platforms.
Website: www.informaticainterview.com
LinkedIn: www.linkedin.com/in/informatica-interview-prep
Or contact me by email: informaticainterviewhelp@gmail.com