ibps-so 2016 · Question 23 of 394

When Chandrabhaga Urban Bank migrated its deposit system, the database administrator was asked to produce, before a single row was moved, a statement of every table in the old schema, every column of every table with its data type and width, every constraint and default declared upon those columns, every index and view built over them, and every user and role holding a privilege upon them. He replied that he need write nothing at all, because the database itself maintains this information as data about the data, keeps it in tables of its own that it updates whenever a de nition is altered, and permits it to be queried in the ordinary way. That repository, held and maintained by the database management system itself, is the:

1. ATransaction log, which holds an ordered record of every change made to the data so that recovery may be performed
2. BData mart, which holds a departmental subset of the data extracted for analysis
3. CBu er cache, which holds the most recently used data blocks in main memory to save physical reads
4. DData dictionary, also called the system catalogue, which holds the metadata — the de nitions of the schema objects, their constraints, their storage and their privilegesCorrect
5. EData warehouse, which holds the integrated and time-variant history of the enterprise for decision support