| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| 9. Write a query to list a new column with the
difference in temp of the cities Delhi and Mumbai, Mumbai
and Jammu and soon. Consider the following table :
City_id City Temp.
1 delhi 40
2 Mumbai 35
3 Jammu 32
4 Pune 18
| | 2 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 8 |
| What does the INSTEAD OF trigger do? | | 3 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| what is meant by deafult in sql server?
| | 2 |
| About Indexed Views? with example?
plz reply... | | 2 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| What is the diff between Static Queries and Dynamic queries
give me some examples | CSC | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| What are the different types of joins and what does each do? | | 2 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| 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 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 1 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
