10+ University of Sussex Interview Questions and Answers

In SQL, data is grouped by a specified column or expression using the GROUP BY clause.

• Data is grouped based on the values in the specified column or expression

• Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group

• GROUP BY is often used in conjunction with the SELECT statement

• Example: SELECT department, AVG(salary) FROM employees GROUP BY department

Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.

• Lists are accessed by index, dictionaries are accessed by key

• Lists maintain the order of elements, dictionaries do not guarantee order

• Lists use square brackets [], dictionaries use curly braces {}

• Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}

The 'this' keyword refers to the current object and is used to access its properties and methods.

• Used to refer to the current object in a method or constructor

• Can be used to call another constructor in the same class

• Can be used to call a method of the same object

• Can be used to call a method of a parent object

• Can be used to bind a function to a specific object

Web development is like building a house on the internet where people can visit and do things.

• Web development is creating websites and web applications using programming languages like HTML, CSS, and JavaScript.

• It involves designing how the website looks and works, and making sure it works well on different devices like computers and phones.

• Examples of web development include creating a website for a business, an online store, or a social media platform.

Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.

• Lambda functions are defined using the lambda keyword.

• They are commonly used for small, one-time tasks.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: add = lambda x, y: x + y