Interview Questions and Answers for 'Cogent infotech corp' | Search Interview Question - javasearch.buggybread.com
Javasearch.buggybread.com

Search Interview Questions


 More than 3000 questions in repository.
 There are more than 900 unanswered questions.
Click here and help us by providing the answer.
 Have a video suggestion.
Click Correct / Improve and please let us know.
Label / Company      Label / Company / Text

   



Interview Questions and Answers for 'Cogent infotech corp' - 6 question(s) found - Order By Rating

 Q1. create an SQL query across multiple tables involving outer joins Database
Ans. Select * from table1 t1Left outer join table2 t2 on t1.tid = t2.id

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     sql query  database  outer joins     Asked in 2 Companies


 Q2. If SOAP is more secure than Rest, Why many applications today use Rest ?Web Service
Ans. SOAP supports only xml whereas Rest support many other formats.

Rest services are very light weight compared to SOAP.

SOAP services are code heavy as they require creation. of stubs and skeltons.

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     soap  rest  soap vs rest     Asked in 2 Companies


 Q3. Difference between Left and Inner Join ?SQL
 This question was recently asked at 'Canopy Tax,Cogent Infotech Corp'.This question is still unanswered. Can you please provide an answer.


 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     sql     Asked in 2 Companies


 Q4. What is Left Outer Join ?Database
Ans. It returns all the rows form the left table and matches the rows in both tables.

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     database   database joins   left outer join  sql     Asked in 2 Companies


 Q5. In which cases using SOAP is preferred over REST ?Web Service
Ans. SOAP services are better in case we need to establish a formal and detail contract with the client or callers and hence suitable for

1. Services published for much wider unknown audience
2. Require large input payload
3. Requiring different level for authentication

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     soap vs rest  soap  rest     Asked in 2 Companies


 Q6. Difference between Inner and Outer Join ?Database
Ans. Inner join is the intersection of two tables on a particular columns whereas Outer Join is the Union of two tables.

 Help us improve. Please let us know the company, where you were asked this question :   

   Like         Discuss         Correct / Improve     sql   joins   inner join   outer join     Asked in 3 Companies      basic        frequent



Help us and Others Improve. Please let us know the questions asked in any of your previous interview.

Any input from you will be highly appreciated and It will unlock the application for 10 more requests.

Company Name:
Questions Asked: