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.

Submitted By:-Vikas            Email-ID: - vikas123.singh@yahoo.com

Q: - What is LOB ?

Large object (LOB) data types are used to store large amounts of unstructured data. Large object data types include the following:

Binary large object: The binary large object data type is used to store binary data values (such as documents, graphic images, pictures, audio, and video) that are up to 2 gigabytes in size. The keywords BINARY LARGE OBJECT and BLOB are used to denote the binary large object data type. The amount of storage space set aside to store a binary large object value is determined by the length specification provided when a binary large object data type is defined. For example, 800 bytes of storage space would be set aside for a BLOB(800) definition.

Character large object: The character large object data type is used to store SBCS (single-byte character set) or MBCS (multibyte character set)character string values that are between 32,700 and 2,147,483,647 characters in length. The keywords CHARACTER LARGE OBJECT, CHAR LARGE OBJECT, and CLOB are used to denote the character large object data type. The amount of storage space set aside to store a character large object value is determined by the length specification provided when a character large object data type is defined. For example, 800 bytes of storage space would be set aside for a CLOB(800) definition.

Double-byte character large object: The double-byte character large object data type is used to store DBCS (double-byte character set) character string values that are between 16,350 and 1,073,741,823 characters in length. The keyword DBCLOB is used to denote the double-byte character large object data type. The amount of storage space set aside to store a double-byte character large object value is determined by the length specification provided when a double-byte character large object data type is defined. For example, 800 bytes of storage space would be set aside for a DBCLOB(400) definition.

Submitted By:-Vikas             Email-ID: -vikas123.singh@yahoo.com