| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 2 |
| How to find the date and time of last updated table?
| | 2 |
| What are the two types of concurrency? | | 2 |
| How can you get @@error and @@rowcount at the same time? | | 4 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| What are tasks? | Wipro | 1 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 2 |
| Write an SQL query if u want to select the data from one
block which intern reflects in another block ?
thanx,do reply | Covansys | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| internal language used in sql server 2000? | | 1 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 6 |
| how can do you the system monitoring? | | 1 |
| how can i view structure of table in sql server? tell me
that query. | | 2 |
| 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 |
| can any one please send sql quries most used in applications. | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
