Interested to Buy Any Domain ? << Click Here >> for more details...
What is the database descriptor?
- 2 Answers
- 14794 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhisek
Database Descriptor is a DB2 component that limits access
to the database whenever objects are created,altered or
dropped.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / deepika
A DBD also contains other information about accessing tables in the database. DB2 creates and updates DBDs whenever their corresponding databases are created or updated.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to design maps
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
Explain about cursor stability?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Can we delete records from view?
Is the primary key a clustered index?
What is db2 bind?
What is the role of data manager in the db2 database?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
what is a corelated subquerry?
COBOL 
