| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a view? | | 1 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| Is trigger fired implicitely? | | 2 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| Advantages and Disadvantages of Cursor? | Zenith | 4 |
| What is normalization? | | 5 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| What r sql reporting services and analysis services? how
can we use it. | | 2 |
| What is Covering Indexes?
Plz explain with example | | 1 |
| Which virtual table does a trigger use? | | 3 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| what is the difference between sql query and google query? | TCS | 2 |
| What is a transaction and what are ACID properties? | IBM | 2 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| Why we need a group by clause? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |