programming languages Online Quiz - 318

SQL provides built-in functions across multiple categories: character functions (SUBSTR, CONCAT, etc.), numeric functions (ABS, ROUND, etc.), date functions (SYSDATE, ADD_MONTHS, etc.), and conversion functions (TO_CHAR, TO_DATE, CAST, etc.). Option B correctly identifies character and numeric functions. Option E correctly identifies date and conversion functions. Option A is partially correct but incomplete. Options C, D, and F contain incorrect or non-standard category names.

The UNIQUE constraint allows null values (unless combined with NOT NULL). A UNIQUE index is automatically created for columns defined with PRIMARY KEY and UNIQUE constraints, making that statement correct, while NOT NULL ensures no nulls are allowed.

Subqueries can return zero, one, or multiple rows depending on context and operators used (B is true, disproving A). They can be nested beyond two levels in most databases (C is false). Subqueries can appear in various SQL statement types including DML and DDL, not just queries (D is false). They work with group functions (E is false). When using inequality operators with subqueries, single-row subqueries must be ensured or the ANY/ALL modifiers must be used (F is true, describing the inequality constraint requirement).

USER_CONS_COLUMNS displays the columns that participate in constraints defined on tables owned by the current user. USER_CONSTRAINTS shows constraint definitions but not column details. USER_OBJECTS lists all objects owned by the user. ALL_CONSTRAINTS includes constraints on accessible objects owned by others. USER_COLUMNS shows all table columns, not specifically constraint-related ones.

To grant all users query privileges, use GRANT select ON dept TO PUBLIC. PUBLIC is a reserved word that represents all database users. Option A incorrectly uses ALL_USERS which is not a valid grantee. Option B incorrectly uses ALL without PUBLIC. Option C incorrectly uses QUERY instead of SELECT and ALL_USERS. Option E incorrectly uses QUERY and incorrectly capitalizes PUBLIC.

The NOT NULL constraint can only be defined at the column level because it applies to a single column's values. Constraints like UNIQUE, CHECK, PRIMARY KEY, and FOREIGN KEY can be defined at either the column level or table level. Table-level constraints allow specification across multiple columns, which is essential for composite keys and multi-column conditions.

Outer joins preserve all rows from one or both tables, filling in NULLs where there are no matches. Use them when you need to keep unmatched rows (like finding customers with no orders) or when NULL values in join columns indicate non-matches rather than missing data. Inner joins only return matched rows, so outer joins are essential when unmatched data matters.

Line 13 attempts to assign an integer (str.length() returns int) to a boolean variable (check is int, but if condition requires boolean). In Java, check = str.length() is an assignment, not a comparison, and the types are incompatible for the if condition.

Line 13 attempts to assign an integer (str.length() returns int) to a boolean variable (check is int, but if condition requires boolean). In Java, check = str.length() is an assignment, not a comparison, and the types are incompatible for the if condition.

To execute a class from a JAR file, the JAR must be in the CLASSPATH with its full path. Option C correctly places Poker.jar in /stuff/java and includes the full JAR path /stuff/java/Poker.jar in CLASSPATH. Wildcards like *.jar don't work in CLASSPATH.

The variable c is declared as type Mint. The method c.quality(h) calls quality() on a Mint reference. The argument h is declared as Clove, so the method signature quality(Mint c) in class Mint doesn't match. JVM looks for quality(Clove) in Mint's hierarchy, finds it in Clove class (parent), and executes that due to method resolution rules.

During instantiation of Derived, the Base constructor is called first, which invokes addValue(). Because of dynamic binding, the overridden addValue() in Derived runs, adding 20 to value. Then, the Derived constructor runs and calls addValue() again, adding another 20, resulting in 40.

The process() method in BitUtils is declared as private static. Private methods are not accessible outside their own class, even with fully qualified names or imports. SomeApp cannot access this method regardless of how it's called.

Line int i=initialize(369) tries to call initialize(int) which has void return type, but int i expects an int value. This is a type mismatch - void methods cannot return values to initialize variables.

Calling start() twice on the same Thread object throws IllegalThreadStateException at runtime. Once a thread has been started, subsequent calls to start() cause an exception - you cannot restart a thread.

Since SomeApp does not import the util package or the BitUtils class, it must use the fully qualified class name util.BitUtils.process(bytes); to call the static method.

The type parameter N must extend Number to have the doubleValue() method. Option D (N extends Number) is correct. Option F (N extends Integer) also works since Integer extends Number and has doubleValue(). Options with ? are invalid because ? is a wildcard, not a type parameter name.

Static blocks execute when the class is loaded, before any object is created. Inside the static block, the code attempts to call the non-static method display(), which results in a compilation error because non-static methods cannot be referenced from a static context. Therefore, option C correctly identifies this compilation failure.