What information is used as input to the bind process?2 4997
Can I use LOCK TABLE on a view?1 5471
Are views updatable ?4 8515
Give some example of statistics collected during RUNSTATS?1 4502
What is referential integrity?5 16547
What is EXPLAIN?1 3973
What is a DB2 plan?8 40453
How to define the data items to receive the fetch items for the SQL?2 3822
What is a page?2 3290
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is a collection?3 4434
What does the CHECK Utility do ?1 4080
Where could you look if you had a question about whether a column has been defined as an index?2 4037
What are the various locking levels available?3 4370
If I have a view which is a join of two or more tables, can this view be updatable?3 4210
What is innodb buffer pool?
Define check constraint.
What is database alias db2?
What is db2 and what is the use of db2 optimizer?
Which components manage deadlocks in db2?
Describe major components of db2?
What is blu acceleration in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Are views updateable?
is it compulsory commitment control in journal?
How to access db2 tables in mainframe?
How do you stop a db2 database in linux?
What is multi row fetch in db2?
What are db2 tables?