| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Which institute is best for SQL Server 2005 Training? | | 5 |
| event classes in sql server | Accenture | 1 |
| How do we rollback the table data in SQL Server | | 3 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| What is a function? Give some example? | | 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 |
| What is the diff between Dynamic queries and static queries
| ICS-Integrated-Computer-Solutions | 1 |
| What are the types of indexes available with SQL Server? | | 2 |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 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 |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| What are the two types of concurrency? | | 2 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 6 |
| is there more the two primary key in a single table? | Systematix | 22 |
| How reterive duplicate value in SQL? | | 5 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 5 |
| |
| For more SQL Server Interview Questions Click Here |