| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How can you see what type of locks used? | | 1 |
| what are the problems in logshipping? | | 2 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| What is SQL Profiler what is the use of it? | 247Customer | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| What is a Trace frag?Where can we use this? | | 1 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 7 |
| i have a table student like
sname
-----
ram
ram
ram
raj
raj
raj
i need the output like
sname
-----
ram
raj
ram
raj
ram
raj
| IBM | 7 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| how to delete duplicate rows from table | CSC | 9 |
| system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??
| | 8 |
| Difference Between varchar and nvarchar datatype? | Satyam | 2 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| Can you explain the role of each service? | | 1 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| What are primary keys and foreign keys? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |