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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 
How to delete an attribute from the emp table
 Question Submitted By :: Arun
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to delete an attribute from the emp table
Answer
# 1		 
we can directly ALTER OR DROP the column AND THEN COMMIT ON 
IT SO THAT IT GETS MODIFIED
 
Is This Answer Correct ?    1 Yes 0 No
Swetha
 
  Re: How to delete an attribute from the emp table
Answer
# 2		 
we can delete an attribute through delete command.
 
Is This Answer Correct ?    1 Yes 3 No
Ram Murthy
 
 
 
  Re: How to delete an attribute from the emp table
Answer
# 3		 
Using the DROP COMMAND-
See the eg below--

create table stup(roll int,name varchar,marks int)
insert into stup values(1,'A',10)
insert into stup values(2,'B',20)
select * from stup
Alter table stup drop column marks
select * from stup
 
Is This Answer Correct ?    4 Yes 0 No
Sonia
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?  1
how to delete duplicate rows from table CSC9
write the query for taking database restore in sql?  2
explain different types of jions with examples briefly? Zensar1
can foreign key take role of primary key? TCS4
when we use function instead of procedure? plz tell me the situation with ex?  1
When you first load SQL SERVER you will startup with what all databases? CompuSol3
Why Do you want to work in this company? HCL3
Can I remove the default constraint columns in SQL SERVER? Value-Labs3
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
what is physical sort data and logical sort data in index?  2
What is normalization and its forms? Challenger-Financial3
Can we have more than one NULL in a column having unique constraint? 247Customer7
What is the difference between login and a user? TCS7
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000  11
What are tasks? Wipro1
What are three SQL keywords used to change or set someone?s permissions?  3
How to find the last update record in SQL Server?  3
In which year relase the 7.0& 2000 & 2005?  1
How to create logins using windows Authentication mode?  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