How can we write or define DDL statements in Sql server and DML statements

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

How can we write or define DDL statements in Sql server and
DML statements?

Question Submitted By :: Arijit Bhawal

I also faced this Question!!

Rank

Answer Posted By

Re: How can we write or define DDL statements in Sql server and DML statements?

Answer
# 1

Delete is DDL statement and Truncate is DML statement

Is This Answer Correct ?

2 Yes

2 No

Raju Vikram

Re: How can we write or define DDL statements in Sql server and DML statements?

Answer
# 2

DDl is a data defination language means we are defining 
like create is a DDL statement
Eg: create table Emp(name varchar(20),address varchar(40));

whereas DML is a Data Manipulation Language in which 
updations are made like
 update table Emp set name="Ravi" where name="Anil"

Is This Answer Correct ?

0 Yes

0 No

Simran_8185@rediff.com
[E-Business]

Question	Asked @	Answers
Other SQL Server Interview Questions


When do you use SQL Profiler?		2
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!		1
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement		2
WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?		5
What is normalization?		6
What is RAID and what are different types of RAID configurations?	Wipro	5
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?		3
What is the difference between DTS and SSIS?	Allianz	3
What is cursor ? And what is difference between Trigger ?	HCL	1
how to give input dynamically to a insert statement in sqlserver	HCL	2
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.	APX	2
how do u do Performance tunning ?	Satyam	1
why cluster and non clusterindex are used in sqlserver 2000? explain with example		1
how to get the rowid/rownumbes of a table in sqlserver	IBM	5
What is a Linked Server?		1
Explain basic SQL queries with SELECT from where Order By, Group By-Having?	Wipro	2
SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.		5
what are the problems in logshipping?		2
Explain some DBCC commands?		4
I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?		3

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com