Tag: technology

An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

An application running on a remote client needs to track every modification made to a table that contains sensitive data

An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

Sequence

Table Function

Identity Column

INSTEAD OF Trigger

CREATE UNIQUE INDEX idx_partno ON parts(part_no)

CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)

CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)

CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

Check

Range

Referential

Informational

DELETE * FROM TABLE T03

DELETE ALL FROM T03

DELETE * FROM T03

DELETE FROM T03

Add a new column

Drop a check constraint

Change a column's name

Change the length of a VARCHAR column

DB2 will no longer allow updating the value of IDCOL1 in TABLE1.

When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.

When inserting a row in TABLE2, DB2 will only allow foreign values for IDCOL2, that is values which do not exist in IDCOL1.

When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement

INTEGER

REAL

NUMERIC(7, 3)

DECIMAL(10, 3)

View

Alias

Table

Package

2

3

11

30