Tutor profile: Shreya P.
Subject: SQL Programming
: Write an SQL Query to print the name of the distinct employee whose DOB is between 01/01/1960 to 31/12/1975.
This SQL query is tricky, but you can use BETWEEN clause to get all records whose date fall between two dates. SELECT DISTINCT EmpName FROM Employees WHERE DOB BETWEEN ‘01/01/1960’ AND ‘31/12/1975'
Subject: Java Programming
Write a Java program to replace certain characters from String like public String replace(String str, char ch) Read more: http://www.java67.com/2012/08/10-java-coding-interview-questions-and.html#ixzz4Pp7plc61
This Java coding question can be solved in multiple way e.g. by using charAt() or subString() method, but any approach throws couple of follow-up question e.g. you may be asked to write two version to solve this coding exercise, one by using recursion and other by using Iteration. They may also ask you to write JUnit test for this function which means handling null, empty string etc. By the way this programming question is quite common on technical interviews not just Java but also C, C++ or Scala, but knowing API definitely helps to produce better solution quickly.
What is a Table in a database ?
A table is a collection of records of a specific type. For example, employee table, salary table etc.
needs and Shreya will reply soon.