TCS SQL Server Interview Questions Answers, TCS Placement Papers, TCS Technical, HR Interview Questions, TCS Aptitude Test Questions, TCS Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

TCS SQL Server Interview Questions

Questions Answers Views Company eMail

what is Full Text Search ?

1 5325

New concepts of sql server 2005 use in your project.

2399

default databases available in sql server and there uses ?

4 7281

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2530

wat is tuff file in log shipping, wt is d use of tht file?

1 6536

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 4888

Delete duplicate records from the table?(Table must have unique id)

7 12550

In the primary key have a multiple field or not?

8 9453

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 10034

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 14484

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 8472

difference between function and procedure

3 5504

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 5059

How to read 2nd highest sal from EMP table?

5 6309

what is checksum in sql server.........???

1744

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

What is linq used for?

119

Can you explain a situation, when to use dependency injection in angularjs?

796

What is chargeback?

634

What is public ip?

1105

How to motivate a sales rep

2055

Is not a function error in javascript?

1065

What is iis certificate?

980

do any one help me to get "C" license,, i have doubts ,,, if mediators ter pls call me,, my no is 8056640042

1472

State the different types of flip flop and their uses?

1157

What is difference between mongodb and dynamodb?

how can we submit a form without a submit button? : Sql dba

1033

How to insert null values into dataloader ?

558

How do you clear a set in c++?

1132

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1171

When have you had to focus on data integrity?

2697