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. |
|
|||
|
| ||||
| Interview Questions and Answers for 'Nityo infotech' - 2 question(s) found - Order By Rating | ||||
| ||||
| Ans. When a Table Join itself , it's a Self Join. For example - we like to know the pair of department names where first dept has lesser employees than the later. Select D1.name , D2.name from Dept D1, Dept D2 where D1.employee_count < D2.employee_count | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
 Discuss Correct / Improve  sql joins self join self-join Pair of employee names with first having lesser salary than later Pair of department names where first dept has lesser employees than the later  Asked in 26 Companies  basic  frequent | ||||
 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 ? | ||||
| 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 ? | ||||
 Very frequently asked. Among first few questions in almost all interviews. Among Top 5 frequently asked questions. Frequently asked in Indian service companies (HCL,TCS,Infosys,Capgemini etc based on multiple feedback ) and Epam Systems | ||||
| ||||
| Ans. "equals" is the method of object class which is supposed to be overridden to check object equality, whereas "==" operator evaluate to see if the object handlers on the left and right are pointing to the same object in memory. x.equals(y) means the references x and y are holding objects that are equal. x==y means that the references x and y have same object. Sample code: String x = new String("str"); String y = new String("str"); System.out.println(x == y); // prints false System.out.println(x.equals(y)); // prints true | ||||
 Sample Code for equals | ||||
| Help us improve. Please let us know the company, where you were asked this question : | ||||
| Discuss Correct / Improve java string comparison string object class == equals object equality operator == vs equals equals vs == Asked in 294 Companies basic frequent | ||||
 Try 6 Question(s) Test | ||||
| Related Questions | ||||
| What is the difference between = and == in Java ? | ||||
| How is == operator different for objects and primitive types ? | ||||
| What will be the output of following code Integer x = 1; Integer y = 2; System.out.println(x == y); What if you change 1 to "1" and Integer to String? | ||||
