IBM DB2 Interview Questions & Answers part 1

0
323
Q: – Which of the following DB2 objects is NOT considered executable using SQL?

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

SHARE

LEAVE A REPLY