Chapter 16 (True/False)

Question 1 of 30

1

1.The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.

Select one of the following:

True
False

Explanation

Question 2 of 30

1

2.An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations

Select one of the following:

True
False

Explanation

Question 3 of 30

1

3.Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

Select one of the following:

True
False

Explanation

Question 4 of 30

1

4.The introduction of a DBMS represents a big change and challenge, and is likely to have a profound impact throughout the organization.

Select one of the following:

True
False

Explanation

Question 5 of 30

1

5.The DBA interacts with the end user by providing data and information support services to the organization’s departments.

Select one of the following:

True
False

Explanation

Question 6 of 30

1

6.The security, privacy, and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.

Select one of the following:

True
False

Explanation

Question 7 of 30

1

7.Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.

Select one of the following:

True
False

Explanation

Question 8 of 30

1

8.A full backup, or database dump, produces a complete copy of the entire database.

Select one of the following:

True
False

Explanation

Question 9 of 30

1

9.Incremental backups produce a backup of all data.

Select one of the following:

True
False

Explanation

Question 10 of 30

1

10.Concurrent backups take place while the user is working on the database.

Select one of the following:

True
False

Explanation

Question 11 of 30

1

11.Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database.

Select one of the following:

True
False

Explanation

Question 12 of 30

1

12.The storage locations for multiple backups must include sites inside and outside the organization.

Select one of the following:

True
False

Explanation

Question 13 of 30

1

13.Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.

Select one of the following:

True
False

Explanation

Question 14 of 30

1

14.The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.

Select one of the following:

True
False

Explanation

Question 15 of 30

1

15.The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format.

Select one of the following:

True
False

Explanation

Question 16 of 30

1

16.The end user’s role requires a broad understanding of DBMS functions, configuration, programming languages, data modeling and design methodologies, and so on.

Select one of the following:

True
False

Explanation

Question 17 of 30

1

17.The DBA must supervise the installation of all software and hardware designated to support the data administration strategy, must have a thorough understanding of the components being installed, and must be familiar with the installation, configuration, and startup procedures of such components.

Select one of the following:

True
False

Explanation

Question 18 of 30

1

18.The DBA function provides data modeling and design services to the enduser community, often through coordination with an application development group within the data-processing department.

Select one of the following:

True
False

Explanation

Question 19 of 30

1

19.The DBA works with managers to ensure the quality and integrity of database design and transactions.

Select one of the following:

True
False

Explanation

Question 20 of 30

1

20.The end user must provide testing and evaluation services for all the database and DBA applications.

Select one of the following:

True
False

Explanation

Question 21 of 30

1

21.Testing procedures and standards must already be in place before any application program can be approved for use in the company.

Select one of the following:

True
False

Explanation

Question 22 of 30

1

22.System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications.

Select one of the following:

True
False

Explanation

Question 23 of 30

1

23.The allocation of storage resources is determined when the DBMS is created.

Select one of the following:

True
False

Explanation

Question 24 of 30

1

24.Training people to use the DBMS and its tools is not included in the DBA’s technical activities.

Select one of the following:

True
False

Explanation

Question 25 of 30

1

25.The maintenance activities of the DBA are an extension of the operational activities.

Select one of the following:

True
False

Explanation

Question 26 of 30

1

26.Security breaches can yield a database whose integrity is either preserved or corrupted.

Select one of the following:

True
False

Explanation

Question 27 of 30

1

27.Protecting the data in the database is a function of authorization management.

Select one of the following:

True
False

Explanation

Question 28 of 30

1

28.The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.

Select one of the following:

True
False

Explanation

Question 29 of 30

1

29.Database access can be controlled by placing limits on the use of the DBMS’s query and reporting tools.

Select one of the following:

True
False

Explanation

Question 30 of 30

1

30.The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.

Select one of the following:

True
False

	Created by . . over 7 years ago

asdf Quiz on Chapter 16 (True/False), created by . . on 08/09/2016.

Chapter 16 (True/False)

Question 1 of 30

1.The DBMS must provide tools that give each level of management a different view of the data and support the required level of decision-making.

Select one of the following:

Explanation

Question 2 of 30

2.An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations

Select one of the following:

Explanation

Question 3 of 30

3.Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.

Select one of the following:

Explanation

Question 4 of 30

4.The introduction of a DBMS represents a big change and challenge, and is likely to have a profound impact throughout the organization.

Select one of the following:

Explanation

Question 5 of 30

5.The DBA interacts with the end user by providing data and information support services to the organization’s departments.

Select one of the following:

Explanation

Question 6 of 30

6.The security, privacy, and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.

Select one of the following:

Explanation

Question 7 of 30

7.Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.

Select one of the following:

Explanation

Question 8 of 30

8.A full backup, or database dump, produces a complete copy of the entire database.

Select one of the following:

Explanation

Question 9 of 30

9.Incremental backups produce a backup of all data.

Select one of the following:

Explanation

Question 10 of 30

10.Concurrent backups take place while the user is working on the database.

Select one of the following:

Explanation

Question 11 of 30

11.Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database.

Select one of the following:

Explanation

Question 12 of 30

12.The storage locations for multiple backups must include sites inside and outside the organization.

Select one of the following:

Explanation

Question 13 of 30

13.Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.

Select one of the following:

Explanation

Question 14 of 30

14.The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.

Select one of the following:

Explanation

Question 15 of 30

15.The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format.

Select one of the following:

Explanation

Question 16 of 30

16.The end user’s role requires a broad understanding of DBMS functions, configuration, programming languages, data modeling and design methodologies, and so on.

Select one of the following:

Explanation

Question 17 of 30

17.The DBA must supervise the installation of all software and hardware designated to support the data administration strategy, must have a thorough understanding of the components being installed, and must be familiar with the installation, configuration, and startup procedures of such components.

Select one of the following:

Explanation

Question 18 of 30

18.The DBA function provides data modeling and design services to the enduser community, often through coordination with an application development group within the data-processing department.

Select one of the following:

Explanation

Question 19 of 30

19.The DBA works with managers to ensure the quality and integrity of database design and transactions.

Select one of the following:

Explanation

Question 20 of 30

20.The end user must provide testing and evaluation services for all the database and DBA applications.