| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| can primery key be a non clustered index? | | 8 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| Can you have a nested transaction? | HCL | 3 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| Can we create a clustered index on composite primary key. | | 2 |
| How do you load large data to the SQL server database? | | 2 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| Difference between Cluster and Non-cluster index? | Oracle | 9 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| What is a function? Give some example? | | 2 |
| What is the default value of CHAR type? | Bosch | 8 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
| | 2 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| What is lock escalation? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |