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.

The table used to store premium details of the policy is TPOL_PREM. This follows standard insurance database naming conventions where TPOL prefix indicates policy-related tables. The naming pattern truncates 'premium' to 'PREM' for brevity, similar to how TPOLICY stores general policy information. Other options like TPOL_PREMIUM or TPREMIUM are not the correct table names.

In SAP systems, PLAF (Planned Order) table stores all details related to planned orders including the creation date. The other tables listed serve different purposes: PLMZ for planned order milestones, PLPO for planned order operations, and PLKO for planned order headers. PLAF is the primary table for planned order master data.

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.

After Test Cases are inserted into the database, ETP values can be modified either manually (one row at a time) OR through the Test Case Bulk Update Tab. Option B (Bulk Upload) is typically for initial uploads, not updates. Option D is incomplete, and options A, B, C alone are each insufficient.

The 'Actual ETP' column in Test Case Bulk Upload/Update can contain blank values (for unknown/unestimated cases) OR zero values (for cases with no ETP allocation). Options A and B are incorrect because both blank AND zero are permitted. Option D is incorrect because it suggests both are forbidden, when both are actually allowed.

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.