Question 1

Which of the following may provide many distinct views of the database?
A) the schema
B) the internal view
C) the user view
D) the conceptual view

Accepted Answer

The user view may provide many distinct views of the database because different users or groups may have different needs and requirements for accessing and viewing the data. Each user or group may have a customized view of the database that presents only the information relevant to their tasks or responsibilities. The schema, internal view, and conceptual view are more standardized and may not vary as much across different users or groups.

Question 2

A description of the physical arrangement of records in the database is
A) the internal view
B) the conceptual view
C) the subschema
D) the external view

Accepted Answer

The physical arrangement of records in the database is part of the internal view, which is concerned with how the data is physically stored and accessed in the database management system.

Question 3

The data manipulation language
A) defines the database to the database management system
B) transfers data to the buffer area for manipulation
C) enables application programs to interact with and manipulate the database
D) describes every data element in the database

Accepted Answer

The data manipulation language (DML) enables application programs to interact with and manipulate the database, such as retrieving, inserting, updating, and deleting data. The task of defining the database to the database management system (DBMS) is done by the data definition language (DDL), while transferring data to the buffer area for manipulation is done by the data transmission language (DTL). describing every data element in the database is done by the data dictionary.

Question 4

Users access the database
A) by direct query
B) by developing operating software
C) by constantly interacting with systems programmers
D) all of the above

Accepted Answer

The most common way for users to access a database is through direct queries using SQL or other programming languages that interface with the database. Developing operating software and constantly interacting with systems programmers are not necessary for typical user access to a database.

Question 5

The data definition language
A) identifies, for the database management system, the names and relationships of all data elements, records, and files that comprise the database
B) inserts database commands into application programs to enable standard programs to interact with and manipulate the database
C) permits users to process data in the database without the need for conventional programs
D) describes every data element in the database

Accepted Answer

The data definition language (DDL) is responsible for identifying the names and relationships of all data elements, records, and files that make up the database. It defines the structure and layout of the database, including tables, fields, and indexes. DDL is used to create, alter, and drop database objects like databases, tables, and indexes.

Question 6

An ER diagram is a graphical representation of a data model.

Accepted Answer

An ER diagram is a visual tool used to represent a data model. It includes entities, attributes of those entities, and the relationships between them.

Question 7

Which characteristic is associated with the database approach to data management?
A) data sharing
B) multiple storage procedures
C) data redundancy
D) excessive storage costs

Accepted Answer

Data sharing is a key characteristic of the database approach to data management, where data is stored centrally and can be accessed by various users for different purposes. This enables efficient data sharing and hassle-free data management. Multiple storage procedures, data redundancy, and excessive storage costs are not associated with the database approach to data management.

Question 8

A lockout is a software control that prevents multiple users from simultaneous access to data.

Accepted Answer

A lockout feature is used to prevent multiple users from accessing the same data simultaneously in order to avoid any conflicts or data corruption. It is a software mechanism that ensures mutual exclusion and allows only one user to access the data at a time.

Question 9

The task of searching the database to locate a stored record for processing is called
A) data deletion
B) data storage
C) data attribution
D) data retrieval

Accepted Answer

The task of searching the database to locate a stored record for processing is called data retrieval.

Question 10

All of the following are basic data management tasks except
A) data deletion
B) data storage
C) data attribution
D) data retrieval

Accepted Answer

Data deletion, storage, and retrieval are all part of basic data management tasks, but data attribution refers to the process of assigning authorship or ownership to a piece of data and is not a basic data management task.

Question 11

Which statement is not correct? A query language like SQL
A) is written in a fourth-generation language
B) requires user familiarity with COBOL
C) allows users to retrieve and modify data
D) reduces reliance on programmers

Accepted Answer

SQL does not require user familiarity with COBOL. It is a fourth-generation language that allows users to retrieve and modify data, reducing reliance on programmers.

Question 12

Which characteristic is not associated with the database approach to data management?
A) the ability to process data without the help of a programmer
B) the ability to control access to the data
C) constant production of backups
D) the inability to determine what data is available

Accepted Answer

The inability to determine what data is available is not a characteristic of the database approach to data management. In fact, one key feature of databases is their ability to provide a clear and structured view of the data they contain, often through the use of schema or data dictionaries. The other three options listed (the ability to process data without the help of a programmer, the ability to control access to the data, and constant production of backups) are all hallmarks of the database approach.

Question 13

In a hierarchical model
A) links between related records are implicit
B) the way to access data is by following a predefined data path.
C) an owner (parent) record may own just one member (child) record
D) a member (child) record may have more than one owner (parent)

Accepted Answer

In a hierarchical model, data is organized in a tree-like structure with a defined path for accessing data. The links between related records are implicit, meaning that the path for accessing data must be predefined. While a parent record may own multiple member records, a member record can only have one parent record. However, this is not relevant to the question.

Question 14

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

Accepted Answer

The term occurrence refers to the number of times an entity instance appears in a relationship. It does not refer to the number of attributes or fields.

Question 15

An entity is any physical thing about which the organization wishes to capture data.

Accepted Answer

An entity can be a physical thing, but it can also be an abstract concept or event about which the organization wishes to capture data.

Question 16

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Accepted Answer

This is the definition of cardinality in a relational database model.

Question 17

Which of the following is not a problem usually associated with the flat-file approach to data management?
A) data redundancy
B) restricting access to data to the primary user
C) data storage
D) currency of information

Accepted Answer

Restricting access to data to the primary user is not usually associated with the flat-file approach to data management. The other options - data redundancy, data storage, and currency of information - are common problems with the flat-file approach.

Question 18

Which duty is not the responsibility of the database administrator?
A) to develop and maintain the data dictionary
B) to implement security controls
C) to design application programs
D) to design the subschema

Accepted Answer

Designing application programs is not the responsibility of the database administrator, as it falls under the domain of application developers. The other options, including developing and maintaining the data dictionary, implementing security controls, and designing the subschema, are all duties of the database administrator.

Question 19

Which of the following is not a responsibility of the database management system?
A) provide an interface between the users and the physical database
B) provide security against a natural disaster
C) ensure that the internal schema and external schema are consistent
D) authorize access to portions of the database

Accepted Answer

The answer of Which of the following is not a...

Question 20

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?
A) the database management system
B) the database sdministrator
C) the physical database
D) the conceptual database

Accepted Answer

The answer of The textbook refers to four interrelated components...

Quiz 4: IT Security Part II: Auditing Database Systems

Which of the following may provide many distinct views of the database?

A description of the physical arrangement of records in the database is

The data manipulation language

Users access the database

The data definition language

An ER diagram is a graphical representation of a data model.

Which characteristic is associated with the database approach to data management?

A lockout is a software control that prevents multiple users from simultaneous access to data.

The task of searching the database to locate a stored record for processing is called

All of the following are basic data management tasks except

Which statement is not correct? A query language like SQL

Which characteristic is not associated with the database approach to data management?

In a hierarchical model

The term occurrence is used to describe the number of attributes or fields pertaining to a specific entity.

An entity is any physical thing about which the organization wishes to capture data.

Cardinality describes the number of possible occurrences in one table that are associated with a single occurrence in a related table.

Which of the following is not a problem usually associated with the flat-file approach to data management?

Which duty is not the responsibility of the database administrator?

Which of the following is not a responsibility of the database management system?

The textbook refers to four interrelated components of the database concept.Which of the following is not one of the components?