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 5259

New concepts of sql server 2005 use in your project.

2365

default databases available in sql server and there uses ?

4 7141

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?

2494

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

1 6441

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

2 4791

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

7 12374

In the primary key have a multiple field or not?

8 9251

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 9860

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

7 14273

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

3 8389

difference between function and procedure

3 5391

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 4959

How to read 2nd highest sal from EMP table?

5 6170

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

1691

Post New TCS SQL Server Interview Questions

TCS SQL Server Interview Questions

TCS SQL Server Interview Questions (81)

Un-Answered Questions

What do you understand by overflow errors?

1249

Name the application thread from where uikit classes should be used?

1009

Define CRR? What is the current CRR?

1355

What do you think determines a person's progress in a good company?

11960

What is the integral value of sec(square)x, with upper limit 180/4 and lower limit 0 ?

974

WHAT ARE THE DISTNICT VARIABLES?

2269

What is css4?

611

What are the utility programs in jcl?

1167

what do you mean by extended receiver determination ? what do you mean by value mapping replication ?

1508

Explain cmdlet command of microsoft azure?

655

Describe routines in datastage? Enlist various types of routines.

1016

What is regression in machine learning with example?

What are the advantages of compute node?

1065

Tell me how many types of ipc mechanism you know?

833

how many types of balance calibration test?

2307