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...
Java & Big Data career companion to fast-track & go places with lots of code, scenarios based Q&As & industry strength know-hows
Blog Archives
15+ SQL optimisation interview questions & answers with scenarios
1) Select fields instead of using SELECT *. The “*” is used as a short hand to query all available data from a table. … Read more ›...
15+ SQL scenarios based interview Q&As – part 1
Q01 How will you go about identifying duplicate records in a table?
A01 This is a very popular interview question because there are many approaches,
…
15+ SQL scenarios based interview Q&As – Part 2
This extends Q01 – Q03 at 15+ SQL scenarios based interview questions answered. Q04 When you have a table that maintains history of record updates, … Read more ›...
15+ SQL scenarios based interview Q&As – Part 3
This extends 15+ SQL scenarios based interview Q&As – Part 2. Q07 In What order the SELECT SQL statements are executed? … Read more ›...
18 SQL best practices interview Q&As
#1. Use uppercase for the keywords like SELECT, FROM, JOIN, GROUP BY, WHERE, etc. It’s also a good practice to use uppercase for the SQL functions like UPPER(col_name),
…
Common Table Expressions (i.e. CTE) in SQL using the “WITH” clause
Common Table Expressions or CTE’s for short are used in SQL to simplify complex joins and subqueries, and to provide a means to query hierarchical data such as an organisational...
SQL analytic functions interview questions – Part 1
Data Engineers & analysts must know the analytic functions applied over a window of rows is a powerful tool to analyse the data. This post compliments “Apache Spark window functions”...
SQL analytic functions interview questions – Part 2
This extends SQL window function for analytical queries interview questions – Part 1 Analytic function construct The analytic function names can be RANK(), … Read more ›...
SQL analytic functions interview questions – Part 3
This extends SQL analytic functions interview questions – Part 2 and SQL analytic functions interview questions – Part 1. The below example was created in IMPALA SQL engine with Common...
SQL querying Temporal tables & SCD Type 2
Q1. What is a temporal table? A1. Temporal tables store and maintain information with respect to time. … Read more ›...
SQL retrieving the latest records interview Q&As
This question can reveal a lot about your ability to write SQL queries as different approaches can be used and there will be drill down on pros and cons of...
Contact us: java-interview@hotmail.com
Latest posts by Arulkumaran Kumaraswamipillai (see all)
- 18 SQL best practices interview Q&As - August 16, 2022
- What does this Unix code snippet do? - July 2, 2022
- 00: 13 Data Warehouse interview Q&As – Fact Vs Dimension, CDC, SCD, etc – part 2 - April 28, 2022
Responsive WordPress Theme powered by CyberChimps
Top
