|
Related Questions |
View Answer |
|
What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made.
|
View Answer
|
|
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
|
View Answer
|
|
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
|
View Answer
|
|
What is a LIKE table and how is it created?
|
View Answer
|
|
When can an insert of a new primary key value threaten referential integrity?
|
View Answer
|
|
What are delete-connected tables?
|
View Answer
|
|
What is the self-referencing constraint?
|
View Answer
|
|
What is a clustered index?
|
View Answer
|
|
What is meant by index cardinality?
|
View Answer
|
|
What is a composite index and how does it differ from a multiple index?
|
View Answer
|
|
What are some characteristics of columns that benefit from indexes?
|
View Answer
|
|
How does Db2 use multiple table indexes?
|
View Answer
|
|
In terms of DB2 indexing, what is the root page?
|
View Answer
|
|
What are the three DB2 date and time data types and their associated functions?
|
View Answer
|
|
How is the SUBSTR keyword used in sql?
|
View Answer
|
|
What are some sql aggregates and other built-in functions?
|
View Answer
|
|
What is isolation level?
|
View Answer
|
|
What are the three lock types?
|
View Answer
|
|
What is deadlock?
|
View Answer
|
|
What is the SQL Communications Area and what are some of its key fields?
|
View Answer
|