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.
…
Q1. How would you go about judging the code quality of other developers? A1. 1) Code written with unit tests and progressively re-factored where necessary to make it more maintainable, testable, and readable. 2) Unit tests need to be written properly — … Read more ›...
Q: Create a simple framework where work items can be submitted using Java 8 or later. Here are the use cases: #1: A work item is an instance of a class. #2: The definition of “ … Read more ›...
This Java code review checklist is not only useful during code reviews, but also to answer an important Java job interview question, Q. How would you go about evaluating code quality of others’ work? This can judge a candidate’s real experience & … Read more ›...
Q1. What is DevOps? A1. Traditionally the developers & IT operations work in silos where the developers code, build, test & release the software artefacts and the IT operations deploy & monitor the applications. In DevOps a unified team apply the CI/CD practices with automation tools like Jenkins/Bamboo, … Read...
Firstly, the systems need to be designed well. For example, High level & low level system design considerations for read heavy systems vs High level & low level system design considerations for write heavy systems. The performance focus must start from high level design. Q1. … Read more ›...
Unlike J2EE, Java EE 6 consists of annotated classes without any dependencies on the platform. This approach eliminates the need to separate business logic from the infrastructure and makes the majority of J2EE patterns and best practices superfluous. The following J2EE design patterns can be obsolete: — Service Locator (Use...
Q: Write a program that takes any 10-digit phone number and produces a list of words matching first letters of the phone number (2 – ABC, 3 – DEF, .. 9 – WXYZ). Use any free word list file from online. A: The logic is to 1) Read a word...
This makes use of the Functional Programming (FP) approach. Q: Write a program that takes any 10-digit phone number and produces a list of words matching first letters of the phone number (2 – ABC, 3 – DEF, .. 9 – WXYZ). Use any free word list file from online....
Functional Programming (i.e. FP) is prevalent in Big Data (i.e. Spark programming, etc) roles. A must know for Big Data Engineers and Analysts. One needs to get used to the transformation from imperative programming to functional programming. You like it or not, … Read more ›...
Concurrency is very important in any modern system, and this is one topic many software engineers struggle to have a good grasp. The complexity in concurrency programming stems from the fact that the threads often need to operate on the common data. Each thread has its own sequence of execution,...
Q1 Why use mock objects in unit testing? A1 Unit testing is widely accepted as a “best practice” for software development. When you write an object, you must also provide an automated test class containing methods by calling its various public methods with various parameters and making sure that the...
Q116. What is “Spark streaming” in the Spark ecosystem with Spark core, Spark SQL, Spark MLlib, Spark GraphX, etc? A116. Spark is a distributed and scalable batch processing framework that supports in-memory processing in sub-seconds. The batch processes are scheduled with something like Oozie or Unix cron jobs to run...
I have a good news, I got job offer. I like to share with you from my bottom of my heart feeling thankful to you.