Blog Archives
1 2 3 4 5 8

00: 18+ SQL best practices interview Q&As

It is a must to know the order in which the SQL clauses are executed. This is demonstrated with an example below in #5. Have this order of execution visibly pinned and understood. SQL is very easy to learn, but lots of hands-on experience is required to master:

1) to translate business requirements into SQL.… Read more ...

Tags:

00: 25+ SQL interview questions & answers – beginner

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 – Q15 are very popular with the interviewers.

If you want to quickly practice your SQL skills try DB Fiddle or install MySQL locally as shown in the MySQL database getting started.… Read more ...

Tags:

00: 25+ SQL interview questions & answers – intermediate to experienced

This continues 25+ SQL interview questions & answers – beginner Q16. Why do you have CASE statements in SQL? A16. CASE statements in SQL are similar to IF and ELSE conditions in programming languages. CASE statements are used to fetch particular values based on certain conditions.

In the above…

Read more ...


01: 12 Maven interview Questions & Answers

Q1. What is the difference between snapshot versions and release versions? A1. The term “SNAPSHOT” means the build is a snapshot of your code at a given time, which means downloading 1.0-SNAPSHOT today might give a different file than downloading it tomorrow or day after. When you are ready to…

Read more ...


01: 12+ Git Source control must know basics interview Q&As

Q1. How does Git differ from SVN (i.e Subversion)?
A1.

#1. Git is a distributed source control system meaning that there will be multiple client repositories. SVN is one repository with lots of clients. GIT is decentralized to a point where people can track their own edits locally without having to push things to an external server.… Read more ...

Tags: ,

01: 14 Unix must-know interview questions & answers

Q1 How do you remove the Control-M characters from a file?
A1 Control-M is a carriage return on keyboard. The ^M is the keyboard equivalent to \r. In a file originated from DOS/Windows the \r\n is used for an end of line carriage return, whereas in Unix it is \n for a new line.… Read more ...

Tags: ,

01: 21 Docker DevOps interview Q&As

Docker, Jenkins, CI/CD, & DEV/OPS have been the buzz words for the last several years. You will be seeing this in more often in the job requirements as well. Docker Tutorial – compile & run Helloworld.java. Q1. What is a Docker container, and what does it enable you to do?…

Read more ...


01: 50+ SQL scenarios based interview Q&As on identifying & deleting duplicate records

50+ SQL interview questions and answers to solve real business scenarios. SQL is widely used in building microservices & Big Data projects. Learning SQL syntax is easy, but being able to convert a given business requirement into a query takes lots of practice. These scenarios based interview questions can assesses your experience.… Read more ...

Tags: ,

01: AWS interview Q&As on VPC, Subnets, Availability Zones, VPN, Route tables, NACLs & Security Groups

This extends Architecture Networking. The above diagram addresses many of the questions that follow. Q1. What is a VPC in AWS? A1. A virtual private cloud (VPC) is a virtual network dedicated to your AWS account. It is logically isolated from other virtual networks in the AWS Cloud. You can…

Read more ...


01: Azure interview Q&As on Region, VNet, Subnets, AZs, Availability Set, etc

This extends Architecture Networking. The below diagram will help you understand many of the following questions. Q01. What do you understand by the Azure terms Tenant, Subscription, Region, Resource Groups and Availability Zones ? A01. A Tenant in Azure represents an Organisation. It refers to a single instance of Azure…

Read more ...


01: JavaScript Vs Java interview Q&As

The client-side JavaScript based MVW (Model View Whatever) frameworks like AngularJS, Backbone, CanJS, Ember, etc have become mainstream and replacing server side Java based frameworks like JSF, Struts, Spring MVC. So, time to get a better handle on JavaScript and market yourself as a full stack Java developer. Q1. What…

Read more ...


01: Networking basics interview Q&As on ip address, subnet mask, DNS & gateway

Q. Do software developers & Architects need to know networking?
A. The answer is Yes for both, but architects must know certain concepts more than the developers. Architects need to liaise with network, cloud, dev ops, and site engineers.

Networking is a very vast subject. Knowing some basic fundamentals will make you a better developer.… Read more ...



01: Unix interview Q&As for data engineers – part 1 sed & find

Experienced developers & data engineers are lazy and use the right tools & know-hows to get the tasks done quickly & effectively on the job.

Q01 What Unix commands are handy for the data engineers?
A01 find, grep, sed, and awk are very handy for data engineers.

Q02 How will you go about approaching the below problem statement?… Read more ...



01: Unix interview Q&As for data engineers – part 2 cat, grep, gunzip & wc

Experienced developers & data engineers are lazy and use the right tools & know-hows to get the tasks done quickly & effectively on the job. Unix interview Q&As for data engineers. Problem Statement Given a zipped file with below content having both meta data & actual content, the task is…

Read more ...


01: Unix interview Q&As for data engineers – part 3 grep

Experienced developers & data engineers are lazy and use the right tools & know-hows to get the tasks done quickly & effectively on the job. Unix interview Q&As for data engineers – part 2. Problem Statement When you have 100s of log files, how will you go about searching for…

Read more ...


01: Unix interview Q&As for data engineers – part 4 locate & find

Experienced developers & data engineers are lazy and use the right tools & know-hows to get the tasks done quickly & effectively on the job. Problem Statement How will you search for a file location by name? For example, where are my log files? Under which folder is mysql installed?…

Read more ...


01: Unix interview Q&As for data engineers – part 5 xargs

This extends Unix interview Q&As for data engineers – part 4 locate & find. Where to use xargs? xargs can be used when you need to take the output from one command and use it as an argument to another. grep, sed and awk takes the data from standard input,…

Read more ...


01: Unix interview Q&As for data engineers – part 6 awk

This extends Unix interview Q&As for data engineers – part 6 cut and awk. awk format The “action” is performed if the pattern matches.

For example: Given the below csv data file “my_data.csv”

Read more ...


01: Unix interview Q&As for data engineers – part 6 cut and awk

cut & awk Unix commands are used to extract sections from each line of text. cut vs. awk cut accepts a single-character delimiter, and is suitable only for very simple text file formats whereas awk is much more versatile, and can handle somewhat more complex field delimiter definitions including regular…

Read more ...


02: 20+ Kubernetes (aka K8s) interview questions & answers

Q1. What is the difference between Docker & Kubernetes? A1. Docker & Kubernetes can function without each other, and also both can compliment each other. Docker enables us to run, create and manage containers on a single operating system. If you have Docker installed on a number of hosts with…

Read more ...


1 2 3 4 5 8

500+ Java Interview FAQs

Java & Big Data Tutorials

Top