Here’s my Amazon.com review for Beginning SQL Queries by Clare Churcher
This is an excellent book to turn you into a SQL professional but not an expert. This isn’t a book for complete beginners but for a person with some experience with databases. In other words, someone around the beginning to intermediate level because this book is all about SQL Queries and not how to setup, maintain and configure your database system.
Anyhow, this book focuses on SQL and not a specific Relational Database Management System (RDBMS). So check out another book if you’re primarily focused on Oracle, MySQL or any other RDBMS. However, she does go over a few differences between vendors when it comes to SQL queries.
I bought this book to review SQL and clarify a few concepts. Now after finishing this book, I feel that my goals has been reached. I really enjoyed this reading this book, because Clare is an effective writer who provides clear and concise examples with helpful explanations. For example, she provides annotations on screen captures of tables from Access and MS Server instead of only writing a description of a query. Even though the chapters were short and fast-paced, I was never stretching my head too long to understand what was going on.
The only negative thing about this book is the queries don’t have any semi-colons at the end.
I recommend this book for anyone taking a database course or anyone who wants a simple overview of SQL.
All the table example data is listed after chapter 11. I suggested that you store that in your database before reading this book and so you can follow along easily.
This post is in response to 15 Must Know Java Interview Questions After 2 Years of Experience.
Note: Only short responses are provided for the questions.
If you feel that more depth or a correction is needed then visit the links or leave a comment below.
Core Java Questions with answers:
- What is the purpose of serialization?
Answer: Serialization is the conversion of an object to a series of bytes, so that the object can be easily saved to persistent storage or streamed across a communication link. The byte stream can then be deserialised – converted into a replica of the original object.
Source | Example
- What is the difference between JDK and JRE?
Answer: Java Development Kit (JDK) is the most widely used Java Software Development Kit. Java Runtime Environment (JRE) is an implementation of the Java Virtual Machine which executes Java programs.
Source | JDK Wiki | JVM Wiki
- What is the difference between equals() and “==” ?
Answer: Equals is intended to check logical equality and == checks if both references point to same object. (Thanks Sandeep)
a == b; // Compares references, not values.
a.equals(b); // Compares values for equality.
- When will you use Comparator and Comparable interfaces?
Answer: java.util.Comparator and java.lang.Comparable
java.util.Comparator compares some other class’s instances, while java.lang.Comparable compares itself with another object.
Source | Example
- What is the wait/notify mechanism?
Answer: This deals with concurrent programming. The wait() and notify() methods are designed to provide a mechanism to allow a thread to be block until a specific condition is met.
However, java.util.concurrent should be used instead of wait() and notify() to reduce complexity.
Source | Java API | Java Technical Article
- What is the difference between checked and unchecked exceptions?
In general, unchecked exceptions represent defects in the program (bugs), which are normally Runtime exceptions.
Furthermore, checked exceptions represent invalid conditions in areas outside the immediate control of the program.
- What is the difference between final, finally and finalize?
Answer: “final” is the keyword to declare a constant AND prevents a class from producing subclasses. (Thanks Tom Ellis)
“finally” is a block of code that always executes when the try block is finished, unless System.exit() was called. finalize() is an method that is invoked before an object is discarded by the garbage collector.
Source | Final Usage |Finally Usage | Finalize()
- What is the difference between web server and app server?
Answer: A Web server exclusively handles HTTP requests, whereas an application server serves business logic to application programs through any number of protocols.
- Explain the Struts1/Struts2/MVC application architecture?
Answer: Struts was adopted by the Java developer community as a default web framework for developing web applications
The MVC(Model–view–controller) an application that consist of three distinct parts. The problem domain is represented by the Model. The output to the user is represented by the View. And, the input from the user is represented by Controller.
- What is the difference between forward and sendredirect?
Answer: Both method calls redirect you to new resource/page/servlet. The difference between the two is that sendRedirect always sends a header back to the client/browser, containing the data in which you wanted to be redirected.
- How does a 3 tier application differ from a 2 tier one?
Answer: Tiers are the physical units of separation or deployment, while layers are the logical units of separation.
Imagine that you’re designing an e-commerce website. A 3 tier architecture would consist of web pages, a web server and a database, with the corresponding 3 layers being the “Presentation”, “Business Logic” and “Database” layers.
If you take the database tier and layer out then your have a 2 tier architecture.
- How does the version control process works?
Answer: Initiate, pull, branch, merge, commit, push.
(Init) Make your own repository. (Pull) Download an existing repository from a url. (Branch / Merge )Make revisions. Commit then push your modifications.
Git Cheat Sheet
- What is the difference between JAR and WAR files?
Answer: JAR files (Java ARchive) allows aggregating many files into one, it is usually used to hold Java classes in a library.
WAR files (Web Application aRchive) stores XML, java classes, and JavaServer pages for Web Application purposes.
- What is a Left outer join?
Answer: This deals with SQL. Left outer join preserves the unmatched rows from the first (left) table, joining them with a NULL row in the shape of the second (right) table.
Source | Joins Wiki
- What is the difference between UNION and UNION ALL?
Answer: This deals with SQL. UNION only selects distinct values, UNION ALL selects all values.
Source | Example
Check out Effective Java (2nd Edition) to fresh up your Java skills.