Database and SQL

Aggregate functions like SUM and AVG ignore NULL values by default. The NVL function converts NULL values to a specified non-null value (like 0), allowing those converted values to be included in aggregate calculations.

SQL requires that any column in the SELECT list that is not part of an aggregate function must be included in the GROUP BY clause. This ensures each row in the result represents a distinct group summary.

The HAVING clause filters grouped results after the GROUP BY operation, while WHERE filters individual rows before grouping. HAVING can use aggregate functions like COUNT, SUM, or AVG, which WHERE cannot.

The WHERE clause filters rows from a table before any grouping or aggregation occurs. It applies row-level filtering based on specified conditions.

The SELECT statement performs projection (selecting specific columns), selection (filtering rows with WHERE), and joining (combining data from multiple tables). These are the three fundamental capabilities of SQL queries.

In SQL, the asterisk (*) wildcard character is used in the SELECT clause to specify that all columns from the target table should be returned. Options using "all columns" or "distinct columns" are syntactically invalid in standard SQL.

The statement fails because string literals in SQL must be enclosed in single quotes, not double quotes. The correct syntax would be WHERE ename = 'Scott'. Double quotes are typically used for identifiers like column or table names.

SQL stands for Structured Query Language. It's the standard language for relational database management systems, used for querying, manipulating, and defining data structures in databases.

The DISTINCT keyword is used in a SELECT statement to eliminate duplicate rows from the result set. For example, SELECT DISTINCT department FROM employees returns each department only once, regardless of how many employees belong to it.

Subqueries are categorized into two main types based on the number of rows they return: single-row subqueries (which return exactly one row and use single-row operators like =, >, <) and multiple-row subqueries (which return multiple rows and require operators like IN, ANY, or ALL).

A single-row subquery is designed to return exactly one row from the inner query. This type of subquery can be used with single-row comparison operators like =, >, <, etc. Options B and C are incorrect because they describe multi-row or no-row scenarios, while D is false as single-row subqueries are a valid SQL construct.

The subquery uses GROUPBY (should be GROUP BY) on Rollnum, which returns one minimum mark value per unique Rollnum - potentially multiple rows. The outer query uses the single-row comparison operator = with stud_marks, expecting exactly one value. When the subquery returns multiple rows (one per Rollnum group), this creates a mismatch and triggers the 'single-row subquery returns more than one row' error.

ALL is a SQL operator that compares a value to EVERY value returned by a subquery. For example, 'salary > ALL (SELECT salary FROM employees)' means the salary must be greater than every salary in the subquery results. IN checks membership in a set, ANY checks if the condition is true for at least one value, and OF is not a comparison operator.

DML (Data Manipulation Language) statements include INSERT (add new rows), UPDATE (modify existing rows), and DELETE (remove existing rows). Since all three operations are DML statements, 'All of the above' is correct. DML commands specifically manipulate data stored in database tables.

The correct SQL syntax for inserting a row is 'INSERT INTO tablename VALUES (...)' or 'INSERT INTO tablename (columns) VALUES (...)'. Option C shows the basic form with VALUES clause. Options A and B use incorrect syntax ('Insert to' and 'Insert into table' instead of 'INSERT INTO'). D is incorrect because not all forms shown are valid.