| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| What is indexed views?
plz explain with example? | | 1 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
student table? | | 3 |
| What is a job? | | 3 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| What is normalization in Database ? | | 4 |
| What is Trigger? | Misys | 2 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| what is difference between primary key and Unique | | 8 |
| internal language used in sql server 2000? | | 1 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| Differences between functions and stored procedures? | 247Customer | 6 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| 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 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| |
| For more SQL Server Interview Questions Click Here |