What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
Enlist the various transaction phases.
What is Data Redundancy and Consistency ?
Define checkpoint.
What is index hunting?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What do you understand by ‘atomicity’ and ‘aggregation’?
If I use netlib, will I find many other users to network with?
Discuss transparent DBMS?
What is data in dbms?
Mention the differences between union and union all
Explain the architecture of reporting services?
Differentiate between nested loop, hash loop and merge join.
What is the use of database management system?
What is a hierarchical database?