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




CTS SQL Server Interview Questions
Questions Answers Views Company eMail

how to retrive only second row from table in sql server 2000?

15 16142

Can we create clustered index on non primary key column

20 40388

What is the difference between 2-Tier architecture and 3-Tier architecture

15 55233

What is difference between TRUNCATE and DELETE statement

12 13548

What are the types of backup and tell me the difference between full and differential backup?

4 9549





What is the difference between login and a user?

13 20955

What is the difference between truncate and delete statement?

6 3849

What is the difference between UNION and UNIONALL?

5 8502

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 3914

What is the order in which the SQL query is executed? list them in order.

5 7244

Can Having clause be used without Group by clause?

6 28669

what exactly sql injuction.how to overcome.....

1301

what is difference between Enterprise Manager and Query Analyer

6 4574

how to delete duplicate rows in sql server2005

7 7786

Post New CTS SQL Server Interview Questions



Un-Answered Questions

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

939


How would you use Version Control on an entire sub-system? And why would this be useful?

1576


What book do you like to read and tell me something about it? What organizations do you belong to and what exactly do you do you there? ( these are the follow up questions being asked if you're a newbie in this industry,after answering the question " tell me something about yourself" because you mentioned the things that you justsaid such as your hobby, the organizations you're joining in, or books you read on, they will ask for more something about these things if you're lying or not, so be specific as well with your answers.)

551


What is the Full Procedure of Purchase ?

780


type of welding

986






The maximum amount of axial load to be applied on a clutch plate is a) 100 KN b) 200 KN c) 300 KN d) 400 KN

102


Hello, I have 3 years of exp as a mainframes tester in a leading IT company, now am looking to change my company. Could you please let me know, what are the interview questions/topics i should prepare. Your suggestions are truly valuable for me :) Thanks !!

769


is there any other way to install s/w in mainframe apart from smp/e system?

1716


if a buyer paid full cst 14.5% for a redistrable assect then whatis the registration process?

862


What is Salt Filter?

510


Hii i have written ICET exam in 2009 and secured 3704 rank i would like to know top 10 OU affiliated colleges offering MBA in hyderabad.I also want to know last year for this range of ranks which colleges were offered so in which site this info is given????please mail me the answer as soon as possible

914


Plz post any critical bugs found while testing desktop application.

1100


here is my requirement A1 is alphanumeric with value 'A1B2C3D4' as defined below 05 A1 PIC X(8) VALUE IS 'A1B2C3D4' but i need to have A2,A3 as ABCD & 1234 repectively...... A2 = ABCD A3 = 1234 Can you please explain me what are the different ways to do it?

4717


I have program P1 which calls file F1 which has 100 records and following structure 001 .................. 002 .................. 003 .................. 098 .................... 099 ................... 100 .................... Now I want to read these files and write these records in file F2 in following manner. 001 ...... 051 ..... 002 ...... 052 ..... 003 ...... 053 ..... .......... ....... .......... ....... .......... ....... 048 ........ 098 ...... 049 .......... 099 ....... 050 .... 100 ......

5451


what is Huvec cell number ?

784






CTS SQL Server Interview Questions
  • C (31)
  • STL (1)
  • OOPS (10)
  • C++ General (12)
  • ActiveX (1)
  • Delphi (1)
  • PHP (2)
  • Programming Languages AllOther (15)
  • JavaScript (2)
  • VB Script (2)
  • JSP (1)
  • Shell Script (2)
  • Ruby on Rails (1)
  • AngularJS (2)
  • UDP (1)
  • Networking Administration (2)
  • Networking AllOther (3)
  • Visual Basic (2)
  • C Sharp (8)
  • ASP.NET (22)
  • VB.NET (3)
  • COM+ (1)
  • IIS (1)
  • Crystal Reports (3)
  • BizTalk (1)
  • Dot Net Framework (2)
  • Dot Net General (5)
  • Microsoft Related AllOther (1)
  • Oracle General (11)
  • Architecture (1)
  • Database Management (2)
  • Oracle AllOther (1)
  • SQL Server (14)
  • MySQL (1)
  • DB Architecture (2)
  • DB Administration (6)
  • SQL PLSQL (17)
  • Databases AllOther (3)
  • Windows Threads (1)
  • Windows General (1)
  • Windows AllOther (5)
  • Linux Commands (2)
  • Linux Threads (1)
  • Unix Commands (8)
  • Unix AllOther (1)
  • Solaris Commands (4)
  • Solaris AllOther (2)
  • RTOS AllOther (1)
  • Operating Systems General Concepts (3)
  • Data Structures (2)
  • WinRunner (9)
  • Load Runner (11)
  • QTP (90)
  • Test Director (4)
  • Rational TestSuite (1)
  • Silk Test (2)
  • Automation Testing AllOther (4)
  • Manual Testing (146)
  • QA Concepts (12)
  • Mobile Testing (2)
  • Test Cases (12)
  • Test Documents Reporting (2)
  • Testing AllOther (9)
  • Servers AllOther (1)
  • COBOL (27)
  • JCL (19)
  • CICS (5)
  • DB2 (19)
  • IMS (1)
  • Natural (1)
  • MVS (3)
  • VSAM (6)
  • QSAM (1)
  • IBM MainFrame AllOther (4)
  • RPG400 (27)
  • DB400 (1)
  • IBM AS400 AllOther (17)
  • Core Java (41)
  • Advanced Java (1)
  • EJB (3)
  • Servlets (6)
  • Struts (6)
  • JDBC (7)
  • J2EE (3)
  • Weblogic (8)
  • Java Networking (2)
  • Java J2EE AllOther (5)
  • Java Related AllOther (2)
  • MQSeries (1)
  • Middleware AllOther (1)
  • HTML DHTML (2)
  • Web Related AllOther (5)
  • Teradata (8)
  • Business Objects (13)
  • Cognos (17)
  • Informatica (74)
  • Crystal Enterprise Suite (2)
  • Ab Initio (10)
  • Data Stage (41)
  • SAS (11)
  • Micro Strategy (1)
  • ETL (3)
  • Data Warehouse General (5)
  • HR Questions (21)
  • Design Patterns (1)
  • Project Management (1)
  • Version Control AllOther (2)
  • SAP Basis (8)
  • SAP ABAP (28)
  • SAP SD (14)
  • SAP MM (1)
  • SAP FI CO (25)
  • SAP CRM (1)
  • SAP SRM (4)
  • SAP Business Warehouse (3)
  • SAP Security (7)
  • SAP Business Objects BO BOBJ (2)
  • Siebel (2)
  • Oracle Apps Technical (7)
  • Oracle Apps Financial (1)
  • Cryptography General (1)
  • WebMethods (4)
  • SeeBeyond (17)
  • JCAPS (2)
  • Civil Engineering (1)
  • Mechanical Engineering (1)
  • Electrical Engineering (18)
  • Electronics Communications (22)
  • Aeronautical Engineering (1)
  • Industrial Engineering (1)
  • Engineering AllOther (4)
  • Business Administration (1)
  • Banking Finance (4)
  • Human Resources (1)
  • Business Management AllOther (1)
  • Audit (1)
  • CompanyAffairs CS (1)
  • Taxation (1)
  • Accounting General (5)
  • Accounting AllOther (11)
  • Call Centre AllOther (11)
  • UPSC Political Science (1)
  • RRB (1)
  • BSRB Clerical (1)
  • Group I (4)
  • Group II AllOther (1)
  • APPSC AllOther (2)
  • General Knowledge_Current Affairs (2)
  • Tourism Hotel AllOther (1)
  • Everything Else AllOther (4)
  • English (6)
  • General Aptitude (102)
  • Puzzles (10)
  • Placement Papers (28)
  • CCNA (4)
  • Sun Certifications (3)
  • CISA Certification (1)
  • Oracle Certifications (2)
  • Certifications AllOther (7)
  • H1B Visa (3)
  • L1 Visa (3)
  • USA Dependent Visa H4 Visa (1)
  • Australia Visa (1)
  • C Code (1)
  • C++ Code (2)
  • J2EE Code (1)
  • GATE (1)
  • IIT JEE (1)
  • MAT (1)
  • GMAT (1)
  • C C++ Errors (1)
  • Oracle Errors (4)
  • SQLServer Errors (1)