| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain Different types of Projects? | | 1 |
| can primery key be a non clustered index? | | 8 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| can any one please send sql quries most used in applications. | | 1 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| can you any body tell me while running BCP Out in instance
in sql server 2000 is getting error.
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.?
| | 1 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| how we can count records as a group of days like sum of
records for(four mondays),(four tuesday)........ in a month.
group the column for weekdays.
| | 1 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| plz send every query in sql server2000 | Infosys | 1 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| When you first load SQL SERVER you will startup with what
all databases? | CompuSol | 3 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| can you any body tell me simple recovery,full recovery,bulk
logged recovery where can use? | | 1 |
| How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query? | | 2 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| what is the purpose of creating view is sql server 2000 | Wipro | 9 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
