Key Management Group Interview Questions and Answers

Functions in SQL are reusable code blocks that perform a specific task and return a value.

• Functions can be built-in (provided by the database system) or user-defined.

• They can accept input parameters and return a single value or a table of values.

• Examples of built-in functions include SUM(), AVG(), and GETDATE().

SUM in window functions calculates the sum of a specified column over a window of rows.

• Calculates the sum of a specified column over a window of rows

• Can be used with other window functions like ROW_NUMBER, RANK, etc.

• Example: SELECT SUM(sales) OVER (PARTITION BY department) AS department_total_sales FROM sales_data;

The father of computer is considered to be Charles Babbage.

• Charles Babbage is known for his work on the Analytical Engine, a mechanical general-purpose computer.

• He is often referred to as the 'father of the computer' due to his contributions to the concept and design of programmable computers.

• Babbage's ideas and designs laid the foundation for modern computers and computing technology.

• His work influenced subsequent pio...read more

Python was developed in 1991.

• Python was created by Guido van Rossum in 1991.

• The first version of Python, Python 0.9.0, was released in February 1991.

• Python's development was motivated by the desire to have a language that was easy to read and write.

HTML abbreviations are short forms used in HTML coding for easier and faster writing.

• HTML - HyperText Markup Language

• CSS - Cascading Style Sheets

• JS - JavaScript

• API - Application Programming Interface

Tim Berners-Lee developed HTML (Hypertext Markup Language).

• HTML was developed by Tim Berners-Lee in 1991.

• It is the standard markup language for creating web pages.

• HTML uses tags to structure content and define elements on a webpage.

There are 7 OSI layers in the OSI model.

• There are 7 layers in the OSI (Open Systems Interconnection) model.

• Each layer has a specific function and interacts with adjacent layers.

• Examples of OSI layers include Physical, Data Link, Network, Transport, Session, Presentation, and Application layers.

Python is versatile, easy to learn, has a large community support, and is widely used in networking for automation and scripting.

• Python is versatile and can be used for a wide range of tasks in networking such as automation, scripting, and network monitoring.

• Python has a simple and readable syntax, making it easy to learn and use for network engineers.

• Python has a large community support with a vast number of libraries...read more

OSPF is a link-state routing protocol while BGP is a path vector routing protocol.

• OSPF is used within an autonomous system, while BGP is used between autonomous systems.

• OSPF calculates the shortest path based on link cost, while BGP selects the best path based on policies and attributes.

• OSPF uses Dijkstra algorithm for routing, while BGP uses the path vector algorithm.

• OSPF is typically used in internal networks, while ...read more