Interview Questions and Answers for 'Computer sciences corporation (csc) india' | 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 'Computer sciences corporation (csc) india' - 3 question(s) found - Order By Rating

 Q1. With a Table employee having columns Id,Name,ManagerEmployeeId, Write a SQL to find the Manager with maximum number of employees ?Database
Ans. Select Name from EMPLOYEE where ID in (Select ManagerEmployeeId from EMPLOYEE
Group By ManagerEmployeeId
order by count(Id)
LIMIT 1)

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

   Like         Discuss         Correct / Improve     database  sql     Asked in 1 Companies


Related Questions

 What are Inner , Outer , Left and Right Joins in SQL ?
  What is JDBC? Describe the steps needed to execute a SQL query using JDBC.
  What are temp tables ?
 What is a self Join and give an example of a self Join ?

or

What is self Join and What is it's purpose ?
 Do you like Native SQL Apis like JDBC or JPA / Hibernate ?
 Is there any schema in mongo DB ?
  Difference between Inner and Outer Join ?
  What is a Cursor ?
  Does SQL allow null values ? Can we use it within Where clause ?
  Write an SQL to find all records having all upper case alphanumeric characters in a field ?


Frequently asked in Cognizant (CTS)
  Q2. What is Serialization ? Why do we need it ?Core Java
Ans. Storing the state of an object in a file or other medium is called serialization.

Classes can communicate only if they are built together ( as they need Byte code for communication ). What if we need to enable communication between different applications ( i.e they have been built independently or even they reside at different locations ), We need a mechanism that will transfer the Bean state to a Medium than can be transferred to the receiving application.

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

   Like         Discuss         Correct / Improve     java   oops   serialization     Asked in 18 Companies      basic        frequent

Try 1 Question(s) Test


Related Questions

 Can we declare static variables as transient ?
 Which elements of a class are ignored during serialization ?
  Can we serialize static variables ?
  What one should take care of, while serializing the object?
  What is the use of Transient Keyword ?
 serialization and deserialization of singleton class
  Difference between Serialization and Deserialization ?
  What is an Externalizable interface ?
  Difference between serializable and externalizable interface ?


 Q3. Explain Inner Classes ?Core Java
Ans. The accessibility (public, protected, etc.) of the inner class is defined by the outer class.

Just like top-level classes, an inner class can extend a class or can implement interfaces.

Similarly, an inner class can be extended by other classes, and an inner interface can be implemented or extended by other classes or interfaces.

An inner class can be declared final or abstract.Inner classes can have inner classes, but you will have a hard time reading or understanding such complex nesting of classes.

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

   Like         Discuss         Correct / Improve     java   oops   classes   inner classes     Asked in 2 Companies      Basic        frequent

Try 2 Question(s) Test


Related Questions

  Why do we need Inner classes ? Cant we just work with outer classes wherever we implement Inner classes ?
 What is the difference between the following two code lines ?

1. new OuterClass().new InnerClass();

2. new OuterClass.InnerClass();
 What is the difference between inner class and sub class ?
  What are the different types of inner classes ?
  Which access specifier can be used with Class ?
  Difference between nested and inner classes ?
  Which of the following cannot be marked static ?
  Explain use of nested or inner classes ?
  What is the benefit of inner / nested classes ?
  Explain Static nested Classes ?



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: