Oracle Database Fundamentals

When WORKAREA_SIZE_POLICY is set to AUTO, Oracle automatically allocates memory to work areas to optimize both throughput and response time, while ensuring total PGA memory stays within the PGA_AGGREGATE_TARGET limit.

In Oracle, setting WORKAREA_SIZE_POLICY to AUTO requires that PGA_AGGREGATE_TARGET is set to a non-zero value first, enabling automatic management of SQL work areas.

All options are valid implicit data type conversions in many database systems: Char can implicitly convert to number (when numeric string), Char to date (when in date format), Number to varchar2, and Date to varchar2. These conversions happen automatically without explicit CAST or CONVERT functions.

ADD_MONTHS, NEXT_DAY, and LAST_DAY are all standard SQL date functions. NEXT_MONTHS does not exist in standard SQL date function sets. The function to add months is ADD_MONTHS, not NEXT_MONTHS. NEXT_MONTHS is the invalid/non-standard option.

TCL (Transaction Control Language) includes COMMIT, ROLLBACK, and SAVEPOINT - all used to manage transactions. GRANT is a DCL (Data Control Language) statement used for permissions, not transaction control. Therefore GRANT is NOT a TCL statement, making it the correct answer to 'which is NOT TCL'.

All listed options are single-row functions in SQL: CONCAT (string concatenation), MOD (modulo operation), ROUND (numeric rounding), and conversion functions (TO_CHAR, TO_DATE, etc.) all operate on individual row values rather than aggregating across multiple rows like aggregate functions.

1NF (First Normal Form) is considered the automatic or default normal form because it requires only basic atomicity and no repeating groups. Higher normal forms (2NF, 3NF, 4NF) require additional constraints about functional dependencies and multivalued dependencies that must be explicitly designed.

The EXISTS operator is specifically designed to test for the existence of rows returned by a subquery and cannot function without one. IN, BETWEEN, and LIKE can operate on literal values or lists.

Regular tables are the default and most widely used table type in databases. They're simple, well-understood, and suitable for most use cases. Clustered tables (physically ordered by index) and index-organized tables are specialized for specific performance scenarios. Partitioned tables are used for very large datasets.

A Table is a database object containing columns and rows that requires physical storage segments in a tablespace to hold its data. Views, Synonyms, and Sequences are metadata definitions stored only in the data dictionary.