Question 1

____ 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 2

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

Database objects are any objects created by end users, including tables, views, indexes, stored procedures, and triggers. Components, policies, and roles are all different types of configuration and management options within Oracle Enterprise Manager.

Question 3

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) _________________________...

Question 4

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 5

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 information system's input/output formats, such as screens and reports. The analysis component deals with gathering and analyzing user requirements, while the graphics component deals with creating visual representations of the system, and the program document generator deals with producing detailed documentation of the system's code.

Question 6

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 used to store and organize database objects like tables, indexes, and partitions. It is a fundamental component of Oracle's storage architecture and provides a way to allocate and manage disk space usage for a database. Options A, B, and C are related to the Oracle database but do not directly refer to logical storage spaces like tablespaces.

Question 7

____________________ 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 8

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 9

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

Information systems architecture (ISA) serves as a blueprint or framework for designing, implementing, and maintaining effective and efficient information systems. It outlines the components, interrelationships, interface standards, and operational guidelines for various information technologies and services that support the organization's strategic objectives and operational requirements. It provides a standardized and integrated approach to information system development and management, reduces redundancy and inconsistency, and facilitates interoperability and scalability. It also helps to align the information technology with the business goals and user needs, and to ensure the security, privacy, and regulatory compliance of the information assets. Therefore, ISA is essential for effective information system planning, development, and control.

Question 10

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) ____________________...

Question 11

____ 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 12

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

The definition provided matches that of a profile in Oracle Database. Profiles are used to limit the amount of resources, such as CPU and memory, that a user can consume. Users can be assigned to different profiles based on their needs and usage patterns. Roles are used to group privileges and can be assigned to multiple users, but they do not control resource usage. A manager is not a concept in Oracle Database.

Question 13

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

Question 14

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 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. Roles, profiles, and managers are all related to user permissions and access, but do not directly identify an individual user.

Question 16

____________________ 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 17

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

Question 18

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. User refers to an individual who connects to the database system, while a profile is a collection of settings and parameters that control the behavior of a database user session. Manager does not relate to database access privileges.

Question 19

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 20

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 are the configuration settings used to establish the behavior and operational characteristics of a database. This includes resources such as memory, storage, and CPU, which need to be reserved during runtime. The initialization parameters ensure that these resources are allocated in the appropriate levels to ensure optimal performance and availability of the database.

Quiz 12: Database Administration and Security

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

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

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.

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.

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

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

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

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

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

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.

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

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

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.

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

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

____________________ 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 ____________________, 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.

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

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