| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is BCP? When do we use it? | | 1 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| what is differece between union and union all | | 4 |
| Anyone please explain me the concept of Serialization? | | 3 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 8 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 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 |
| logshipping is Any difference 2000 and 2005? | | 1 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| How to select Distinct columns from the table, table having
20 columns and i want all coulmns | Wipro | 3 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| |
| 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
