| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| What is SQL server agent? | SAP-Labs | 2 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| What is a view? is View updatable? | IBM | 11 |
| where do you use Isolations?give me some exmpale? | | 1 |
| how to get the rowid/rownumbes of a table in sqlserver | IBM | 5 |
| can primery key be a non clustered index? | | 8 |
| What is the difference between Drop and Truncate | | 10 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 15 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| what is maximum size of temp db? | iSoft | 4 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| What is ACID Property of Transaction? | | 4 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| can you any body tell me suppose database is suspect mode.
how can take to normal? | Teledata | 1 |
| is it possible to use a variable in a query with the IN
clause (a,b,c..z), without getting quotes or conversion
errors? | | 2 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| Explain Trigger with an example?
| | 1 |
| |
| For more SQL Server Interview Questions Click Here |