| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| What is an Index? | Yardi-Software | 3 |
| can any one answer this query,thank you in advance
Table 1 has 2 columns: EmployeeId, T shirtsize(values can
be 1,2,3)
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region which has the largest number
of people with Tshirt size=3
| Google | 10 |
| can you any body tell me suppose database is suspect mode.
how can take to normal? | Teledata | 1 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 1 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX | L&T | 2 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| How many index keys possible for a table | | 6 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same? | | 2 |
| How to find the last update record in SQL Server? | | 3 |
| How do SQL server 2000 and XML linked? | | 2 |
| What is Files and Filegroups in SQL Server & it's
implementation. | Zenith | 1 |
| how to change column into row in sql | ESS | 2 |
| |
| For more SQL Server Interview Questions Click Here |