Question 1

A primary key is one of the data items in a record that uniquely identifies a record.

Accepted Answer

A) True 
 B)False

Question 2

In relational structures,a file is called a relation,a record is usually referred to as a tuple,and the attribute value set is called a domain.

Accepted Answer

A) True 
 B)False

Question 3

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

Accepted Answer

A) a transaction file 
B) a relational file 
C) a master file 
D) a keyed index file 
A) a transaction file 
B) a relational file 
C) a master file 
D) a keyed index file

Question 4

Which of the following is not one of the four anomalies that may occur when creating database tables?

Accepted Answer

A) data redundancy 
B) update anomaly 
C) primary anomaly 
D) insert anomaly 
E) deletion anomaly 
A) data redundancy 
B) update anomaly 
C) primary anomaly 
D) insert anomaly 
E) deletion anomaly

Question 5

Which is not an effectiveness objective of the database?

Accepted Answer

A) ensuring that data can be shared among users for a variety of applications 
B) ensuring all data required for current and future applications will be readily available 
C) allowing the database to evolve and the needs of the users to grow 
D) allowing users to construct their personal view of the data without concern for the way the data are physically stored 
E) maintaining data that are both accurate and inconsistent 
A) ensuring that data can be shared among users for a variety of applications 
B) ensuring all data required for current and future applications will be readily available 
C) allowing the database to evolve and the needs of the users to grow 
D) allowing users to construct their personal view of the data without concern for the way the data are physically stored 
E) maintaining data that are both accurate and inconsistent

Question 6

An update anomaly occurs when the same data are stored in more than one place in the database.

Accepted Answer

A) True 
 B)False

Question 7

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key.
II) Remove any transitive dependencies.
III) All partial dependencies are removed and placed in another relation.

Accepted Answer

A) III - II - I 
B) I - II - III 
C) III - I - II 
D) II - I - III 
E) I - III - II 
A) III - II - I 
B) I - II - III 
C) III - I - II 
D) II - I - III 
E) I - III - II

Question 8

A well-designed ________ can be more flexible than separate files.

Accepted Answer

A) data dictionary 
B) data warehouse 
C) data model 
D) database 
A) data dictionary 
B) data warehouse 
C) data model 
D) database

Question 9

Many data items can be packed into a field; the field can be read and converted to a number of data items.

Accepted Answer

A) True 
 B)False

Question 10

REMOVE is the logical ordering of rows in a relation according to some key.

Accepted Answer

A) True 
 B)False

Question 11

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

Accepted Answer

A) True 
 B)False

Question 12

An attribute is some characteristic of a(n):

Accepted Answer

A) entity. 
B) relationship. 
C) reality. 
D) record definition. 
A) entity. 
B) relationship. 
C) reality. 
D) record definition.

Question 13

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

Accepted Answer

A) True 
 B)False

Question 14

Which is an advantage of the database approach?

Accepted Answer

A) All of the data are stored in one place. 
B) Data are more vulnerable to catastrophes. 
C) It comes about when attempting to keep the cost of storing the data to a reasonable amount. 
D) It allows users their own view of the data. 
A) All of the data are stored in one place. 
B) Data are more vulnerable to catastrophes. 
C) It comes about when attempting to keep the cost of storing the data to a reasonable amount. 
D) It allows users their own view of the data.

Question 15

A one-to-many relationship may be implemented using a drop-down list.

Accepted Answer

A) True 
 B)False

Question 16

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Accepted Answer

A) referential integrity. 
B) normalization. 
C) denormalization. 
D) data warehousing. 
E) online analytic processing. 
A) referential integrity. 
B) normalization. 
C) denormalization. 
D) data warehousing. 
E) online analytic processing.

Question 17

Data have a better chance of being available in a conventional file system than in a database.

Accepted Answer

A) True 
 B)False

Question 18

Which is incorrect about reality,data,and metadata?

Accepted Answer

A) Within the realm of reality,there are entities and attributes. 
B) There are record occurrences within the realm of actual data. 
C) Within the realm of metadata,there are record definitions and data item definitions. 
D) There are data item occurrences within the realm of files. 
A) Within the realm of reality,there are entities and attributes. 
B) There are record occurrences within the realm of actual data. 
C) Within the realm of metadata,there are record definitions and data item definitions. 
D) There are data item occurrences within the realm of files.

Question 19

A many-to-many relationship may be implemented using three tables.

Accepted Answer

A) True 
 B)False

Question 20

Table files are used to update master files.

Accepted Answer

A) True 
 B)False

A primary key is one of the data items in a record that uniquely identifies a record.

In relational structures,a file is called a relation,a record is usually referred to as a tuple,and the attribute value set is called a domain.

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

Which of the following is not one of the four anomalies that may occur when creating database tables?

Which is not an effectiveness objective of the database?

An update anomaly occurs when the same data are stored in more than one place in the database.

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key. II) Remove any transitive dependencies. III) All partial dependencies are removed and placed in another relation.

A well-designed ________ can be more flexible than separate files.

Many data items can be packed into a field; the field can be read and converted to a number of data items.

REMOVE is the logical ordering of rows in a relation according to some key.

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

An attribute is some characteristic of a(n):

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

Which is an advantage of the database approach?

A one-to-many relationship may be implemented using a drop-down list.

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Data have a better chance of being available in a conventional file system than in a database.

Which is incorrect about reality,data,and metadata?

A many-to-many relationship may be implemented using three tables.

Table files are used to update master files.

Systems, roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using UML

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters

Exam 13: Designing Databases

A primary key is one of the data items in a record that uniquely identifies a record.

In relational structures,a file is called a relation,a record is usually referred to as a tuple,and the attribute value set is called a domain.

Which type of file contains all the attributes for an entity as well as a primary key and several secondary keys?

Which of the following is not one of the four anomalies that may occur when creating database tables?

Which is not an effectiveness objective of the database?

An update anomaly occurs when the same data are stored in more than one place in the database.

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key. II) Remove any transitive dependencies. III) All partial dependencies are removed and placed in another relation.

A well-designed ________ can be more flexible than separate files.

Many data items can be packed into a field; the field can be read and converted to a number of data items.

REMOVE is the logical ordering of rows in a relation according to some key.

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

An attribute is some characteristic of a(n):

An update anomaly occurs when the entire primary key is not known and the database cannot insert a new record.

Which is an advantage of the database approach?

A one-to-many relationship may be implemented using a drop-down list.

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Data have a better chance of being available in a conventional file system than in a database.

Which is incorrect about reality,data,and metadata?

A many-to-many relationship may be implemented using three tables.

Table files are used to update master files.

Systems, roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using UML

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters