Answer Posted / pramod singh
DML means data manupulation language
dcl means data control language
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain what is the main purpose of having conversation group?
What is the process of indexing?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
whats the maximum size of view state??
Difference between group by clause and having clause in SQL?
Explain in details security in SQL azure?
What are the differences between lost updates and uncommitted dependencies?
What is sql server transaction log file?
Does windows server 2016 come with sql server?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What are the types of processing and explain each? : sql server analysis services, ssas
Do you know what is lock escalation?
What are orphan records?
How to move database physical files in ms sql server?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas