| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| What is referential integrity and how is it achieved? | Adea-Solutions | 1 |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| select empid empname from employee
What is the result for the about query? | | 4 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key? | | 2 |
| 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 |
| How many index keys possible for a table | | 6 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| What value could be assigned to Varchar Type? | | 3 |
| What is the use of DBCC commands? | | 1 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 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 |
| event classes in sql server | Accenture | 1 |
| which database is best to use in oracle and sql server?
explain reasons? | TCS | 5 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 5 |
| how to know description of a table in sqlserver 2000
| | 7 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| |
| For more SQL Server Interview Questions Click Here |