| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| Can you give an example of Stored Procedure? | | 2 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
| TCS | 5 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000 | | 3 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| What is one of the first things you would do to increase
performance of a query? For example, a boss tells you that
?a query that ran yesterday took 30 seconds, but today it
takes 6 minutes? | Wipro | 1 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
