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

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 16045

What is better - 2nd Normal form or 3rd normal form? Why?

2 8873

Which virtual table does a trigger use?

8 18465

Which command displays the SQL command in the SQL buffer, and then executes it?

3 7936

Difference between writing SQL query and stored procedure ?

15 63660





How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 22071

What are defaults? Is there a column to which a default can't be bound?

2 5916

What is a transaction and what are ACID properties?

14 64968

What is the system function to get the current user's user id?

3 6513

What are the differences between stored procedure and functions in SQL Server 2000?

25 97249

Can anybody explain me cold backup and hot backup?

3 13187

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 10197

wht is normalization?can u explain me in detail?

9 11911

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

9 56261

write the query for find the top 2 highest salary in sql server

36 50778

Post New TCS SQL Server Interview Questions



Un-Answered Questions

what is The specifications for oriface instalation

1006


How does XDR'S use of the buffer paradigm make programming easier.

1582


How you calibrate absolute pressure with the calibration range of 0 to 1000 0C Absolute. Please explain the procedure for calibration.

629


What is an AMI? How do we implement it?

103


What are the excise duties in our state?

1331






HOW TO CLACULATE CEMENT AND SAND CONSUMPTION FOR THE STAIRCASE KOTA FLOORING IN THE RATIO OF 1:4 50 MM THICKNESS

3215


What are the different business cycles?

5


How many test scenarios you have automated? How many time it will take to execute 30-40 scenarios? What SDLC model you are following? How often you will execute your test scripts? Because of some changes, your test scripts failed? When you will update your test scripts? How much time it will take to update? Do you know how to connect database? Do you know the direct method to count no. of records (or) rows present in record set once query is executed? How will you create the connection string? How did you resolve conflicts present in Object Repository? How good you are in VB? How will you work on Excel Application? How will you select Excel sheet? If you want to select 10 sheets, will you create 10 separate objects? Given string is “abcd”. What are the methods you will use to display “dcba”? Drives script – explain the frameworks? How you are updating results for each test? What is start up, configuration, navigation scripts? If you are not able to understand the application (some module), who will teach you? What test cases to be automated? When to be automated? What is the testing process you are following? What life cycle you are following? When you will use Descriptive Programming? Do you have the permission to add objects into shared object repository? (OR) someone will maintain SOR? Do you know how to add objects into shared object repository? How many test cases you have automated? How much time will it take to execute? What is complex in automation? When you feel automation is complex? Tell me one scenario, the complex functionality you have automated in your project? Excel sheet having some datas and some datas present in the application (in table). How will you compare these two datas? Write code to fetch datas from Excel sheet. Rate yourself in SQL? Display the employee name who is getting maximum salary? sal ID Salary name 001 100 002 500 003 300 ID 001 002 003 Ename A B C Have you written any test cases while you are in Automation? Manual Testing also will you do or you will work only in automation?

1627


iam new testing, i want improve writing test cases and bug defect etc? any on give suggestion pls?

761


When we should use 'jobid' for commit table (Output table component??

5390


How important is experience for EM managers?

1539


what are social responsibilities of a company.

1059


by which materials we can prepare circular shuttering with tentative cost of material(rate analysis)

938


i want to take the fast track training on >net Frame work and work flows and share point could you tellme the good institutes for that cources

920


What are the automatic tripping devices of diesel generator?

799






TCS SQL Server Interview Questions
  • Software (1)
  • C (274)
  • STL (1)
  • OOPS (59)
  • C++ General (41)
  • MFC (10)
  • ATL (2)
  • COM DCOM (2)
  • VC++ AllOther (3)
  • PHP (25)
  • Programming Languages AllOther (36)
  • ASP (12)
  • CGI Perl (4)
  • JavaScript (16)
  • VB Script (17)
  • JSP (9)
  • Shell Script (6)
  • Ruby on Rails (2)
  • AngularJS (1)
  • Scripts AllOther (1)
  • SNMP (2)
  • TCP IP (10)
  • Protocols AllOther (11)
  • Networking Administration (19)
  • Networking Security (1)
  • Networking AllOther (9)
  • Visual Basic (14)
  • C Sharp (67)
  • ASP.NET (106)
  • VB.NET (9)
  • ADO.NET (20)
  • IIS (13)
  • Dot Net Framework (16)
  • Dot Net Remoting (10)
  • Dot Net WindowsForms (1)
  • Dot Net General (29)
  • Dot Net AllOther (6)
  • Exchange Server (2)
  • SharePoint (10)
  • WCF (2)
  • Microsoft Related AllOther (2)
  • Oracle General (51)
  • Architecture (4)
  • Database Management (9)
  • Forms Reports (9)
  • Oracle Data Integrator (ODI) (18)
  • Oracle AllOther (9)
  • SQL Server (75)
  • MySQL (5)
  • Sybase (1)
  • DB Administration (11)
  • DB Development (3)
  • SQL PLSQL (108)
  • Databases AllOther (11)
  • SDK (4)
  • Windows Threads (1)
  • Windows General (1)
  • Windows AllOther (10)
  • Linux Commands (5)
  • Linux IPC (1)
  • Linux Socket Programming (1)
  • Linux System Calls (1)
  • Linux General (5)
  • Linux AllOther (2)
  • Unix Commands (16)
  • Unix Threads (2)
  • Unix IPC (1)
  • Unix General (3)
  • Unix AllOther (15)
  • Solaris Commands (5)
  • Solaris General (3)
  • Solaris AllOther (9)
  • RTOS AllOther (2)
  • Operating Systems General Concepts (15)
  • Data Structures (16)
  • Operating Systems AllOther (5)
  • WinRunner (11)
  • Load Runner (36)
  • QTP (169)
  • Test Director (8)
  • Rational TestSuite (2)
  • Silk Test (1)
  • Automation Testing AllOther (15)
  • Manual Testing (262)
  • QA Concepts (22)
  • Mobile Testing (4)
  • Test Cases (32)
  • Test Documents Reporting (3)
  • Testing AllOther (61)
  • Tomcat (1)
  • Apache (1)
  • Servers AllOther (4)
  • COBOL (118)
  • JCL (53)
  • CICS (11)
  • DB2 (32)
  • IMS (2)
  • IDMS (1)
  • Natural (4)
  • ADABAS (2)
  • REXX (1)
  • Assembler (2)
  • QMF (1)
  • MVS (1)
  • OS390 (1)
  • VSAM (8)
  • Sysplex (1)
  • IBM MainFrame AllOther (6)
  • RPG400 (28)
  • COBOL400 (2)
  • DB400 (4)
  • COOLPLEX (1)
  • IBM AS400 AllOther (8)
  • Core Java (159)
  • Advanced Java (20)
  • Swing (5)
  • EJB (4)
  • Servlets (20)
  • Struts (31)
  • JDBC (11)
  • SunOne (1)
  • J2EE (7)
  • Weblogic (28)
  • Java Networking (2)
  • Java J2EE AllOther (3)
  • J2ME (3)
  • Java Related AllOther (8)
  • Orbix (1)
  • MQSeries (1)
  • Middleware AllOther (2)
  • HTML DHTML (2)
  • XML XSLT RSS (1)
  • SOAP (3)
  • Web Related AllOther (2)
  • Teradata (23)
  • Business Objects (129)
  • Cognos (83)
  • Informatica (274)
  • Actuate (5)
  • Ab Initio (17)
  • Data Stage (90)
  • SAS (38)
  • Micro Strategy (5)
  • ETL (6)
  • Data Warehouse General (22)
  • HR Questions (117)
  • Design Patterns (5)
  • UML (6)
  • OOAD (3)
  • Software Design Tools (1)
  • Requirements Management (2)
  • Project Planning (1)
  • Project Management (3)
  • Software Design AllOther (1)
  • CTC (1)
  • Debugging AllOther (1)
  • Clear Case (2)
  • Version Control AllOther (1)
  • Telecom Routers Switches (2)
  • Telecom Protocols (1)
  • VoIP IP Telephony (1)
  • GSM (2)
  • BlueTooth (2)
  • Telecom General (4)
  • SAP Basis (55)
  • SAP ABAP (165)
  • SAPScript (9)
  • SAP SD (126)
  • SAP MM (23)
  • SAP QM (1)
  • SAP PP (7)
  • SAP PM (2)
  • SAP PS (1)
  • SAP FI CO (111)
  • SAP HR (55)
  • SAP CRM (67)
  • SAP SRM (1)
  • SAP APO (1)
  • SAP Business Warehouse (48)
  • SAP Security (30)
  • SAP Netweaver (1)
  • SAP ALE IDocs (7)
  • SAP B1 (9)
  • SAP Business Objects BO BOBJ (1)
  • SAP AllOther (3)
  • Siebel (10)
  • ERP General (2)
  • Oracle Apps Technical (49)
  • Oracle Apps Financial (68)
  • Oracle Apps Manufacturing (3)
  • Oracle Apps HRMS (3)
  • Oracle Apps SCM (5)
  • 86 Family (3)
  • VLSI (1)
  • Embedded Systems AllOther (2)
  • Client Server Architecture (1)
  • Client Server General (3)
  • Client Server AllOther (2)
  • AI Algorithms (1)
  • AI Neural Networks (1)
  • AI AllOther (1)
  • Cryptography Algorithms (13)
  • Digital Certificates (2)
  • Encryption Decryption (7)
  • Cryptography Protocols (1)
  • Cryptography General (58)
  • WebMethods (17)
  • TIBCO (8)
  • EAI AllOther (1)
  • 3D Animation (2)
  • Requirement Management (4)
  • Estimation Analysis (1)
  • Software Quality Analysis (3)
  • Change Request Management (1)
  • Quality Analysis (3)
  • Program Management (2)
  • Configuration Management (1)
  • Cloud Computing General (1)
  • Pega (10)
  • Micro Biology (1)
  • Bio Technology (1)
  • Bio Informatics (2)
  • Botany (1)
  • Nuclear Physics (1)
  • Organic Chemistry (1)
  • General Chemistry (2)
  • Chemistry AllOther (1)
  • Pharmacy (1)
  • Health Pharma AllOther (1)
  • Cardiology (1)
  • Mathematics (1)
  • General Science (2)
  • Sciences AllOther (3)
  • Civil Engineering (16)
  • Mechanical Engineering (34)
  • Electrical Engineering (138)
  • Electronics Communications (137)
  • Chemical Engineering (3)
  • Aeronautical Engineering (1)
  • Industrial Engineering (4)
  • Instrumentation (12)
  • Automobile Engineering (1)
  • Power Plant Engineering (1)
  • Engineering AllOther (70)
  • Business Administration (8)
  • Marketing Sales (18)
  • Banking Finance (22)
  • Human Resources (31)
  • Personnel Management (1)
  • Industrial Management (2)
  • IT Management (2)
  • Non Technical (5)
  • Business Management AllOther (4)
  • Audit (6)
  • CompanyAffairs CS (2)
  • Taxation (35)
  • Accounting General (37)
  • Accounting AllOther (45)
  • Advertising Media AllOther (1)
  • Call Centre AllOther (80)
  • Fashion Modelling AllOther (1)
  • UPSC General Studies (3)
  • UPSC AllOther (5)
  • SSC Political Science (1)
  • SSC General Science (1)
  • SSC General Studies (4)
  • SSC AllOther (1)
  • RRB (3)
  • CDS (2)
  • NDA (2)
  • POs (2)
  • BSRB Clerical (5)
  • BSRB AllOther (1)
  • Group I (5)
  • Group II History (1)
  • Group II AllOther (2)
  • APPSC AllOther (14)
  • General Knowledge_Current Affairs (47)
  • Government AllOther (7)
  • Law AllOther (5)
  • Tourism Hotel AllOther (1)
  • Funny Interview Questions (5)
  • Everything Else AllOther (14)
  • English (21)
  • General Aptitude (303)
  • Puzzles (41)
  • Placement Papers (67)
  • CCNA (14)
  • Microsoft Certifications (13)
  • Sun Certifications (3)
  • Oracle Certifications (3)
  • ISTQB Certification (2)
  • Certifications AllOther (8)
  • H1B Visa (18)
  • USA Student Visa F1 Visa (6)
  • L1 Visa (17)
  • USA Visitor Visa B2 Visa (1)
  • USA Business Visa B1 Visa (2)
  • USA Dependent Visa H4 Visa (3)
  • UK Visa (5)
  • Germany Visa (1)
  • C Code (20)
  • C++ Code (8)
  • J2SE Code (2)
  • J2EE Code (2)
  • ASP.NET Code (7)
  • VB.NET Code (1)
  • C Sharp Code (2)
  • PHP Code (2)
  • JavaScript Code (7)
  • GATE (7)
  • CAT (2)
  • MAT (1)
  • GMAT (4)
  • OPENMAT (4)
  • C C++ Errors (6)
  • DotNet Errors (2)
  • Oracle Errors (10)
  • SQLServer Errors (4)
  • Scripts Errors (4)