| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| What is a materialized view? | | 2 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| How many index keys possible for a table | | 6 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| What is the difference between a local and a global variable? | | 3 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| What is a view? | | 4 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| Explain the storage models of OLAP? | | 1 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| |
| For more SQL Server Interview Questions Click Here |