| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain the storage models of OLAP? | | 1 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| How the data stores in a page? | | 1 |
| How reterive duplicate value in SQL? | | 5 |
| 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 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| Can we create clustered index on non primary key column | CTS | 14 |
| If there exist a index on the table, and we then make a
view on that table (include the indexed column from base
table) than why do we require indexing on view?Doesnt it
create an overhead? | | 1 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| what is index seek and index scan? | | 2 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| 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 |
| What is an Index? | Yardi-Software | 3 |
| |
| For more SQL Server Interview Questions Click Here |