Oracle Database Fundamentals

Both LAST_DAY (returns last day of month) and NEXT_DAY (returns next occurrence of specified day) are valid Oracle date functions. FIRST_DAY doesn't exist in Oracle. Option E ('1 & 2') correctly identifies that both A and B are valid functions.

CONVERT is a valid Oracle SQL function that converts character strings from one character set to another. The other options (divert, straight, revert) are not standard Oracle functions.

Oracle SQL includes TRANSLATE for character replacement, and COMPOSE/DECOMPOSE for Unicode handling. RETRANSLATE does not exist as a built-in Oracle function.

COALESCE is a standard SQL function (including Oracle) that returns the first non-null value from its argument list. The other spellings are invalid.

Oracle SQL provides the add_months(x, y) function to add a specified number of months to a date. The other options, multiply_months and devide_months, do not exist in Oracle SQL, while upper(x) is a character function used to convert text to uppercase.

iSQLPlus is a browser-based interface. Running it from a client PC requires an HTTP Server to serve the web pages and the iSQLPlus Server application tier to process the database interactions.

In SQL table naming conventions, the special characters allowed (depending on database) include @ and $ in many systems like SQL Server and MySQL. The ampersand (&) and hash (#) characters are typically not allowed or have special meanings (e.g., # for temporary tables in some databases). Specific rules vary by database system, but @ and $ are commonly permitted for naming purposes.

When comparing char columns, SQL uses lexicographic (string) comparison, not numeric. String comparison is character-by-character from left to right. '9' > '12' is True because '9' (ASCII 57) > '1' (ASCII 49). Only the first character matters: '9' > '1', so the entire comparison succeeds without looking at the '2'. This is why string columns should store numeric values as proper numeric types.

In various programming and database languages (such as SQL and PL/SQL), the operators <>, !=, and ^= are all valid representations of the 'not equal to' comparison operator.

TRIM with a specific character removes all leading AND trailing occurrences of that character. TRIM('0' FROM '000435600') strips zeros from both ends: the three leading zeros and the two trailing zeros all get removed, leaving '4356'. Option A only stripped leading zeros; options B and C left trailing zeros; only option D shows correct removal from both ends.

In Oracle Forms, the system variable or initialization parameter COMPATIBILITY is used to specify or check the database version compatibility to which the application is connected.

Statement III is correct because DCL includes GRANT and REVOKE. Statement IV is correct because DDL includes CREATE, DROP, and ALTER. Statements I and II are incorrect because they mix up DDL and DML commands.

SQL Server tables support up to 1024 columns, making 1000 the closest correct answer among the options provided.

SQL allows column aliases defined in the SELECT clause to be referenced in the ORDER BY clause, making queries more readable and maintainable.

DROP is the correct command to completely remove a table with all its constraints; TRUNCATE fails with foreign key constraints, DELETE only removes rows, and REMOVE is not a valid SQL command.

B-tree indexes are ideal for unique columns, reverse key indexes are designed to avoid contention in Oracle Parallel Server (RAC) environments, and bitmap indexes are highly efficient for columns with low cardinality.

Database procedures (like PL/SQL in Oracle) are stored in compiled form for performance, but the source code is also retained for debugging and modification purposes. Most database systems store both representations.