Database and SQL

Oracle supports two valid syntaxes for renaming tables: (1) RENAME old_name TO new_name, and (2) ALTER TABLE old_name RENAME TO new_name. The 'AS' keyword is invalid in both syntaxes. ALTER without TABLE is also invalid.

When you create a Primary Key constraint, the database automatically creates a unique index to enforce the uniqueness requirement. Similarly, a Unique constraint also creates a unique index to ensure no duplicate values. Check constraints only validate data integrity rules, Not Null enforces presence of values, and Foreign Key creates relationships but not unique indexes.

Oracle LONG columns are used to store variable-length character strings containing up to 2 gigabytes of text. They share many characteristics with VARCHAR2 columns, although they have many more restrictions on usage.

Oracle supports several datetime datatypes, including DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and TIMESTAMP WITH LOCAL TIME ZONE. All four options represent valid built-in datetime types in Oracle SQL.

Database sequences generate unique numeric values often used for primary keys and unique keys to provide automatically incrementing identifiers. Sequences are not typically used for sales figures (which are data values, not identifiers) or foreign keys (which reference existing primary keys). The generated values ensure uniqueness across rows.

Oracle comparison operators return three possible values: TRUE, FALSE, or UNKNOWN. UNKNOWN is returned when any operand in the comparison is NULL (not the same as NULL itself). ERROR is not a valid result for comparison conditions - errors occur from invalid operations, not comparisons. NULL is a value, not a comparison result.

Single-row functions can be used in almost any clause of a SQL query. This includes the SELECT list, the WHERE clause, the START WITH and CONNECT BY hierarchical clauses, and the HAVING clause, as they operate on individual rows.

DBMS_STATS.UNLOCK_TABLE_STATS takes two parameters: schema name first, then table name. Options A and B incorrectly use UNLOCK_SCHEMA_STATS which locks/unlocks all tables in a schema. Option C uses UNLOCK_DB_STATS which doesn't exist. Option D has the parameter order reversed.

A tablespace is a logical storage container that can hold database objects (tables, indexes) from multiple schemas. Schemas are logical namespaces for users, while tablespaces are physical storage structures - they're independent concepts. This is a fundamental Oracle architecture feature allowing flexible storage management.

Parentheses override the default operator precedence in SQL expressions, just like in standard mathematics. Without parentheses, SQL evaluates operators according to precedence rules (NOT before AND before OR). Colons, commas, and semicolons are statement separators or terminators, not grouping operators.

In Lotus Notes, the Managers field contains user names who have full access including ACL management. Authors can create but not delete documents, Readers can only read, and Editors can modify documents but not manage access at the field level. The Managers field is specifically for access control.

An outer join (C) extends a simple join by including non-matching rows from one or both tables. A simple join is typically an inner join that only returns matching rows. Left joins (A) and right joins (B) are specific types of outer joins, making 'outer join' the broader, more general answer. An equijoin (D) is a basic inner join based on equality, not an extension.

A RIGHT OUTER JOIN returns all rows from the right table (B), plus matched rows from table A. Unmatched rows from A show NULL. LEFT OUTER JOIN would return all rows from A instead.

CREATE INDEX in Oracle works on table columns, cluster object attributes, and nested table storage tables. Indexes organize data for faster lookups on these structures.

An inner join is called a "simple join" in Oracle SQL because it returns only rows where the join condition matches in both tables. It's not an outer join (which includes non-matching rows).