Interview Questions and Answers for 'Cogent infotech corp' | Search Interview Question

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 4 Companies basic frequent}

Search Interview Questions

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