| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What r sql reporting services and analysis services? how
can we use it. | | 2 |
| What is the default value of CHAR type? | Bosch | 6 |
| What is transaction ? Give me one example. | Melstar | 7 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 2 |
| What is Deadlock? | Satyam | 2 |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| What is data integrity? Explain constraints? | | 1 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| what is maximum size of temp db? | iSoft | 3 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 2 |
| Which virtual table does a trigger use? | TCS | 5 |
| 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 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 3 |
| What is transcation?Plz give One example? | | 1 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| how to generate XML out of QUERY? | McAfee | 1 |
| |
| For more SQL Server Interview Questions Click Here |