| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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 |
| What is transaction ? Give me one example. | Melstar | 7 |
| How many index keys possible for a table | | 6 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| What command do we use to rename a db? | | 3 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 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 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 1 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| What are primary keys and foreign keys? | | 3 |
| How to link up the text file to a Database table? | Allianz | 1 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 14 |
| What is a trigger? | | 3 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| Which system tables contain information on privileges
granted and privileges obtained | | 1 |
| Let us say the SQL Server crashed and you are rebuilding the
databases including the master database what procedure to
you follow? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |