Max number of columns in a db2 table ?
224
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Given an N x M two dimensional array of integers where all rows and columns are sorted in ascending order, write a function that can determine if a certain value exists in the array. 10.11.08
A: The obvious brute force solution would involve checking each item in the array to see if matches the desired value. This does not take advantage of the fact...What is Extension table? 26.09.08
My understand is "base table has default colums. But Extension table is the table in which we can add additional columns other than its base tables columns I...After a table is defined, can columns be removed ? 25.07.08
The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...After a table is defined, can columns be removed ? 14.07.08
The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...How many number of columns a record group can have? 21.05.08
A record group can have an ultimate number of columns of type CHAR,LONG,NUMBER, and DATE provided that the total number of columns does not exceed 64k....What are record groups? 15.05.08
A record group is an internal Oracle Forms data structure that has a column/row framework similar to a database table. However, unlike database tables, record...What is a composite index and how does it differ from a multiple index ? 01.04.08
A multiple index is not one index but two indexes for two different columns of a table. A composite index is one index made up of combined values from two col...What are some characteristics of columns that benefit from indexes ? 01.04.08
Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence...can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table? 21.03.08
yes possible. until the updation or selection is committed db2 table will not be restructured. new column definition will be there but it will not be included u...List some optimization techniques in EIM. 06.12.06
1) Limit base tables and columns to be processed by using : only base Tables,ignore base Tables,only base Columns,ignore base Columns. 2) Always delete batches...