Questão 1
Questão
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.
Questão 2
Questão
2.An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations
Questão 3
Questão
3.Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers.
Questão 4
Questão
4.The introduction of a DBMS represents a big change and challenge, and is likely to have a profound impact throughout the organization.
Questão 5
Questão
5.The DBA interacts with the end user by providing data and information support services to the organization’s departments.
Questão 6
Questão
6.The security, privacy, and integrity of the data in the database are of minimal concern to DBAs who manage current DBMS installations.
Questão 7
Questão
7.Disaster management includes all the end-user activities designed to secure data availability following a physical disaster or a database integrity failure.
Questão 8
Questão
8.A full backup, or database dump, produces a complete copy of the entire database.
Questão 9
Questão
9.Incremental backups produce a backup of all data.
Questão 10
Questão
10.Concurrent backups take place while the user is working on the database.
Questão 11
Questão
11.Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database.
Questão 12
Questão
12.The storage locations for multiple backups must include sites inside and outside the organization.
Questão 13
Questão
13.Physical protection of hardware and software must be accomplished by the use of open installations with restricted area access.
Questão 14
Questão
14.The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure.
Questão 15
Questão
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.
Questão 16
Questão
16.The end user’s role requires a broad understanding of DBMS functions, configuration, programming languages, data modeling and design methodologies, and so on.
Questão 17
Questão
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.
Questão 18
Questão
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.
Questão 19
Questão
19.The DBA works with managers to ensure the quality and integrity of database design and transactions.
Questão 20
Questão
20.The end user must provide testing and evaluation services for all the database and DBA applications.
Questão 21
Questão
21.Testing procedures and standards must already be in place before any application program can be approved for use in the company.
Questão 22
Questão
22.System support activities cover all tasks directly related to the day-to-day operations of a DBMS and its applications.
Questão 23
Questão
23.The allocation of storage resources is determined when the DBMS is created.
Questão 24
Questão
24.Training people to use the DBMS and its tools is not included in the DBA’s technical activities.
Questão 25
Questão
25.The maintenance activities of the DBA are an extension of the operational activities.
Questão 26
Questão
26.Security breaches can yield a database whose integrity is either preserved or corrupted.
Questão 27
Questão
27.Protecting the data in the database is a function of authorization management.
Questão 28
Questão
28.The DBA must define data views to protect and control the scope of the data that are accessible to an authorized user.
Questão 29
Questão
29.Database access can be controlled by placing limits on the use of the DBMS’s query and reporting tools.
Questão 30
Questão
30.The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.