| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| How can i change the column name. | HCL | 7 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| What is a Lock and let me know Different types of locks? | | 1 |
| Let’s say the table in the database is named as
TBL_Register. The fields in this table include:
1. User_Name,
2. User_Telephone,
3. Register_Date
The field Register_Date stores the current date and time of
the registration.
Write the SQL statement that inserts the data into the
table. | Techno-Solutions | 2 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better?
| HCL | 1 |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| 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 |
| What is a trigger? | | 6 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| How to count the number of duplicate items in a table? | | 1 |
| How do you know which index a table is using? | | 4 |
| What is the difference between truncate and delete statement? | CTS | 4 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 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 is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| |
| 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
