| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What's the purpose of Stored Procedure? | Wipro | 3 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 1 |
| What is an extended Stored Procedure? | | 1 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 6 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| What is the difference between having and where clause? | | 3 |
| create index a on employee(dno)
In this,which index was created? | | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 3 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| 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 the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 5 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| how to find nth highest salary | | 21 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
