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 5332

New concepts of sql server 2005 use in your project.

2409

default databases available in sql server and there uses ?

4 7298

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?

2540

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

1 6546

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

2 4897

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

7 12579

In the primary key have a multiple field or not?

8 9492

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 10063

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

7 14520

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

3 8485

difference between function and procedure

3 5515

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 5068

How to read 2nd highest sal from EMP table?

5 6334

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

1750

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

Tell me what is laravel eloquent?

838

what are the three groups involved in information sharing?

939

What are the function of different capacitor, resistors, transister, diods, thyrister( like SCR)in any circuit?

2250

What is the first part of an if then statement?

698

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2563

What are the negative test cases for water bottle?

2442

What is a binder service in Android abd how it differs from started service?

1078

How to get a list of columns in a view using the "sp_columns" stored procedure?

1089

What is synchronous request in ajax?

978

What is angular and why use it?

873

List the advantages that web services have over com (component object model)and dcom (distributed component object model)?

663

kailan po ba lumalaki at lumiliit ang tubig sa dagat?at saan naman ito kumukuha ng tubig para lalaki ang tubig?

3268

Explain is it the job of a business analyst or systems analyst to draw the class diagram?

1101

What Programming languages does Android support for application development?

1126

How would you adapt a pre-trained model to a domain-specific task?