Blog Archives

♦ 6 JSON interview Q&A

Q1. What is JSON and how does it differ from an XML? A1. JSON (JavaScript Object Notation) is a lightweight, text-based, language-netral like XML, but less verbose than XML data exchange format. JSON is used in Web services to exchange…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in FAQs JEE, JSON, member-paid Tagged with: ,

♦ 15 Database design interview Questions & Answers

Q1. What is normalization? When to denormalize? A1. Normalization is a design technique that is widely used as a guide in designing relational databases. Normalization is essentially a two step process that puts data into tabular form by removing repeating…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, SQL Tagged with: , ,

♥ 14 Unix interview questions & answers for Java developers

Q1 How do you remove the Control-M characters from a file? A1 Using the sed command that replaces Control-M with nothing Note: The ^M is typed on the command line with ctrl+v and ctrl+M Q2 How will you search for

Posted in Tools, Unix Interview Q&As, Unix Tutorial Tagged with: ,

♥ Hidden Unix, Git & SVN config files

You need to use “ls -la” to list the hidden files in your home (i.e ~) directory. These config files are “.bashrc”, “.inputrc”, “.profile”, etc. In computing, a hidden folder or hidden file is a folder or file that does

Posted in Unix Interview Q&As

♥♦ Regular Expressions (aka Regex) by examples for Java developers

Q1 How will you go about implementing the following validation rules for a user name? — user name must be between 2 and 17 characters long. — valid characters are A to Z, a to z, 0 to 9, .

Posted in Regex

♦ 14+ SQL interview Questions & Answers

SQL interview Questions & Answers is a must for any developer as all non-trivial applications need to talk to a database with CRUD operations. Q3 is the most popular. Q1. Can you explain DDL statements in regards to SQL? A1.…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in FAQs JEE, member-paid, SQL Tagged with: , , , ,

♦ 9 Java Transaction Management Interview Q&A

Q1. What is a Transaction? A1. A transaction is a set of operations that should be completed as a unit. If one operation fails then all the other operations fail as well. Example 1: If you transfer funds between two…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in FAQs Java Key Areas, member-paid, NoSQL, Transaction Management Tagged with:

♦ 9 SQL scenarios based interview questions answered

Q1 How will you go about identifying duplicate records in a table? A1 The following SQL query will do the trick. Note: Interviewer is testing if you understand that the aggregate queries need to have a “group by” clause on

Posted in Judging Experience Q&As, SQL

10: ♥ Q80 – Q87 HBase Schema Design Interview Questions & Answers

Q80. Why is schema design for HBase is different from relational database design? A80. HBase is a columnar NoSQL database. This means no two rows in a table need to have the same columns. In a columnar database table, each

Posted in Hadoop, Spark & BigData Q&As, NoSQL

11 FAQ XSD interview questions and answers

Q1. How do you restrict an element in XSD? A1. With “xs:restriction”. In the XSD shown below, the “AddressType” is restricted to “Mailing”, “Office”, and “Home”. Q2. Can you explain as per the XSD shown above the term “targetNamespace”? A2.…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, XSD

13: ♦ Getting started with MySQL database beginner tutorial

All Java developers not only must know “SQL”, but also a database is required for “JDBC tutorials”, “Hibernate Tutorials”, and so on. Any decent Java application will require a database. So, your self-taught Java projects must perform CRUD (i.e. Create

Posted in MySQL Tutorial, Setting up & getting started tutorials, SQL, SQL Tutorial

3. Understanding HBase (NoSQL) database basics in 7 steps

Extends Getting started with HBase. HBase is a NoSQL database. HBase is a columnar database. #1. In HBase, you create the Table & column-families “create” command to create a table with column families. You can later on use “alter” to…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in HBase Tutorials, member-paid, NoSQL

Auditing database record changes in Oracle

Q. What are some of the considerations in auditing database table data? A. Creating audit tables without any constraints to store record changes.  Audit tables are heavily hit with inserts, hence needs to have fewer indices if at all required.

Posted in QoS, SQL Tagged with:

Deleting records in SQL Interview Questions and Answers

The following is a very popular SQL job interview question. Q. What is the difference between “Truncate” and “Delete” commands? A.  TRUNCATE TABLE_NAME always locks the table and page but not each row, whereas  DELETE statement is executed using a

Posted in SQL

JSON, Jackson, and Maven example

Step 1: Create a new simple-json project using Maven CLI. press “Enter” for all the prompts. This creates a new “simple-json” folder with MVN artefacts like pom.xml, etc. Step 2: Import the maven project into your IDE. E.g. in eclipse…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in JSON, member-paid

Regular Expressions interview Q&A for Java developers

Q1 What’s the difference between a wildcard and a regular expression? A1 A wildcard is a generic term referring to something that can be substituted for all possibilities. In computer terms, usually a simple “wildcard” is just a * that…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, Regex

sed and awk to write shell scripts for Java developers

Q. How would you go about replacing a piece of a text or a phrase from 20,000+ web templates residing on a Unix file system? Even some candidates with 5+ years of experience will be tempted to spend a day…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, Tools, Unix Interview Q&As

Shell script interview Q&A for Java developers

Q1 How will you go about reading a CSV file as shown below? A1 Q2 How will you read and then write to another file? A2 Q3 How will you read the file and then write to another file with…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, Unix Interview Q&As, Unix Tutorial

SQL Subquery interview questions and answers

Q. What is a subquery? A. Subquery or Inner query or Nested query is a query in a query. A subquery is usually added in the WHERE clause of the sql statement. A subquery can be nested inside a SELECT,

Posted in SQL

Transaction management in SQL — Sybase example

Q. How do you perform transaction management in SQL stored procedures? A. Handled with begin, commit, and rollback ‘tran’ commands in Sybase server. Q. Why is it important? A. It is important to leave the database in a consistent state. Q.

Posted in SQL, Transaction Management

Unix history commands for Java developer productivity

When you are using Linux/Unix command line frequently, using the history effectively can be a major productivity boost. You can accomplish things with less typing. For example, you will be typing lots of commands like and so on. There are

Posted in Tools, Unix Interview Q&As

Unix remoting interview Q&A for Java developers

Q1 How will you delete files that are older than 7 days in a remote unix server? A1 By ssh ing to the remote host server Q2 How will you copy files from a remote server to a local server?…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, Tools, Unix Interview Q&As, Unix Tutorial

Unix sed & awk commands in action

This extends sed and awk to write shell scripts for Java developers. Q2 Can you explain the following Unix command? A2 The “date” prints the date and time. The “ps -ef” outputs all the running processes with the UID (user

Posted in Unix Interview Q&As

Unix Sed commands for Java developers

sed (stream editor) is one of the powerful workhorse commands in UNIX. Recently I had to use it with “Git” and “Maven” to find text “SNAPSHOT” in all pom.xml files, and manually update them with a realease version like 1.0.2

Posted in Tools, Unix Interview Q&As, Unix Tutorial

XML basics interview Q&A

Q1. What is an XML? A1. XML stands for eXtensible Markup Language. XML is a grammatical system for constructing custom markup languages for describing business data, mathematical data, chemical data etc. XML loosely couples disparate applications or systems utilizing JMS,…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, XML Tagged with:

XML Processing Interview Q&A

Q1. What libraries can you use in Java to process XML documents? A1. #1. DOM Parser loads the whole XML structure into memory, and you can read and write. This is useful for smaller XML documents which don’t impact memory…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, XML Tagged with: ,

XSD reuse interview questions and answers

#1. Reuse by defining a “ComplexType”. EmployeeType is reused. Once JAXB annotated classes are created XML output: #2. Inheritance reuse where sub types can define additional elements like “salary”, “contractRate”, etc. Once the JAXB annotated classes are created XML output:…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Companion, 90-Day-Java-JEE-Career-Companion, 180-Day-Java-JEE-Career-Companion, 365-Day-Java-JEE-Career-Companion and 2-Year-Java-JEE-Career-Companion Log In | Register | Try free FAQs | Home
Posted in member-paid, XSD

YAML with Java using the SnakeYaml library tutorial

Step 1: Add “snakeyaml” to maven pom.xml as a dependency Step 2: Define a YAML file under src/main/resources. For example, “logging.yml” Step 3: Create a LoggingConfiguration Java POJO class. Step 4: Finally, the main class that uses the Yaml library

Posted in YAML, YAML Tutorial

YAML with Spring & Java Q&As

Q1. What is YAML? A1. YAML Ain’t Markup Language. It is a human friendly data serialization standard for all programming languages. A YAML file has an extension of “.yml“. Q2. What are the 3 rules of YAML? A2. Rule 1:

Posted in YAML

Brush-up or learn the basics that will fast-track your career

open all | close all

100+ Java Tutorials by topics

open all | close all