Question 1

____________________ deals with the rights of individuals and the organization to determine the "who,what,when,where,and how" of data usage.

Accepted Answer

The answer of ____________________ deals with the rights of individuals...

Question 2

A ____ is a named collection of settings that control how much of the database resource a given user can use.
A) user
B) role
C) profile
D) manager

Accepted Answer

A profile is a named collection of settings that control how much of the database resource a given user can use. Users can be assigned to a profile, and the settings defined in the profile will apply to that user. Roles are a named collection of privileges that can be assigned to users, and a manager is a person who oversees a team or department. None of these choices specify a collection of settings that control user resource usage, except for profiles.

Question 3

____ CASE tools provide support for the coding and implementation phases.
A) Front-end
B) Back-end
C) Vertical
D) Horizontal

Accepted Answer

Back-end CASE tools are designed to assist in the coding and implementation phases of software development, focusing on tasks such as code generation, testing, and maintenance.

Question 4

A(n)____ is a logical storage space in Oracle.
A) audit log
B) datafile
C) schema
D) tablespace

Accepted Answer

A tablespace is a logical storage space in Oracle that contains datafiles, which hold the actual data. Tablespaces are used to manage storage of database objects, such as tables, indexes, and partitions.

Question 5

Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation,from sales to services,and from daily decision making to strategic planning.

Accepted Answer

The answer of Most of today's successful organizations depend on...

Question 6

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

Accepted Answer

Initialization parameters define and reserve the resources that must be used by the database at run time, including memory allocation and hardware utilization. The security component controls access to the data, the authorization manager determines who is authorized to perform certain actions within the database, and the administrator oversees the overall management and maintenance of the database. However, neither of these functions is directly related to resource reservation.

Question 7

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 overlap some.

Accepted Answer

The answer of The ____________________,also known as the information resource...

Question 8

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
A) user
B) role
C) profile
D) manager

Accepted Answer

A role is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources. Users can be assigned one or more roles, which allows them to access the database according to their specific needs and responsibilities. Profiles and managers are not directly related to database access privileges.

Question 9

____________________ decisions are short term and affect only daily operations; for example,deciding to change the price of a product to clear it from inventory.

Accepted Answer

The answer of ____________________ decisions are short term and affect...

Question 10

The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.

Accepted Answer

The answer of The DBA's function includes educating the ____________________...

Question 11

Placing the DBA function in a(n)____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

Accepted Answer

The answer of Placing the DBA function in a(n)____________________ position...

Question 12

The requirement that a password must have a maximum of 12 characters is an example of a(n)____________________.

Accepted Answer

The answer of The requirement that a password must have...

Question 13

An organization is subject to a(n)_________________________ cycle; that is,the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.

Accepted Answer

The answer of An organization is subject to a(n)_________________________ cycle;...

Question 14

A(n)____ serves as the basis for planning,development,and control of future information systems
A) access plan
B) active data dictionary
C) information systems architecture (ISA)
D) security policy

Accepted Answer

An Information Systems Architecture (ISA) serves as the basis for planning, development, and control of future information systems. It provides a comprehensive view of the current and desired capabilities and infrastructure of an organization's information systems. This includes hardware, software, data, networks, and security requirements. The ISA also provides guidance on how these elements should be integrated and optimized to achieve the organization's strategic goals.

Question 15

A ____ is a uniquely identifiable object that allows a given person to log on to the database.
A) user
B) role
C) profile
D) manager

Accepted Answer

A user is a uniquely identifiable object that allows a given person to log on to the database. A role is a collection of privileges or permissions that a user can be assigned to, a profile is a set of user-specific settings, and a manager is a person responsible for overseeing a team or department. None of these fully fit the description provided.

Question 16

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

Accepted Answer

The screen painter and report generator component of a CASE tool is responsible for producing the input/output formats of an information system. The analysis component focuses on understanding the requirements and objectives of the system, while the graphics component deals with creating visual representations. The program document generator produces code documentation.

Question 17

In the Oracle Enterprise Manager,a ____ is basically any object created by end users; for example,tables,views,indexes,stored procedures,and triggers.
A) component
B) database object
C) policy
D) role

Accepted Answer

The definition given in the question describes a database object, which is a term commonly used in Oracle and other database management systems. Components, policies, and roles are also important concepts in Oracle Enterprise Manager, but they do not fit the definition given in the question.

Question 18

The general coordinator of all DBAs is sometimes known as the ____________________ administrator.

Accepted Answer

The answer of The general coordinator of all DBAs is...

Question 19

____ 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

Accepted Answer

Information engineering (IE) focuses on understanding and structuring business needs and translating them into data models, processes, and systems that help achieve strategic goals.

Question 20

The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n)_________________________ department.

Accepted Answer

The answer of The advent of the DBMS and its...

Quiz 15: Database Administration and Security

____________________ deals with the rights of individuals and the organization to determine the "who,what,when,where,and how" of data usage.

A ____ is a named collection of settings that control how much of the database resource a given user can use.

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

A(n) ____ is a logical storage space in Oracle.

Most of today's successful organizations depend on the ____________________ database to provide support for all of their operations-from design to implementation,from sales to services,and from daily decision making to strategic planning.

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

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 overlap some.

A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

____________________ decisions are short term and affect only daily operations; for example,deciding to change the price of a product to clear it from inventory.

The DBA's function includes educating the ____________________ in the services provided and how those services enhance data stewardship and data security.

Placing the DBA function in a(n)____________________ position often creates a consulting environment in which the DBA is able to devise the data administration strategy but does not have the authority to enforce it or to resolve possible conflicts.

The requirement that a password must have a maximum of 12 characters is an example of a(n)____________________.

An organization is subject to a(n)_________________________ cycle; that is,the data user applies intelligence to data to produce information that is the basis of knowledge used in decision making by the user.

A(n) ____ serves as the basis for planning,development,and control of future information systems

A ____ is a uniquely identifiable object that allows a given person to log on to the database.

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

In the Oracle Enterprise Manager,a ____ is basically any object created by end users; for example,tables,views,indexes,stored procedures,and triggers.

The general coordinator of all DBAs is sometimes known as the ____________________ administrator.

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

The advent of the DBMS and its shared view of data produced a new level of data management sophistication and led the DP department to evolve into a(n)_________________________ department.