Q1. How do window functions work and when do you use them?
Window functions compute a value across a set of rows related to the current row without collapsing them, unlike GROUP BY. They preserve row granularity. ```sql SELECT us...
Technical Question Bank · Peer-Reviewed
Job Interview Questions and Answers Directory
Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (78 available).
Active:
Tag: functions ×
Q2. When would you use Azure Functions versus App Service?
Both can host code, but they optimise for different workloads. Azure Functions is serverless and event-driven: - Consumption or Premium plans scale to zero and bill per e...
Q3. What are extension functions and what are their limitations?
An extension function adds a method to a class without modifying or inheriting it. Resolution is static. ```kotlin fun String.toTitleCase(): String = split(" ").joinToStr...
Q4. How do higher-order functions and inline functions work?
A higher-order function takes a function as a parameter or returns one. Functions are first-class values with types like `(Int) -> Int`. ```kotlin fun List.myFilter(predi...
Q5. Compare the scope functions let, run, with, apply and also.
All five run a block with an object in context. They differ in how the object is referenced (`it` or `this`) and what they return (the object or the lambda result). - `le...
Q6. How does defer work in Go and what are the common pitfalls?
`defer` schedules a function call to run when the surrounding function returns. Deferred calls run in LIFO order and are typically used for cleanup such as closing files ...
Q7. What are lambda expressions or arrow functions?
**Arrow functions** (also known as "lambda expressions") provide a concise syntax for writing function expressions in JavaScript. Introduced in ES6, arrow functions are o...
Q8. What is a first class function?
In JavaScript, **first-class functions(first-class citizens)** mean that functions are treated like any other variable. That means: 1. You can assign a function to a vari...
Q9. What is the currying function?
**Currying** is the process of transforming a function with **multiple arguments** into a sequence of **nested functions**, each accepting **only one argument** at a time...
Q10. What are the benefits of pure functions?
Some of the major benefits of pure functions are listed below, - **Easier testing:** Since output depends only on input, pure functions are simple to test. - **Predictabi...