DB2 Interview Questions and Answers For Freshers Part-5
42.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.
43.What is the maximum size of a CHAR data type in DB2?
Char data type maximum size is of 254 bytes.
44.What is the maximum size of a VARCHAR data type in DB2?
Varchar data type maximum size is of 4046 bytes.
45.What does SPUFI stands for?
SPUFI stands for SQL Processor Using File Input.
46.In which format index in stored?
An indexed is stored in B-tree format.
47.Which index must be present for partitioned table space?
A partitioned table space must have a clustered index.
48.Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?
DROP ALIAS AL1 is the query to drop a alias.
49.How many clustering index we can have for a single table?
We can have only one clustering index for a table.
50.What action DB2 takes when a program abends?
When a program abends in middle of some transaction then DB2 performs a auto rollback.