adspace


Do you know data definition language, data control language and data manipulation language?

Answer Posted / Ashish Kumar Kaushal

Data Definition Language (DDL), Data Control Language (DCL), and Data Manipulation Language (DML) are categories of SQL commands used for managing and manipulating data in a database. DDL is used to create, alter, or delete database objects such as tables, views, indexes, and schemas. DCL is used to control access and permissions for these objects, and DML is used to retrieve, insert, update, or delete data stored within them.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1197


Can we shrink data file in sql server?

1128


What are different types of constraints?

1001


What is clustered index

1086


What is sql or structured query language?

1227


Why we use the openxml clause?

1079


What is a view in sql?

1040


What are the kinds of subquery?

1107


How do I find the sql server version?

1102


How to provide default values to function parameters?

1259


What is self contained sub query?

1140


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1023


What kind of problems occurs if we do not implement proper locking strategy?

1499


List out the different types of locks available in sql server?

1050


Is it possible to have clustered index on separate drive from original table location?

1040