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

Interview Questions and Answers for 'Cogent infotech' - 9 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}

Frequently asked at HCL Technologies ( Based on 3 feedback )

Q6. Difference between Checked and Unchecked exceptions ?

Core Java

Ans. Checked exceptions are the exceptions for which compiler throws an errors if they are not checked whereas unchecked exceptions are caught during run time only and hence can't be checked.

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

_{Like Discuss Correct / Improve java exceptions checked exceptions unchecked exceptions exception handling checked vs unchecked exceptions Asked in 39 Companies basic frequent}

Try 1 Question(s) Test

Frequently asked to fresh graduates.

Q7. Difference between Process and Thread ?

Operating System

Ans. Process is a program in execution whereas thread is a separate path of execution in a program.

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

_{Like Discuss Correct / Improve java threads multi threading operating system process vs thread Asked in 24 Companies basic frequent}

Very frequently asked.Usually among first few questions.

Q8. What is MVC ?

Design

Ans. MVC is a Design Pattern that facilititates loose coupling by segregating responsibilities in a Web application

1. Controller receives the requests and handles overall control of the request
2. Model holds majority of the Business logic, and
3. View comprise of the view objects and GUI component

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

_{Like Discuss Correct / Improve j2ee mvc mvc design pattern design pattern struts spring web application web frameworks ebay Asked in 60 Companies basic frequent}

Try 1 Question(s) Test

Q9. 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.