Data Definition Language(Is the subset of SQL commands that change object definitions within the data dictionary) -for eg Create, Alter, Drop commands in Oracle
Data Manipulation Language(is a subset of DQl Commands that is used to change the data) – for eg Insert, Update, Delete commands in Oracle
Data Control Language(subset of SQL Command that control the access permisisions) – for eg Grant and Revoke commands in Oracle
DDL (Date Definition Language or Data Description – is a vocabulary used to define data structures in SQL. Use these statements to create, alter, or drop data structures in an instance of SQL Server.
DML (Date Manipulation Language) – is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data.
DCL (Date Control Language) – A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database. Examples of DCL commands include: GRANT to allow specified users to perform specified tasks.
DDL i data definition language – can be used to create or alter
DML is data management language – it is a method to manipulate tables like insert, update
DCL is data control language – it enables or disables access by using syntax such as grant or revoke
– Tomiwa
DDL:Data definition Language
Create, Alter, Drop, Truncate, Comment, Rename.
DML:
Data manipulation Laguage:
Select, insert, update, delete
Data Control Language:
Grant , Revoke.
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
March 13, 2015 at 2:25 pm
DDL is Data Definition Language.
DML is Data Management Language.
DCL is Data Control Language.
March 14, 2015 at 2:57 pm
Data Definition Language(Is the subset of SQL commands that change object definitions within the data dictionary) -for eg Create, Alter, Drop commands in Oracle
Data Manipulation Language(is a subset of DQl Commands that is used to change the data) – for eg Insert, Update, Delete commands in Oracle
Data Control Language(subset of SQL Command that control the access permisisions) – for eg Grant and Revoke commands in Oracle
March 21, 2015 at 8:28 pm
DDL (Date Definition Language or Data Description – is a vocabulary used to define data structures in SQL. Use these statements to create, alter, or drop data structures in an instance of SQL Server.
DML (Date Manipulation Language) – is a family of computer languages including commands permitting users to manipulate data in a database. This manipulation involves inserting data into database tables, retrieving existing data, deleting data from existing tables and modifying existing data.
DCL (Date Control Language) – A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database. Examples of DCL commands include: GRANT to allow specified users to perform specified tasks.
March 23, 2015 at 4:56 am
DDL is Data Definition Language.
DML is Data Management Language.
DCL is Data Control Language.
March 23, 2015 at 11:38 pm
ddl – ddata defination language
dml- data mangement language
dcl- data control langugae
March 24, 2015 at 6:56 pm
DDL i data definition language – can be used to create or alter
DML is data management language – it is a method to manipulate tables like insert, update
DCL is data control language – it enables or disables access by using syntax such as grant or revoke
– Tomiwa
March 28, 2015 at 6:37 pm
DDL:Data definition Language
Create, Alter, Drop, Truncate, Comment, Rename.
DML:
Data manipulation Laguage:
Select, insert, update, delete
Data Control Language:
Grant , Revoke.
August 23, 2015 at 8:51 pm
DDL means DAta Definition Language.
DDL commands are :
Create -Used to create a new database table
Alter – To modify an existing table by adding or deleting fields, or updating their field size etc.
Drop – To delete a table permanently with structure of the table also being deleted permanently.
Truncate – will delete the column(s) from the table permanently
DML – Data Modification Language
This is used to perform the various operations on the data within the table.
These are called CRUD operations.
Insert – Creates a record in a table.
Update – Updates an existing table with new values.
Delete – Deletes a record in a table based on a certain criteria to identify the record.
Select – To Read the data in the table and retrieve list of records matching a certain criteria which can help in reporting the data thus retrieved.
DCL – Data control Language – These commands help the Administrator to control the access for each database user.
Grant – willgive permissions for the user to access a database table.
Revoke – will remove the accessibility permissions for the user.
Navigation
Loading Questions
If you are facing any issue like can not see video so please login into Google with email what you forwarded to us Google Login or mail to administrator qatraining@infotek-solutions.com
Edit Profile