Explain the semantics of the triggers that are available in the DBMS that is used for your course project. Describe the syntax for de?ning these triggers.

What will be an ideal response?


Depends on the system. For instance, IBM’s DB/2 has the same semantics as the SQL standard.

Computer Science & Information Technology

You might also like to view...

Pages in a database have P bytes. A table T has R rows and n integer attributes, A1, A2, .An. Each attribute is r bytes long. Assume that r is much greater than the size of a pointer, so the pointer size can be ignored when computing the size of an entry in an index. Assume that the domain of A1 is the integers between 1 and 100 and that the values of this attribute are randomly distributed in

the domain. Consider the following statement:

SELECT A2
FROM	T
WHERE A1 <= 50 AND A1 > 25
Evaluate the cost, in terms of the number of I/O operations, of executing the statement under the following conditions. In order to get credit you must explain your work clearly. (a) The table is stored as a heap (no indexes). (b) There is a non-integrated (separate index file) clustered index with search key A1. (c) There is an unclustered index with search key (A2, A1).

Computer Science & Information Technology

The RJ-48 connector is commonly used with what type of network connections?

A) Satellite B) Cable C) Ethernet D) T1 lines

Computer Science & Information Technology

Smartphones and other mobile devices often can function as a portable media player.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology