Which of the following is considered as an administrative function of the database management system (DBMS)?

Question

BlackTom AI · Accepted Answer

Let’s unpack the question by restating what is being asked and listing the options clearly.
Question: Which of the following is considered as an administrative function of the database management system (DBMS)?
Answer options:
- Inserting or modifying data.
- Providing database security.
- Creating tables and their relationships in databases.
- Using international standard languages for processing database applications.

Now, evaluate each option in turn:
Option 1: Inserting or modifying data.
This activity is primarily about data manipulation or data control within the database, often categorized as a user or application function that changes the stored data. It aligns with data manipulation language (DML) tasks rather than administrative tasks, so it does not typically constitute an administrative function of the DBMS.

Option 2: Providing database security.
Security management—such as authentication, authorization, access control, auditing, and encryption—is a core administrative responsibility of the DBMS. It involves overarching control of how the database is accessed and protected, which is fundamentally about administration rather than day-to-day data operations.

Option 3: Creating tables and their relationships in databases.
Defining schemas, creating tables, and establishing relationships are schema design and data definition tasks. These are structural and design-oriented activities, generally considered part of database design or programming rather than administration, though they may be supported by administrative tools; the primary admin duties usually revolve around governance, security, backup, and performance oversight.

Option 4: Using international standard languages for processing database applications.
Using standard query languages (like SQL) is a tool or technique for interacting with the data. While essential for database work, it describes a language usage capability rather than an administrative function itself. Administration is more about controlling how those tools are used and who is allowed to use them, rather than the act of using the language per se.

Summary of the contrasts: Options 1 and 3 are tied to direct data operations or design work, not administrative control. Option 4 concerns tooling and language usage. Option 2 uniquely targets governance, security, and control—hallmarks of administrative duties within a DBMS.

Therefore, evaluating the nature of each option leads to the conclusion that the statement related to administration is the one about security management, which is distinct from the other operational or design-oriented tasks tested here.

BUS-308-03 Practice Final Exam

Which of the following is considered as an administrative function of the database management system (DBMS)?

View Explanation

Log in for full answers

Similar Questions

Which one of the following is NOT a principle of database processing.

In a consumer society, many adults channel creativity into buying things

Economic stress and unpredictable times have resulted in a booming industry for self-help products

People born without creativity never can develop it

A product has a selling price of $20, a contribution margin ratio of 40% and fixed cost of $120,000. To make a profit of $30,000. The number of units that must be sold is: Type the number without $ and a comma. Eg: 20000

Which of the following statement regarding cost is correct:

Under the assumptions used in cost-volume-profit analysis, as the activity increases:

The CVP and break-even analysis are supported by a range of important assumptions. Which of the following is not an assumption of the CVP:

More Practical Tools for Students Powered by AI Study Helper

Homework AI Solver

Stylized AI Paper Writer

Plagiarism Checker Assistant

Citation AI Academic Writing Tool

In-Class Translation Assistant

AI Note Generator

AI Quiz Answers

Past Exam Questions from University Test Bank

Smart Practice Assistant

Adaptive Practice

Making Your Study Simpler