SQL Server Interview Questions
Questions Answers Views Company eMail

What is a trigger?

4 3972

What is a view?

6 4890

What is an Index?

Yardi Software,

3 5549




What are the types of indexes available with SQL Server?

Standard Bank,

2 4948

What is the basic difference between clustered and a non-clustered index?

9 30732

What are cursors?

8 5274

When do we use the UPDATE_STATISTICS command?

Deutsche Telekom AG,

4 14058

Which TCP/IP port does SQL Server run on?

2 7527




From where can you change the default port?

3 4298

Can you tell me the difference between DELETE & TRUNCATE commands?

15 14649

Can we use Truncate command on a table which is referenced by FOREIGN KEY?

Shriram,

2 6709

What is the use of DBCC commands?

4 5562

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

iSoft,

1305

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 2435

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

Yardi Software, World Tech,

11 20460


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669


How you trouble shoot when any job fails

629


If the job running very slow what is the action you do

663


what exactly sql injuction.how to overcome.....

1262


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1096






1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

315


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

816


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

317


How to convert a table data in XML format in sql server?

1350


your distribution database is full what will u do

907


Working with TLogs

640


how many no of arguments can be passed in procedures and functions

3421


last function used in MS Access to convert sql what function will use in sql

807


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1217


What are the dis_advantages of stored procedures, triggers, indexes?

902