Top Cobol And DB2 Interview Questions Part – 2

Which Index Must Be Present For Partitioned Table Space?

A partitioned table space must have a clustered index.

In Which Format Index In Stored?

An indexed is stored in B-tree format.

What Does Spufi Stands For?

SPUFI stands for SQL Processor Using File Input

What Is The Maximum Size Of A Varchar Data Type In Db2?

Varchar data type maximum size is of 4046 bytes.

What Is The Maximum Size Of A Char Data Type In Db2?

Char data type maximum size is of 254 bytes.

Write The Query To Delete All The Rows From A Table.

DELETE * FROM table-name is the syntax to delete all the rows from a table.

Write A Query To Delete A Table From Database.

DROP TABLE table-name is the syntax to delete a table from database.

How Many Primary Keys Can Be Declared On A Table?

A table can have only one primary key.

In Which Statement You Can Define Primary Key?

Primary keys are optional and we can define them in CRETAE TABLE & ALTER TABLE statements.

Which Statement Is Used To Revoke The Access From A Database?

REVOKE statement is used to take away the permissions from a Database.

What Happens In Bind Step In A Db2 Program?

Bind step converts all the SQL statements into executable form in COBOL-DB2 program.

When You Will Face Sqlcode -803?

When you will try to insert or update a record with duplicate key then you will face SQLCODE = -803.