InterviewRack - Interview preparation material, concepts

Consider the following relational schema. An employee can work in more than one department; the pct_time filed of the Works relation shows the percentage of time that a given employee works in a given department. Emp( eid: integer , ename: string , age: integer , salary: real ) Works( eid: integer , did: integer , pct_time: integer ) Dept( did: integer , dname: string , budget: real , managerid: integer ) Write the following queries in SQL: Print the names and ages of each employee who works in both the Hardware department and the Software department. For each department with more than 20 full-time-equivalent employees (i.e., where the part-time and full-time employees add up to at least that many full- time employees), print the did together with the number of employees that work in that department. Print the name of each employee whose salary exceeds the budget of all of the departments that he or she works in. ...

The following relations keep track of airline flight information: Flights( flno: integer , from: string , to: string , distance: integer , departs: time , arrives: time , price: integer ) Aircraft( aid: integer , aname: string , cruisingrange: integer ) Certified(eid: integer , aid: integer ) Employees( eid: integer , ename: string , salary: integer ) Note that the Employees relation describes pilots and other kinds of employees aswell; every pilot is certified for some aircraft, and only pilots are certified to fly.Write each of the following queries in SQL. Find the names of aircraft such that all pilots certified to operate them earn more than $80,000. For each pilot who is certified for more than three aircraft, find the eid and the maximum cruisingrange of the aircraft for which she or he is certified. Find the names of pilots whose salary is less than the price of the cheapest route from Los Angeles to Honolulu. ...

In any real world application, DBMS plays a key role for managing your data. Its very important to have a strong idea about these topics and have a handson with this. Important topics that needs to be covered to prepare any dbms interviews are as below. Core Concepts:  Normalization forms - Questions related to designing a database for a real world application will be asked. They test your design skills. You need to be thorough with 3N form designing. Other questions related 1N,2N forms can be expected.  Query questions - Select, Insert, Updated , Delete related questions with combinations of joins will be asked. Following combinations will be asked.  Inner Join Outer join Self join Group By ,  Having clause Between, In, Like IsNull, Null Union Intersect Basics of PL/Sql. Inbuilt sql functions. How indexing works internally.  Few basics of distributed mysql management.  So make sure you are clear with above concepts befor...

These are some of the important concepts you need to be very clear with , when you attend any interviews for bigger companys. Try to understand each of these concepts with some real world examples.  Basic Concepts: Class vs Interface vs Abstract class.  Static variables. final variables. Access modifiers - Public, Private, Default, Protected.  Immutable Strings and String manipulation concepts. Object lifecycle - How objects are created and destroyed. Threads: Thread Dump analysis Producer Consumer problem Dead lock problem Synchronisation Thread creation lifecycle Priority Sleep IsAlive Join Core: JVM Internals ClassLoaders Reflections Periodic task threads GC threads Compiler threads Signal dispatcher thread Design Patterns: Singleton Adapter Lazy loading Builder vs fluent  Observer Patterns Heap Management: Young Generation Old Generation (also called Tenured Generation) Permanent Generat...

     For all Java interiews, Sun SCJP exams its important to know the core concepts. Go through the below material. You can find detailed questions which will help you get cleared about may topics. Java Study Material

Producer consumer problem is one of the most important problems which is asked in many interviews. Simplest way to solve this problem is to use Blocking Queue. Code can be viewed here. import java.io.File; import java.util.concurrent.BlockingQueue; import java.util.concurrent.LinkedBlockingQueue; public class ProducerConsumer { public static void main(String args[]) { // Creating shared object BlockingQueue<String> sharedQueue = new LinkedBlockingQueue<String>(2); // Note the Same sharedQueue is being passed to Producer as well as // Consumer // Creating Producer and Consumer Thread Thread prodThread = new Thread(new Producer(sharedQueue), "ProcuerThread"); Thread consThread = new Thread(new Consumer(sharedQueue), "ConsumerThread"); // Starting producer and Consumer thread prodThread.start(); consThread.start(); } } // Producer Class in java class Producer implements Runnable { private final Blocking...

import java.io.FileInputStream; import java.io.FileNotFoundException; import java.util.Scanner; import java.util.StringTokenizer; public class LineWordCount { public void calculate(String fileName) throws FileNotFoundException { long lineCount = 0; long wordCount = 0; Scanner scanner = null; try { scanner = new Scanner(new FileInputStream(fileName)); while (scanner.hasNextLine()) { String line = scanner.nextLine(); lineCount++; wordCount += new StringTokenizer(line, " ").countTokens(); } } catch (Exception ex) { ex.printStackTrace(); } finally { if (scanner != null) { scanner.close(); } } System.out.println(lineCount + "," + wordCount); } public static void main(String[] args) throws FileNotFoundException { String fileName = "filepath/file.txt"; new LineWordCount().calculate(fileName); } }