| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How the data stores in a page? | | 1 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| How do you find the number of rows in a table? | | 5 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| Can store procedure call by user define function in SQL
server? | HCL | 6 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 11 |
| What r sql reporting services and analysis services? how
can we use it. | Microsoft | 2 |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| 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 | 10 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 2 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha | | 4 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |