Database and SQL

The French verb 'effacer' means 'to delete' or 'to erase' in English. This is a fundamental computing action for removing files or text. Control, alter, and insert are different computer operations, not the meaning of effacer.

In Design View, you can modify object properties (like field settings, control properties) and change appearance (fonts, colors, layout). Creating new records happens in Datasheet View, and viewing query records is done in Query View results.

Datasheet View in MS Access allows you to create a table by simply typing data into a spreadsheet-like grid. Access automatically creates the table structure and assigns data types based on what you enter. Table Wizard guides you through table creation but requires more steps. Design View is for manually defining fields and properties before data entry.

A major problem with SQL is that the same query can be written in multiple syntactically correct ways, each producing vastly different execution plans and performance characteristics. This makes optimization challenging and query performance unpredictable. SQL does support some object-oriented features, the syntax is designed for professionals, and locking behavior is configurable.

ROWNUM is a pseudocolumn in Oracle that assigns a sequential number to each row retrieved, but it's not an analytical function. ROW_NUMBER, RANK, and FIRST_VALUE are all window/analytical functions that operate over sets of rows in a specific order.

Table access by ROWID is the fastest method for Oracle to retrieve a single row because ROWID is the physical address of the row in the database. Accessing directly by physical address avoids the overhead of index traversal or scanning multiple rows. Full table scan is the slowest, while primary key and unique index access are faster than full scans but still require index lookup overhead.

In the given SQL query, multiple columns are concatenated using the string concatenation operator (||) and separated by commas, but the entire resulting expression is given a single column alias "Adress". Therefore, the query returns only 1 column in its result set.

PostgreSQL was originally named Postgres as a successor to the Ingres database at UC Berkeley. The name literally means 'after Ingres' (post = after, Ingres = the earlier database). Later SQL capabilities were added, leading to PostgreSQL.

MySQL supports unsigned integer datatypes like INT UNSIGNED, BIGINT UNSIGNED which allow only non-negative values and effectively double the positive range. PostgreSQL does not have native unsigned integer types - it uses signed integers with CHECK constraints for similar functionality.

MySQL is not 100% ACID compliant because ACID properties depend on the storage engine being used. Only InnoDB provides full ACID compliance with transactions, foreign keys, and crash recovery. Engines like MyISAM lack transaction support entirely.

DELETE FROM is the correct SQL command to remove rows. The syntax requires specifying the table and optionally a WHERE clause. DROP removes entire tables, UPDATE modifies data, and REMOVE is not a valid SQL command.

For DATE columns in Oracle, only COUNT, MIN, and MAX are valid aggregate functions because they work with ordered data and counting. SUM and AVG require numeric values to calculate totals and averages, which cannot be performed on dates. MAXIMUM (option F) is incorrect Oracle syntax - it must be MAX.

TO_CHAR is used to format dates into strings. 'FMDay' ensures the day is capitalized and removes extra padding, while 'DD Month, YYYY' provides the day number, full month name, and year. TO_DATE is incorrect because it converts a string to a date, not a date to a formatted string.

Oracle constraint types are PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, and NOT NULL. Options B, D, E, and F are all valid constraint types that enforce data integrity rules. CASCADE is a referential action, not a constraint type itself. NONUNIQUE is not a standard Oracle constraint.