|
Question |
Rating |
View Answer |
|
how to add records to table through file-aid? |
|
View Answer |
|
What is auditing? |
|
View Answer |
|
How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL. |
|
View Answer |
|
What are the disadvantages of using VARCHAR? |
|
View Answer |
|
When would you prefer to use VARCHAR? |
|
View Answer |
|
What do you mean by NOT NULL? When will you use it? |
|
View Answer |
|
What do you mean by NOT NULL WITH DEFAULT? When will you use it? |
|
View Answer |
|
What is the difference between SYNONYM and ALIAS? |
|
View Answer |
|
What is a synonym ? |
|
View Answer |
|
What is index cardinality? |
|
View Answer |
|
What are simple, segmented and partitioned table spaces ? |
|
View Answer |
|
What is FREEPAGE and PCTFREE in TABLESPACE creation? |
|
View Answer |
|
What is an inner join, and an outer join ? |
|
View Answer |
|
What are the 4 environments which can access DB2 ? |
|
View Answer |
|
If I have a view which is a join of two or more tables, can this view be updateable? |
|
View Answer |
|
Are views updateable ? |
|
View Answer |
|
What does the sqlcode of -818 pertain to? |
|
View Answer |
|
What is sqlcode -811? |
|
View Answer |
|
What is sqlcode -922 ? |
|
View Answer |
|
What is the difference between primary key & unique index ? |
|
View Answer |