| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| What's the difference between DELETE TABLE and TRUNCATE
TABLE commands? | | 9 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| How do we rollback the table data in SQL Server | | 3 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.? | | 2 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables? | Lason | 2 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| internal language used in sql server 2000? | | 1 |
| what is the difference between sql query and google query? | TCS | 6 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| Explain the storage models of OLAP? | | 1 |
| What is the difference between a local and a global variable? | | 3 |
| What is one of the first things you would do to increase
performance of a query? For example, a boss tells you that
?a query that ran yesterday took 30 seconds, but today it
takes 6 minutes? | Wipro | 1 |
| how to know description of a table in sqlserver 2000
| | 7 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
