Related InterviewSolutions

• How many clustering index we can have for a single table?
• Suppose a table A has an Alias named AL1. Which of the query is correct to drop the AL1 alias?
• Which index must be present for partitioned table space?
• In which format index in stored?
• What does SPUFI stands for?
• What is the maximum size of a VARCHAR data type in DB2?
• What is the maximum size of a CHAR data type in DB2?
• Write the query to delete all the rows from a table.
• Write a query to delete a table from database.
• How many primary keys can be declared on a table?