| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| What is blocking and how would you troubleshoot it? | | 1 |
| What is the system function to get the current user's user
id? | TCS | 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 is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| What is Peer to peer Replication? | HCL | 1 |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| What is the default value of CHAR type? | Bosch | 8 |
| What is a trigger? | | 3 |
| Explain DBMS, RDBMS? | | 4 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| i want to create procedure for create table in sql server
2005
for example
create procedure create_table
@table varchar(20)
as
create @table(
id int,
name char(20)
)
but it will get error
what is solution?
| Aptech | 4 |
| what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key? | | 2 |
| What are the different types of replication? How are they used? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
