|
Can i rollback "table data types" when we are using in transactions?
|
View Answer
|
|
48192 View(s) | Expertise Level:
Experienced
| Asked in:
Accenture
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Accenture Interview Questions
Accenture Interview Questions on SQL Server
Accenture SQL Server Interview Questions
|
What is correlated sub-query?
|
View Answer
|
|
33576 View(s) | Expertise Level:
Intermediate
| Asked in:
iGATE
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
iGATE Interview Questions
iGATE Interview Questions on SQL Server
iGATE SQL Server Interview Questions
|
In a table there are so many duplicated records, with your name having 4 records, there is no primary key, then how can you delete two records having with your name?
|
View Answer
|
|
30407 View(s) | Expertise Level:
Experienced
| Asked in:
iGATE
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
iGATE Interview Questions
iGATE Interview Questions on SQL Server
iGATE SQL Server Interview Questions
|
Write a query to get max salary and second max salary in order in one query?
|
View Answer
|
|
30474 View(s) | Expertise Level:
Intermediate
| Asked in:
ValueLabs
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
ValueLabs Interview Questions
ValueLabs Interview Questions on SQL Server
ValueLabs SQL Server Interview Questions
|
What is difference between STUFF and REPLACE in SQL Server
|
View Answer
|
|
42870 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
What is difference Between GETDATE and SYSDATETIME
|
View Answer
|
|
37177 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
How to check multiple LIKE conditions in one single SQL Statement.
|
View Answer
|
|
20867 View(s) | Expertise Level:
Experienced
| Asked in:
Broadridge
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Broadridge Interview Questions
Broadridge Interview Questions on SQL Server
Broadridge SQL Server Interview Questions
|
What are different types of cursors available in SQL Server 2005?
|
View Answer
|
|
21307 View(s) | Expertise Level:
Experienced
| Asked in:
Olivegreen
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Olivegreen Interview Questions
Olivegreen Interview Questions on SQL Server
Olivegreen SQL Server Interview Questions
|
How to retrieve data from SQL Server multiple tables to Excel multiple sheets
|
View Answer
|
|
17850 View(s) | Expertise Level:
Intermediate
| Asked in:
SemanticSpace Technologies
|
|
SQL Server Interview Questions
SQL Server DBA Interview Questions
SemanticSpace Technologies Interview Questions
SemanticSpace Technologies Interview Questions on SQL Server
SemanticSpace Technologies SQL Server Interview Questions
|
What is the significance of isolation levels in SQL server and Why those are needed?
|
View Answer
|
|
15910 View(s) | Expertise Level:
Intermediate
| Asked in:
Broadridge
|
|
SQL Server Interview Questions
SQL Server General Interview Questions
Broadridge Interview Questions
Broadridge Interview Questions on SQL Server
Broadridge SQL Server Interview Questions
|
A table has a single column and has duplicate values. How to delete all the duplicate values?
|
View Answer
|
|
14976 View(s) | Expertise Level:
Experienced
| Asked in:
Inooga Solutions
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Inooga Solutions Interview Questions
Inooga Solutions Interview Questions on SQL Server
Inooga Solutions SQL Server Interview Questions
|
What is the difference between Truncate and Delete in SQL Server
|
View Answer
|
|
23233 View(s) | Expertise Level:
Intermediate
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server General Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
When should i go for temporary tables and table data types in SQL Server? Which one is advantage compared to other in terms of performance while writing queries?
|
View Answer
|
|
20114 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
What is difference between rebuild and reorganize the indexes in SQL Server 2005? When should i go for rebuild the index and when should i go for reorganize the index?
|
View Answer
|
|
20424 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server DBA Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
I had created two update triggers for two columns in a table. When i use update statement on this table on which order or precedence trigger will fires?
|
View Answer
|
|
19364 View(s) | Expertise Level:
Experienced
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
What are System Databases? What are the significance of those databases (Master, Model, Resource, Tempdb and MSDB)?
|
View Answer
|
|
25865 View(s) | Expertise Level:
Expert
| Asked in:
TCS (Tata Consultancy Services)
|
|
SQL Server Interview Questions
SQL Server General Interview Questions
TCS (Tata Consultancy Services) Interview Questions
TCS (Tata Consultancy Services) Interview Questions on SQL Server
TCS (Tata Consultancy Services) SQL Server Interview Questions
|
Difference between sql server 2000 and sql server 2005?
|
View Answer
|
|
10987 View(s) | Expertise Level:
Experienced
| Asked in:
Mahindra Satyam
|
|
SQL Server Interview Questions
SQL Server General Interview Questions
Mahindra Satyam Interview Questions
Mahindra Satyam Interview Questions on SQL Server
Mahindra Satyam SQL Server Interview Questions
|
What are magic tables in SQL Server?
|
View Answer
|
|
15239 View(s) | Expertise Level:
Experienced
| Asked in:
Mahindra Satyam
|
|
SQL Server Interview Questions
SQL Server PL/SQL Interview Questions
Mahindra Satyam Interview Questions
Mahindra Satyam Interview Questions on SQL Server
Mahindra Satyam SQL Server Interview Questions
|
How many types of triggers are there?
|
View Answer
|
|
17981 View(s) | Expertise Level:
Experienced
| Asked in:
Mahindra Satyam
|
|
SQL Server Interview Questions
SQL Server General Interview Questions
Mahindra Satyam Interview Questions
Mahindra Satyam Interview Questions on SQL Server
Mahindra Satyam SQL Server Interview Questions
|
How to return a value from stored procedure?
|
View Answer
|
|
18172 View(s) | Expertise Level:
Intermediate
| Asked in:
Mahindra Satyam
|
|
SQL Server Interview Questions
SQL Server General Interview Questions
Mahindra Satyam Interview Questions
Mahindra Satyam Interview Questions on SQL Server
Mahindra Satyam SQL Server Interview Questions
