Question 1

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

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 to one or multiple roles to grant them access to the necessary privileges to perform their tasks. Profiles are used to set resource limits for a user session, and managers refer to a job title or a person overseeing a group of users.

Question 2

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

Accepted Answer

A user is a uniquely identifiable object that allows a given person to log on to the database. Roles and profiles are also objects in a database, but they do not directly relate to a person's ability to log on. A manager may have access to user accounts, but is not a type of object in a database related to user authentication.

Question 3

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 4

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

Accepted Answer

A profile is a named collection of settings that control how much of the database resource a given user can use. It is used to limit resource consumption and prevent resource contention. Profiles are assigned to users and control resource usage such as CPU time, sessions, and concurrent requests. The other options - user, role, and manager - do not reflect the concept of a collection of settings that control resource usage.

Question 5

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

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 6

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 7

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 8

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 9

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

Accepted Answer

The screen painter and report generator are responsible for creating the input/output formats of an information system using a CASE tool. The other components listed (analysis, graphics, program document generator) do not directly create input/output formats.

Question 10

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

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

Accepted Answer

A tablespace is a logical storage space in Oracle used for organizing and managing physical storage units called datafiles. Each table, index, and partition is stored in a tablespace, which can be managed separately for performance, security, and backup/recovery purposes. Other choices like an audit log and a schema are also important components of Oracle databases but do not directly relate to storage management.

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

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

Accepted Answer

Initialization parameters are used to configure and reserve resources for the database at run time. These parameters include memory allocation, disk space, and processing power, among others. By setting and managing these parameters, the database can be optimized for performance and reliability. The security component and authorization manager are related to access control and user privileges, while the administrator is responsible for managing the overall database system.

Question 14

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 15

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

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 17

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

Accepted Answer

The description provided fits the definition of a database object, which encompasses all the listed examples. Components refer to different software entities, policies are sets of rules for managing resources, and roles define different levels of access for users.

Question 18

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

Question 19

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

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 20

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

Accepted Answer

An Information Systems Architecture (ISA) provides a comprehensive framework and set of rules to guide the planning, development, maintenance, and control of future information systems. It defines the components, relationships, and principles of the system and serves as a blueprint for designing, implementing, and managing different aspects of an organization's IT infrastructure. A security policy is a set of rules and procedures that govern the use and protection of an organization's information assets, while an access plan and active data dictionary are more specific components of an ISA.

Quiz 15: Database Administration and Security