| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| 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 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| write coding for importing sql data into a word excel...
| Oracle | 1 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| What is a trigger? | | 3 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| how to delete duplicate rows from table | CSC | 9 |
| 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 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| Can we call SP inside a query? | Wipro | 4 |
| What is the difference between login and a user? | TCS | 7 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| what is index seek and index scan? | | 2 |
| How to link up the text file to a Database table? | Allianz | 1 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
