Java and SQL Programming Basics

Views CAN be created as joins across multiple tables - this is a common use case for simplifying complex queries. Views can also include ORDER BY in some databases (with limitations), and GROUP BY is standard. Option A is correct. Option B directly contradicts A. Options C and D are false - views can include ORDER BY (with TOP/LIMIT in some DBs) and definitely support GROUP BY.

When a base table is dropped, any dependent view becomes invalid because its underlying schema no longer exists. The view object isn't automatically dropped (it remains in metadata with an INVALID status). Attempts to query the invalid view will fail. The view must be recreated or the table restored to make it functional again.

The UPDATE statement is used to modify existing records in a table, making it the correct command to update a married employee's last name. In contrast, ALTER modifies the table's structure (schema), INSERT adds new records, and CREATE is used to instantiate new database objects like tables.

Java does NOT support multiple inheritance of classes to avoid the 'diamond problem' and complexity. A class can only extend one parent class, though it can implement multiple interfaces - which is different from multiple inheritance.

MVC 2 pattern separates business logic independently from presentation. In MVC 1 (Model 1), the view and controller are combined, making business logic tightly coupled with presentation. MVC 2 (Model 2) introduced a separate controller layer, enabling independent business logic implementation. MVC 3 is not a standard MVC pattern variant.

Strings in Java are immutable - once created, their values cannot change. Methods like concat(), substring(), or toUpperCase() return new String objects rather than modifying the original. This design enables string interning and thread safety.

String's length is a method that must be called with parentheses: length(). The code attempts to access length as a field without parentheses, which fails at compile time. This is a common syntax error when confusing methods with fields.

In Java, dividing two integers yields an integer (int). Assigning it to a byte without casting causes a compile-time error. Additionally, using & as a unary address operator is invalid syntax in Java and fails compilation.