| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how do we find every fifth record in a table | | 11 |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| How to delete an attribute from the emp table | | 3 |
| What are the types of model in sql server and explain | TCS | 1 |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 1 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| What is normalization? | | 6 |
| What is de-normalization and when do you do it? | | 3 |
| Can we create a clustered index on composite primary key. | | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| Can you explain the role of each service? | | 1 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
