| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
student table? | | 3 |
| What is a NOLOCK? | | 3 |
| Can we call SP inside a query? | Wipro | 4 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| what are the problems in logshipping? | | 2 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| how to replace double quotes by single quotes in sql server | CAC | 2 |
| What is a Trace frag?Where can we use this? | | 1 |
| Difference between Function and Procedure-in general? | | 3 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| What is difference between Triggers and store procedure? | | 2 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| What are the two virtual tables SQL Server maintains for
triggers? | | 2 |
| Explain DBMS, RDBMS? | | 4 |
| What are Magic Table? | Evalueserve | 15 |
| |
| For more SQL Server Interview Questions Click Here |