| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the order in which the SQL query is executed? list
them in order. | CTS | 1 |
| What are primary keys and foreign keys? | | 3 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| what are batch in sql server?
| Satyam | 2 |
| What is a stored procedure? | | 3 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| 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 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| Whether the updations made to the views reflect the
original records in the table | NIIT | 5 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| What are cursors? Name four types of cursors and when each
one would be applied? | Adea-Solutions | 1 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| Explain the storage models of OLAP? | | 1 |
| how can do you the system monitoring? | | 1 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| |
| For more SQL Server Interview Questions Click Here |