|
Question |
Rating |
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 |
|
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
|
|
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 |
|
What is a NULL value? What are the pros and cons of using NULLS?
|
|
View Answer |
|
What is a synonym? How is it used?
|
|
View Answer |
|
What is an alias and how does it differ from a synonym?
|
|
View Answer |
|
What is a DB2 bind?
|
|
View Answer |
|
What is a DB2 access path?
|
|
View Answer |
|
What is a DB2 plan?
|
|
View Answer |
|
What is normalization and what are the five normal forms?
|
|
View Answer |
|
What are foreign keys?
|
|
View Answer |
|
Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
|
|
View Answer |
|
What do the initials DDL and DML stand for and what is their meaning?
|
|
View Answer |
|
why we use db2 with cobol why we cant use any other languages? what the main reason?
what is disaster recovery? |
|
View Answer |
|
What are difference between version control and debugging tools? |
|
View Answer |
|
1) How would you find out the total number of rows in a DB2 table? |
|
View Answer |
|
2) How do you eliminate duplicate values in DB2 SELECT ? |
|
View Answer |
|
3) How do you select a row using indexes in DB2? |
|
View Answer |
|
4) How do you find the maximum value in a column in db2? |
|
View Answer |
|
5) How do you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP ? |
|
View Answer |