| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| what is web server?
| Satyam | 3 |
| What are the types of model in sql server and explain | TCS | 1 |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| what is Archive old data? | | 1 |
| How do we rollback the table data in SQL Server | | 3 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| 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 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| what is advantages in sql 2005 over sql 2000? | | 4 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| What are the type of Indexes? which one is best, why? | | 5 |
| |
| For more SQL Server Interview Questions Click Here |