What is a Resource Control Table(RCT)? Describe its characteristics.3 10614
How is the SUBSTR keyword used in sql?1 7780
Where is the access path logic created by the DB2 Optimizer stored?1 6726
What is a root page?1 3013
What happens to the PLAN if index used by it is dropped?1 4177
What keyword does an SQL SELECT statement use for a string search?2 6270
Which catalog table stores referential constraints?1 4211
Give the COBOL definition of a VARCHAR field.2 14749
EXPLAIN has output with MATCHCOLS = 0. What does it mean?2 8515
What is normalization and what are the five normal forms?1 3517
What is a db2 tablespace?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is a db2 collection?
How is the value function used?
What is host variable?
Comment whether the cursor is closed during commit or not.
How to find the number of rows in a db2 table?
What is a system catalog table in db2?
What is sqlca?
What is runstats utility in db2?
What is the role of union all and union
What is the result of open cursor statement?
What is the function of logging in the db2 database?
How would the varchar column remarks defined?
B37 abend during spufi?