| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is BCP? When do we use it? | | 1 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 2 |
| When do we use the UPDATE_STATISTICS command? | | 1 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 21 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 1 |
| WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER? | | 5 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 2 |
| what is the diffrence between Snap Shot and Transaction
Replication | CSC | 1 |
| Explain some DBCC commands? | | 3 |
| From where can you change the default port? | | 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? | | 1 |
| Questions regarding Raiseerror? | | 1 |
| How to Run a Query on a Remote SQL Server? | | 1 |
| What is a view? | | 1 |
| How to Display, Amount of Disk Activity Generated by
Transact-SQL Statements?
| | 1 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| Explain sp_configure commands, set commands? | | 1 |
| |
| 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
