| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| how to delete duplicate rows from table | CSC | 9 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| 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 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| How do you persist objects, permissions in tempdb | | 1 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| 1.How to check the backup file details if we do not have
access to that folder
2.how to check the backup file size without connecting to
the folder
| IBM | 1 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| What is mean by "fill factor" ? and what is mean
by "Index "in sql? | Logica-CMG | 1 |
| why cluster and non clusterindex are used in sqlserver 2000?
explain with example | | 1 |
| What is the difference between Drop and Truncate | | 10 |
| Can you have a nested transaction? | HCL | 3 |
| I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author? | | 3 |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
