What is the database descriptor?
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 |
Where could you look if you had a question about whether a column has been defined as an index?
What is a Cartesian product?
What is collection in db2 bind?
What is the role of data manager in the db2 database?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is check constraint in db2?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the difference between spufi and qmf?
What is buffer pool and list some of them?
What is load replace in db2?
What do you mean by NOT NULL? When will you use it?