Deck 16: Database Administration and Security

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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

Question 13

In the context of database administration, standards are written instructions that describe a series of steps to be followed during the performance of a given activity.

Question 14

A security vulnerability is a collection of standards and policies created to guarantee the security of a system and ensure auditing and compliance.

Question 15

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

Question 16

A passive data dictionary is one that is updated automatically with every database access to keep its access information up to date.

Question 17

A security breach is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

Question 18

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

Question 19

Incremental backups produce a backup of all data.

Question 20

The DBA must supervise the installation of all software and hardware designated to support the data administration strategy.

Question 21

The _____ administrator is responsible for strategic planning.

A) system
B) data
C) database
D) program

Question 22

At the level of middle management, the database must be able to provide _____.

A) frameworks for defining and enforcing organizational policies
B) data necessary for tactical decisions and planning
C) feedback to monitor whether a company is achieving its goals
D) access to external and internal data to identify growth opportunities

Question 23

_____ deals with ensuring that data is protected against unauthorized access, and if the data are accessed by an authorized user, that the data are used only for an authorized purpose.

A) Integrity
B) Compliance
C) Availability
D) Confidentiality

Question 24

_____ are more detailed and specific than policies and describe the minimum requirements of a given DBA activity.

A) Guidelines
B) Standards
C) Procedures
D) Documentations

Question 25

Which of the following is a reason why a DBMS's daily operations must be clearly documented?

A) Documentation of the daily operations help a company set its long-term goals.
B) Documentation of the daily operations help manage the manual data resources of a company.
C) Documentation of the daily operations help pinpoint causes and solutions of database problems.
D) Documentation of the daily operations help free the DBA from many lower-level technology-oriented tasks.

Question 26

User-access management is a subset of _____.

A) password protection
B) authorization management
C) data integrity management
D) managerial control

Question 27

In the context of the data-information-decision cycle, decisions made by high-level managers trigger actions inan organization's:

A) lower levels.
B) top levels.
C) target markets.
D) customer base.

Question 28

Coordinating, monitoring, and allocating database administration resources is included in a DBA's _____ role.

A) operative
B) arbitration
C) technical
D) managerial

Question 29

Database administration operations are commonly defined and divided according to the phases of the _____.

A) SLA
B) DBLC
C) SDLC
D) MRA

Question 30

The person responsible for the control of the centralized and shared database is the database _____.

A) analyst
B) administrator
C) programmer
D) user

Question 31

_____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications.

A) Backup and recovery
B) System support
C) Performance monitoring and tuning
D) Security auditing and monitoring

Question 32

"A password must have a minimum of five characters" is an example of a _____.

A) policy
B) rule
C) procedure
D) standard

Question 33

In the context of data backup and recovery, the activities of a _____ includes the DBA operations that are classified as disaster management.

A) database programmer
B) systems analyst
C) data administrator
D) database security officer

Question 34

When introducing a database into an organization, the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions. This leads to a(n) _____ impact of the new database system.

A) cultural
B) managerial
C) technical
D) operational

Question 35

Instructions to create a password are an example of a _____.

A) rule
B) policy
C) standard
D) procedure

Question 36

A data administrator is also known as a(n) _____.

A) data security officer
B) systems administrator
C) information resource manager
D) information engineering officer

Question 37

A(n) _____ plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time.

A) access
B) completion
C) application
D) communications

Question 38

_____ security breaches include database access by computer viruses and by hackers whose actions are designed to destroy or alter data.

A) Debilitative
B) Preserving
C) Corrupting
D) Destructive

Question 39

"All users must have passwords" is an example of a _____.

A) rule
B) policy
C) standard
D) procedure

Question 40

When performing user access management, a DBA defines each user to the database at the _____ levels.

A) application and DBMS
B) operating system and DBMS
C) operating system and application
D) application and network

Question 41

In the context of an organization's managerial structure, _____ decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.

Question 42

A(n) _____ data dictionary is automatically updated by the DBMS with every database access.

A) dynamic
B) active
C) passive
D) static

Question 43

In the context of the advancements in DBMS technology, the use of _____ data services can free the DBA from many lower-level technology-oriented tasks.

Question 44

In the context of data quality management tools, _____ software is one that gathers statistics, analyzes existing data sources and metadata to determine patterns, and compares the patterns against standards that the organization has defined.

Question 45

_____ allows for the translation of the company's strategic goals into the data and applications that will help the company achieve those goals.

A) Access Management
B) Business Intelligence
C) Information engineering (IE)
D) MOLAP

Question 46

The _____ aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization.

Question 47

A(n) _____ data dictionary is not updated automatically and usually requires a batch process to be run.

A) active
B) passive
C) static
D) dynamic

Question 48

In the context of ensuring integrity of a database, a(n) _____ transaction is one that does not overload the DBMS.

Question 49

In the context of developing a data administration strategy, a(n) _____ provides a framework that includes computerized, automated, and integrated tools such as a DBMS and CASE tools.

A) access plan
B) active data dictionary
C) information systems architecture
D) security policy

Question 50

In the context of database administration, _____ is the extent to which individuals and organizations have the right to determine the "who, what, when, where, and how" of data usage.

Question 51

_____ CASE tools provide support for the coding and implementation phases.

A) Front-end
B) Back-end
C) Vertical
D) Horizontal

Question 52

The DSO's activities are often classified as _____ management, which includes all DBA activities designed to ensure data availability following a physical calamity or a database integrity failure.

Question 53

A(n) _____ is a logical storage area in Oracle.

A) audit log
B) datafile
C) schema
D) tablespace

Question 54

Based on the type of decision-making support required, database users may be classified into: operational, tactical, or _____.

Question 55

The _____, also known as the information resource manager (IRM), usually reports directly to top management and is given a higher degree of responsibility and authority than the DBA, although the two roles can overlap.

Question 56

In the context of database usage monitoring, a(n) _____ is a file that automatically records a brief description of the database operations performed by all users.

A) change tracker
B) digital footprint
C) paper trail
D) audit log

Question 57

The _____ component of a CASE tool produces the information system's input/output formats.

A) analysis
B) graphics
C) program document generator
D) screen painter and report generator

Question 58

_____ CASE tools provide support for the planning, analysis, and design phases.

A) Front-end
B) Back-end
C) Vertical
D) Horizontal

Question 59

In case a company installs several incompatible databases and assigns a DBA for each of them, the general coordinator of all such DBAs is known as the _____ administrator.

Question 60

One of the important functions provided by the database _____ is to reserve the resources that must be used by the database at run time.

A) security component
B) authorization manager
C) initialization parameters
D) administrator

Question 61

In the context of Oracle Enterprise Manager, a(n) _____ is a named collection of settings that control how much of the database resource
a given user can access.

Question 62

Describe the DBA's managerial role.

Question 63

In the context of Oracle Enterprise Manager, a(n) _____ is a named collection of database access privileges that authorize a user to connect to the database and use its system resources.

Question 64

A(n) _____ physically stores the database's data.

Question 65

Describe the need for convenient and safe backup storage.

Question 66

Each database has an associated_____ file that is read at instance startup, stores run-time configuration parameters, and is used to set the working environment for the database.

Question 67

A security _____ is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

Question 68

Explain user requirements gathering as part of the DBA's end-user support services.

Question 69

Explain conflict and problem resolution as part of the DBA's end-user support services.

Question 70

Performance monitoring and _____ activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

Question 71

Within the data security framework, _____ is concerned with keeping data consistent and free of errors or anomalies.

Question 72

In the context of Oracle Enterprise Manager, a(n) _____ isa uniquely identifiable object that allows a given person to log on to the
database.

Question 73

In the context of Oracle Enterprise Manager, "CONNECT" allows a user to connect to the database and then create and modify tables, views, and other data-related objects. This is an example of a(n) _____.

Question 74

The DBA must review the database application design to ensure that transactions are _____, meaning that they mirror real-world events.