Question 1

Data administration is not concerned with performance monitoring because that is the responsibility of the company's systems programmers.

Accepted Answer

Data administration is concerned with monitoring the performance of the company's databases and ensuring that they are running efficiently. System programmers may be responsible for the technical aspects of performance tuning, but it is still important for data administrators to monitor and oversee the overall performance of the company's data.

Question 2

One of the advantages of data and database administration is having dedicated personnel to manage externally acquired databases.

Accepted Answer

Data and database administration involves having personnel dedicated to acquiring, organizing, and managing databases. This includes externally acquired databases, which require careful oversight to ensure they are integrated properly with existing systems and meet organizational needs. Therefore, having dedicated personnel in this role can provide a significant advantage.

Question 3

The term metadata means data about data.

Accepted Answer

Metadata is information that describes a particular set of data. Examples of metadata include file size, file type, creation date, and author name.

Question 4

A passive data dictionary is one that interacts with the IS environment on a real-time basis.

Accepted Answer

A passive data dictionary is one that is only updated manually rather than interacting with the IS environment in real-time.

Question 5

Among the responsibilities of data administration are arbitration of disputes and usage authorization.

Accepted Answer

Data administration is responsible for many tasks including settling disputes related to data, and controlling usage authorization.

Question 6

Among the responsibilities of data administration are data coordination and data planning.

Accepted Answer

Data coordination and data planning are indeed responsibilities of data administration.

Question 7

Due to the nature of data, it is not considered to be a "scarce" resource as other corporate resources are.

Accepted Answer

Data is often considered a scarce resource because, like other resources, it requires investment to collect, process, and analyze, and not all organizations have equal access to high-quality data.

Question 8

The data administration group is responsible for the operational aspects of the data dictionary, as opposed to the planning aspects, which are the responsibility of database administration.

Accepted Answer

The data administration group is typically responsible for the planning, policy, and standards aspects of data management, including the data dictionary, while the database administration group handles the operational and technical aspects, such as implementing and maintaining the database systems.

Question 9

A tables table is part of a data dictionary in a relational database environment.

Accepted Answer

A tables table typically contains information about all the tables in the database, such as their names, columns, data types, and constraints. It is commonly used by database administrators and developers for database management and application development purposes.

Question 10

Among the responsibilities of data administration are DBMS performance monitoring and DBMS troubleshooting.

Accepted Answer

The answer of Among the responsibilities of data administration are...

Question 11

Having data administration enforce data standards is helpful in establishing supply chains with other companies.

Accepted Answer

Enforcing data standards helps ensure consistency and compatibility with other companies' data systems, which is crucial in establishing supply chains.

Question 12

Among the responsibilities of database administration are data planning and arbitration of disputes.

Accepted Answer

The answer of Among the responsibilities of database administration are...

Question 13

The nature of the interaction of an active data dictionary with the IS environment can be a matter of input into the data dictionary, output from it, or both.

Accepted Answer

An active data dictionary can interact with the IS environment through input, output, or both.

Question 14

Data administration typically carries out many of the policies set by database administration.

Accepted Answer

The answer of Data administration typically carries out many of...

Question 15

Data administration is not concerned with data security because that is the responsibility of the company's firewalls.

Accepted Answer

Data administration includes data security as one of its main responsibilities. It involves developing security policies, implementing security measures, and monitoring data access to ensure that data remains secure. While firewalls are one aspect of data security, data administration is responsible for many other aspects as well.

Question 16

A data dictionary is a program that the IS function uses to help manage itself.

Accepted Answer

A data dictionary is not a program, but rather a tool used to define and manage data within a system.

Question 17

Data administration personnel serving as liaisons to systems analysts and programmers help determine which of the data items needed for an application already exist in the database.

Accepted Answer

Data administration personnel serve as a bridge between business needs and technical implementation, and part of their role is to work with analysts and programmers to identify existing data items in the database.

Question 18

One of the advantages of data and database administration is efficiency in job specialization.

Accepted Answer

With data and database administration, job roles can be clearly defined and assigned to specialized individuals, which can lead to increased efficiency and productivity in completing tasks.

Question 19

An example of an active data dictionary's use in the "input sense" is if it must be consulted to see who is authorized to access particular data.

Accepted Answer

An active data dictionary in the "input sense" typically means it is automatically updated as changes occur in the database structure, not that it is consulted for access permissions. Access permissions would be an example of how the data dictionary is used in the "output sense," as it provides information about the database.

Question 20

Among the responsibilities of database administration is the physical design of shared databases.

Accepted Answer

Database administrators are responsible for the physical design of shared databases, which includes determining storage requirements, selecting storage media, developing backup and recovery procedures, and optimizing database performance.

Quiz 10: Data Administration, Database Administration, and Data Dictionaries