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 17220

Can we create clustered index on non primary key column

20 42319

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

15 56885

What is difference between TRUNCATE and DELETE statement

12 14736

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

4 10079

What is the difference between login and a user?

13 22198

What is the difference between truncate and delete statement?

6 4388

What is the difference between UNION and UNIONALL?

5 9110


2 4438

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

5 7786

Can Having clause be used without Group by clause?

6 30865

what exactly sql to overcome.....


what is difference between Enterprise Manager and Query Analyer

6 5273

how to delete duplicate rows in sql server2005

7 8457

Post New CTS SQL Server Interview Questions

CTS SQL Server Interview Questions

Un-Answered Questions

How to check the changes made in the standard layout set , other than using Utilities--- -> Print preveiw ? can u explain the different other ways to check it?


What is the tcp/ip port on which sql server runs?


what is the use of brij35 in zymogram?


What is extreme programming and what is it got to do with testing?


Explain Memory Partitioning, Paging, Segmentation?


How do you define universe parameters? : sap bobi


Can an info-object be an info-provider?


How to remove safemode of namenode forcefully in HDFS?


The procedure of hiring fresher’s in CEI is as follows. Only graduates from an engineering background with specialization in ECE (Electronics and Communications), Computer science and IT streams are accepted. We also accept students who have completed their Masters in Computer Applications. Only those candidates who have a score of 70% and above throughout their academics are considered. We follow a four level procedure for selecting any fresher to be part of our highly skilled technical team. These include: 1. Written Test 2. Technical Interview 1 – Conducted by CEI Developers 3. Technical Interview 2 – Conducted by CEI Project Managers 4. HR Discussion The written test is divided into 3 sections as mentioned below: 1. Logical: Critical Reasoning and Analytical Reasoning – 30 Questions 2. Quantitative Aptitude – 25 Questions 3. Technical Questions – 25 Questions Logical: These questions primarily test the analytical and critical thinking skills of the applicants. It tests the most integral skills of the applicant, the logical consistency in thought, understanding and processing data and making valid conclusions from them, and out of the box thinking. The best part about logical reasoning is that it does not require any learning or prior knowledge. Example: • If the positions of the first ten letters and the last ten letters in the English alphabet are interchanged such as that the first and the seventeenth the second and the eighteenth letters are interchanged and this continues till the tenth letter is interchanged with the twenty-sixth letter, which letter will be the fifth to the right of the twelfth letter from the right after this rearrangement? • There is a 3 digit number. The sum of the digits is 17, and two of the digits are the same. The unique digit subtracted from one of the other digits equals a positive even number. What is the digit that is different from the other two digits? Quantitative aptitude Section consists of questions related to Simplifications, Data Sufficiency, and from the topics of Arithmetic. For e.g.; Fraction, Profit and Loss, Combinations and Permutations, Percentage problems, Ratio, Probability, Allegations and Mixtures, Time and distance, Time and work, Measurements, etc. Example: • A sales person by mistake multiplied a number and got the answer as 3, instead of dividing the number by 3. What is the answer he should have actually got? • A traveler walks a certain distance. Had he gone half a kilometer an hour faster, he would have walked in 4/5 of the time, and had he gone half a kilometer an hour slower, he would have walked 2 ½ hours longer. What is the distance? • Two taps A and B fill a tank in 12 and 20 hours respectively and a third tap C empties it in 15 hrs. In how many hours will the tank be filled if the taps A and B are opened simultaneously and C is opened after two hours.? Technical Section consists of sections related to basics concepts of programming languages, and some basic entry level programming are given to assess the applicant’s ability to solve the program. Example: • An alternate to using interrupts for I/O devices is • The main advantage of using indexes is • PRODUCT Product ID Product Description Manufacturer ID MANUFACTURER Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table?  Once a candidate clears the written test they will be considered for the second round.


What is Frequency-Hopping Spread Spectrum (FHSS)?


How to make tiles floor step by step procedure?


Why phase sequence must be same in any ht motor or generator circuit?if phase sequence doesn't same whatever will be affect on circuit?


Can you tell me how to find the ugr of a country?


Tell me what is the difference between bias and variance?


what is the diff between manual test plan document and automation test plan doc.can u explain indetail.