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 5161

New concepts of sql server 2005 use in your project.

2303

default databases available in sql server and there uses ?

4 6931

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?

2428

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

1 6328

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

2 4616

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

7 12095

In the primary key have a multiple field or not?

8 8935

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 9548

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

7 13957

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

3 8231

difference between function and procedure

3 5220

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 4819

How to read 2nd highest sal from EMP table?

5 5945

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

1619

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

What are the 6 functions?

906

What is marx circuit?

1073

what is the difference between error,exception,bug,defect,fault..?

2335

what type of testing techniques are using after accept the build?

2065

if jj form not cancelled within 1hour,wat to do

1713

What is sod risk management?

518

What is the difference between arrays and pointers?

1067

What is the difference between sendredirect() and forward() in a servlet?

957

Write a program to find the max value from a list without using max()?

743

How to remove the spaces at the end of each record in the output file of variable length, via cobol program?

1108

Describe about the SOQL injection?

463

What are governor limits in salesforce? : salesforce crm

427

How do I pull data from one excel sheet to another?

563

What is makefile in unix?

993

How can we define a variable accessible in functions of a php script?

957