Q631. Can we rename a column in output?
Yes, using `AS` (alias): ```sql SELECT first_name AS fname, last_name AS lname FROM customers; -- AS is optional but recommended for readability: SELECT first_name fname ...
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 (2,728 available).
Q632. What are Python decorators?
A **decorator** in Python is a design pattern that dynamically alters or extends the behavior of a function or class without permanently modifying its source code. In Pyt...
Q633. What are the different types of input field in HTML?
The HTML `` element is one of the most versatile form controls, determined by its `type` attribute: ### Common Input Types and Behaviors: 1. **`text`**: Standard single-l...
Q634. How can you define custom types or interfaces in TypeScript?
In TypeScript, custom types can be defined using interfaces or type aliases. Interfaces define the structure of an object and can be implemented by classes, while type al...
Q635. What is a higher order function?
A higher-order function is a function that either accepts another function as an argument, returns a function as its result, or both. This concept is a core part of JavaS...
Q636. What are inline conditional expressions?
You can use either _if statements_ or _ternary expressions_ which are available in JS(and JSX in React) to conditionally execute or render expressions. Apart from these a...
Q637. How would you design a recommendation system end to end?
Start with the objective and data: implicit signals such as views, clicks and purchases, plus explicit ratings and item or user features. A common two-stage design: - Can...
Q638. What is file based routing in Next.js?
**File-based routing** is an architectural pattern where application URL routes are inferred automatically from the folder and file hierarchy on the filesystem, eliminati...
Q639. What are the different API styles available?
The Vue components can be created in two different API styles 1. **Options API:** The Options API uses component logic using an object of options such as `data`, `props`,...
Q640. How to select FirstName from Customers?
To retrieve only the `FirstName` column from the `Customers` table, use the standard `SELECT` projection statement: ```sql SELECT FirstName FROM Customers; ``` ### Perfor...