| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| What is row by row processing ? | | 1 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| What is the difference between SSAS 2000 and SSAS 2005? | APX | 1 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| About types of indexes in SQL server ? | Cognizent | 1 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query? | Infosys | 3 |
| what is web server?
| Satyam | 3 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| Differences between functions and stored procedures? | 247Customer | 6 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
