Java Programming and SQL Basics

Standard SQL does not allow group (aggregate) functions like SUM, AVG, or COUNT directly in the WHERE clause because the WHERE clause filters rows before grouping occurs. To filter groups based on aggregate results, the HAVING clause must be used instead, making the statement false.

A Cartesian product (cross join) occurs when every row from the first table is joined with every row from the second table, creating n × m rows. This happens when the join condition is either omitted entirely, invalid (references non-existent columns), or when no WHERE clause restricts the join.

It is not mandatory to specify the table name along with the column name in a join condition unless the column names are ambiguous (i.e., they exist in multiple tables). If the column names are unique across the joined tables, the database can resolve them without table prefixes, making the statement false.

An equi-join requires equality between columns with the same name from both tables. Option B shows Table1.column1 = Table2.column1, which matches identical column names. Options A and C join different columns (column1 to column2), which would be a non-equi-join unless explicitly aliased.

To join N tables together, the minimum number of join conditions required to avoid a Cartesian product is N - 1. For 10 tables, we need at least 9 join conditions. Specifying fewer will result in an incomplete join, while specifying more is not the minimum requirement.

A non equi-join is a join condition in SQL that matches rows based on an inequality condition, such as BETWEEN, <, >, <=, or >=, rather than an exact equality operator.

An outer join returns all records from one table and matching records from another, or all records from both tables. The key characteristic is that it includes records without direct matches (unlike inner joins). Option A best captures this essential behavior among the choices.

In Oracle SQL syntax, the outer join operator is (+), placed next to the column that may be null. This Oracle-specific notation indicates which side of the join allows null values for unmatched rows.

A self join is a regular join where a table is joined with itself, which is particularly useful for querying hierarchical or tree-structured data stored within a single table.

MIN and MAX aggregate functions can work with any data type that supports ordering - numeric, character, date, etc. They return the minimum or maximum value based on that type's sorting rules, not just numeric data.

The HAVING clause filters groups after aggregation, while WHERE filters individual rows before aggregation. HAVING is specifically designed to restrict which groups appear in the result set based on aggregate conditions.

Group functions (like SUM, AVG, COUNT) ignore null values by default. The NVL function converts null values to a specific default value (such as 0 or a placeholder) before the group function is applied, forcing group functions to include those records. Group By and Order By are syntax clauses, and 'Include NULL' is not a standard SQL function.

Inheritance is a fundamental OOP concept where a child class acquires properties and methods from its parent class. This promotes code reuse and establishes an 'is-a' relationship between classes. Encapsulation hides implementation details, while polymorphism allows objects to take multiple forms.

Java uses the dot (.) separator to distinguish between package names and subpackages (e.g., java.util.Vector). Commas are used for separating imports in import statements or declarations, not for package hierarchy. The standard notation is package.subpackage.ClassName.

The print() method writes text to the output stream without appending a newline, unlike println() which automatically appends a newline at the end of the printed content.

An Applet is a specialized Java program designed to run within web browsers, transmitted over the Internet and executed client-side. Unlike Servlets which run server-side, Applets provided early web interactivity before modern JavaScript frameworks emerged.

Java literals are source code representations of fixed values. For example, 100 is an integer literal, 3.14 is a floating-point literal, and 'x' is a char literal. These literal representations directly create constant values in the code without needing variables.

Java uses curly braces { } to group multiple statements into code blocks. This is essential for control structures like if, for, while, and for defining class and method bodies. Blocks create a new scope for local variables and are a fundamental part of Java syntax.

Polymorphism allows one interface to represent a general class of actions. Different objects can implement the same interface in their own way, enabling code to work with objects of various types through a common interface.