PyQdeck LogoPyQdeckSubjectsSyllabusBlog
Back to the 2021 paper

Unit 1: Database System Architecture

20217m

List five responsibilities of the database manager. For each responsibility, explain the problem that would arise if the responsibility were not discharged.

Search GoogleAsk AI
Worked SolutionAI Assisted

Five Responsibilities of Database Manager (DBMS / DBA responsibilities):

  1. Schema Definition: Define logical/physical schema, storage structure, access method via DDL. If not done: no consistent structure, data inconsistency, no integrity.

  2. Storage Structure & Access Method Definition: Choose indexing, hashing, partitioning. Failure: poor performance, high I/O, slow queries.

  3. Granting Authorization: Provide privilege controls (GRANT/REVOKE) for data access. Failure: security breach, unauthorized access/modification.

  4. Routine Maintenance: Backup, recovery, monitoring, tuning, reorganization. Failure: data loss on failure, degraded performance, no recovery.

  5. Integrity Constraint Specification: Define constraints (primary key, foreign key, check). Failure: invalid data, inconsistency, referential violations.

Additional: Transaction management, concurrency control, defining security. Each missing responsibility leads to data anarchy, redundancy, inconsistency, security compromise, and failure recovery inability.

Similar questions

Database Management SystemWhat are the five main functions of a database administrator?20207mDatabase Management System____ play an important role in defining and maintaining a database for an organization. *(Fill in the blank)*20192mDATABASE MANAGEMENT SYSTEMWrite a short note on any one of the foflowing: - (b) Database recovery20217mSoftware EngineeringExplain the roles and responsibilities of the following personnels in the s/w development process: (i) Project Manager (ii) Project Leader (iii) System Analyst (iv) Developer20207m
PreviousWhich join refers to join records from the right table that have no matching key in the left table and are included in the result set? - (i) Left outer join (i) Right outer join (iii) Full outer join (iv) Half outer joinNextConsider a two-dimensional integer array of size name that is to be used in your favourite programming language. Using the array as an example, illustrate the difference (i) between the three levels of data abstraction and (ii) between a schema and instances.
Student FinanceWeb Platform

Pocketly — Personal Finance for Students

Keep your hostel and college expenses under control. Track accounts, log spending in seconds, and stay within your monthly budget.

Open Pocketly