Can i rollback "table data types" when we are using in transactions?
|
View Answer
|
47733 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
|
33380 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
|
30311 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
|
30338 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
|
42498 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
|
36863 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
|
20749 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
|
21211 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
|
17751 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
|
15814 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
|
14888 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
|
23071 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
|
19981 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
|
20299 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
|
19190 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
|
25637 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
|
10905 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
|
15163 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
|
17879 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
|
18080 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