| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is an Index? | Yardi-Software | 3 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 1 |
| What is normalization? | | 5 |
| 1. What are the grouping function in SQL ?
2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?
3. Difference between DROP, DELETE, TRUNCATE table ?
4. What is constraints and types ?
5. What is max size of nchar & nvarchar ?
6. Define ROLLBACK, COMMIT, SAVE POINT
7. How non-clustered better ? or rank the Clustered,
Non-Clustered and Table scan in performance wise
8. Select 10 rows from a table ?
9. Define DML, DDL, DCL, DTL commands ?
10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?
11. Default constraints ?
12. Can we have more then primary Key in table ?
13. Type of integrity ? Entity, Referential, Domain ?
| Perot-Systems | 7 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 1 |
| what is difference between having and where clause ? | | 1 |
| where do you use Isolations?give me some exmpale? | | 1 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| What value could be assigned to Varchar Type? | | 2 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| What is Trigger? | Misys | 2 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
list box.
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables? | HP | 1 |
| How do you know which index a table is using? | | 4 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
