ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
syntax for deleting the database in T SQL
 Question Submitted By :: Renjusha
I also faced this Question!!     Rank Answer Posted By  
 
  Re: syntax for deleting the database in T SQL
Answer
# 1
drop <table name>;
 
Is This Answer Correct ?    1 Yes 6 No
Reshu Garg
 
  Re: syntax for deleting the database in T SQL
Answer
# 2
drop database <databasename>
 
Is This Answer Correct ?    7 Yes 0 No
Renjusha
 
 
 
  Re: syntax for deleting the database in T SQL
Answer
# 3
delete databasename
 
Is This Answer Correct ?    0 Yes 4 No
Kavithareddy
 
  Re: syntax for deleting the database in T SQL
Answer
# 4
drop database <databasename>
 
Is This Answer Correct ?    0 Yes 0 No
Jinesh
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What are the two types of concurrency?  2
what is the cursor life span? Evalueserve5
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables? Lason2
how can do you the system monitoring?  1
in emptable i want to retrive the name of employee whose name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc.  7
How can u convert the Date to String? TCS4
What is the difference between OLEDB and ODBC CFCI3
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...  2
What is difference beteen Migration and Upgrdation? Satyam4
Explain Trigger with an example?  1
How to Debug a Stored Procedure? Allianz4
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?  1
What is the basic difference between clustered and a non-clustered index?  3
What is a Trace frag?Where can we use this?  1
how to connect sybase to sql server 2005?. ABC1
1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"  6
Which virtual table does a trigger use?  3
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.  2
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
what is physical sort data and logical sort data in index?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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