1 Database Administration Fundamentals

Database Administration · Unit 1

Database Administration Fundamentals

Exam-focused notes for Database Administration Fundamentals (Database Administration, BIT352): what the TU syllabus asks and how it has actually been tested, with 3 solved past questions from this unit.

What this unit covers

  • Definition and scope of database management system
  • Roles and responsibilities of database administrator
  • DBA tasks and activities
  • Importance of database security and administration

Roles and responsibilities of database administrator

20815 marks

What are the roles and responsibilities of Database Administrator? [5]

A Database Administrator (DBA) is a person responsible for managing, maintaining, and securing the database system in an organization. The DBA acts as a central authority over the database environment. --- - The DBA is responsible for creating the original ...

Full solved answer →
20805 marks

Explain the term Database administrator (DBA) and describe the different roles of DBA. [5]

--- A Database Administrator (DBA) is a person (or a group of persons) who is responsible for the overall management, control, and maintenance of a database system. The DBA has central authority over the database and acts as an interface between the databas...

Full solved answer →

DBA tasks and activities

2081.110 marks

What are different database administration tasks? Explain Oracle Data Guard in brief.[10]

--- A Database Administrator (DBA) is responsible for the installation, configuration, maintenance, security, and performance of a database system. The major DBA tasks are: - Installing the DBMS software on the server. - Configuring database parameters, mem...

Full solved answer →