A. Routine
B. Function
C. Procedure
D. Trigger
The correct answer is D. Routines are a type of database object that you can use to encapsulate logic that can be invoked like a programming sub-routine. There are many different types of routines available; routines can be grouped in different ways, but are primarily grouped by their system or user definitions, by their functionality, and by their implementation.
Q: – What is minimum privilege required for one to create a tablespace?
CREATETS privileges
Q: – What is a foreign key?
A foreign key is the key defined in one table to reference the primary key of a reference table. This foreign key must have the same structure as the reference table’s primary key.
Q: – What is DB2's directory files ?
To keep track of this information, DB2 uses a special set of files known as directory files (or directories). Four types of directories exist:
System database directory
Local database directory
Node directory
Database Connection Services (DCS) directory
Q: – What is minimum privilege required for one to create a tablespace?
CREATETS privileges
Q: – What is a foreign key?
A foreign key is the key defined in one table to reference the primary key of a reference table. This foreign key must have the same structure as the reference table’s primary key.
Q: – What is the basic difference between a join and a union?
A join selects columns from 2 or more tables. A union selects rows.
Submitted By:-Vikas Email-ID: – vikas123.singh@yahoo.com
