Hi...can anyone please help me with the following query?
Assuming that the create table statement is executed successfully,
CREATE TABLE T1 (COL1 INTEGER NOT NULL, PRIMARY KEY(COL1))
which 2 of the following system catalogs are updated?
a) SYSCAT.INDEXES
b) SYSCAT.PRIMARY KEYS
c) SYSCAT.TABLES
d) SYSCAT.NOTNULLABLECOLS
e) SYSCAT.CONSTRAINTS
I feel the answer is 'a' and 'c'...but i am not sure if there is any SYSCAT.CONSTAINTS...
Please let me know the correct answers.