SQL Functions and Joins

In Oracle SQL, you cannot directly nest group functions like AVG(MAX(salary)) at the same level. Group functions return a single value per group, so nesting them directly doesn't make logical sense. However, you can use group functions in subqueries or the HAVING clause where they operate on different grouping levels. The claimed answer 'False' is correct.

A Cartesian product (cross join) occurs in multiple scenarios: when you omit the join condition entirely, when the join condition is invalid (e.g., comparing incompatible data types), or when you explicitly write a cross join. In all these cases, every row from the first table is joined with every row from the second table. Therefore 'All of the above' is correct.

In join conditions, specifying table names is NOT mandatory when column names are unambiguous. If a column name exists in only one of the joined tables, you can reference it directly without the table prefix. Table prefixes (or aliases) are only required when column names are ambiguous (exist in multiple tables). The claimed answer 'False' is correct.

To join N tables together, you need at minimum N-1 join conditions. This is because each join reduces the number of unconnected tables by one. Starting with 10 tables, you need 9 joins to connect them all into a single result set. For example: (T1 JOIN T2) JOIN T3 ... JOIN T10 requires 9 joins.

A non-equi-join is defined as a join condition that uses comparison operators other than equality (=). These include operators like <, >, <=, >=, <>, BETWEEN, LIKE, etc. For example, finding employees whose salary is greater than the department average uses a non-equi-join. The statement is accurate, so 'True' is correct.

You CAN sort SQL results by column alias - this is a standard SQL feature. The ORDER BY clause can reference column aliases defined in the SELECT list, even though the alias doesn't exist in the original table. This is because ORDER BY is logically processed after SELECT, so the aliases are available. The statement claims sorting by alias is not possible, which is false.

SQL functions are categorized into two main types: single-row functions (which operate on each row independently) and multiple-row functions (also called aggregate or group functions) which operate on groups of rows. Options A and B invent non-existent categories. This classification is fundamental to understanding SQL function behavior.

Single-row functions return exactly ONE result per input row, not multiple results. This is why they're called 'single-row' functions - they maintain a one-to-one relationship between input rows and output rows. They may transform the data (change data type, format, etc.), but they never produce multiple output rows from a single input row. Multiple-row functions (aggregates) can reduce many rows to one result, but single-row functions do not.

TRUNC truncates without rounding, so TRUNC(99.57,1) = 99.5. ROUND rounds to nearest, so ROUND(99.57,1) = 99.6. Option A shows the original value and a truncated 99.6 (wrong). Option C shows both as 99.6 (both rounded, wrong). Option D shows original values unchanged (wrong).

While an inner join only returns rows with matching values in both tables, an outer join also retrieves rows from one or both tables that do not have a corresponding match in the other, filling missing values with NULL. This makes it ideal for finding unmatched records.

In Oracle SQL, the (+) operator is used for outer joins in the WHERE clause syntax. For example, WHERE table1.column = table2.column(+) indicates a right outer join (rows from table2 are preserved). The (-) and * and + alone are not outer join operators.

A self-join joins a table to itself, typically to compare rows within the same table. It requires table aliases to distinguish the two instances of the table. Outer join returns all rows from one table plus matching rows from another. Inner join returns only matching rows. Equi-join is a join using = operator.

To solve this question, the user needs to know the definition of a null value. A null value typically represents a missing or unknown value, and it is not the same as a zero or a blank space.

Option A - True: This option is incorrect. A null value is not equivalent to zero or a blank space. In programming, null is often used to indicate the absence of a value or a missing value.

Option B - False: This option is correct. A null value is not the same as zero or a blank space. It is a distinct value that represents an absence of data.

Therefore, the correct answer is:

The Answer is: B. False

ROUND(1111.93412,3) rounds to 3 decimal places. The fourth decimal is 1, which is less than 5, so we round down. Result: 1111.934. Option A shows integer rounding, B shows 2 decimals, C shows no change (original number).

MOD function returns the remainder after division. For example, MOD(10,3) = 1 because 10/3 = 3 remainder 1. Option A describes division with quotient (that's just / operator). Option B describes multiplication (that's * operator). Option D is false - MOD is a valid SQL function.