Deck 13: Data Management Concepts

Question 1

The tree database structure corresponds to the data structure supported by COBOL and other widely used programming languages.

Answer 1

True

Question 2

The logical structure of a database is called a schema.

Answer 2

True

Question 3

The entity-relationship data model is perhaps the most promising modeling technique.

Answer 3

False

Question 4

The terms field,data item,attribute,and element are synonyms.

Question 5

Using the direct-access method,congestion results when two or more records yield the same address.

Question 6

It is useful to sort the records in a file so that they are either in ascending or descending order relative to the sort key.

Question 7

Related groups of fields that repeat themselves in variable-length records are called repeated groups.

Question 8

Occurrences are also known as instances.

Question 9

A field would be composed of "customer name" and "customer account number."

Question 10

Nominalization is the process of applying rules to normal forms in relational database structures.

Question 11

Using the direct-access method,the only thing needed to locate a record is its key value.

Question 12

The length of time the user must wait for the system to complete an operation is known as downtime.

Question 13

In the first normal form,repeated groups are allowed.

Question 14

An index file is fully inverted when indexes exist for all of its fields.

Question 15

Network systems are pointer-based systems that allow users to browse through databases in random fashion by selecting keywords or objects.

Question 16

DBMS is a user-friendly computer language or interface that allows the user to request information from the database.

Question 17

Relational databases use relational algebra to create tables.

Question 18

Records are contiguous when they are physically next to each other on a disk.

Question 19

Sequential-access files are often referred to as ISAM files.

Question 20

Variable-length records are easier to manipulate than fixed-length records because the size of the variable-length record is generally smaller than the fixed-length record.

Question 21

SQL is a non-procedural programming language.

Question 22

A petabyte is 10¹⁵ bytes (characters).

Question 23

A database alias can also arise because the same data item is called different things in different programs written in different languages.

Question 24

OLAP is a multidimensional generalization of the 3-dimensional relational table.

Question 25

Individual logical expressions may be combined in a FROM clause with the Boolean operator AND in SQL.

Question 26

Software tools such as Casewise are used to visually represent the E-R models.

Question 27

An advantage of OLAP is its fast response time.

Question 28

A major advantage of DBMS is its ability to construct special database files quickly and efficiently.

Question 29

In SQL,WHERE must be used to determine which records from the tables listed in the FROM clause will appear in the results of the SELECT statement.

Question 30

A data dictionary can only be used with a DBMS.

Question 31

Database software primarily deals with the physical aspects of file use,while accounting application software deals with the logical aspect of file use.

Question 32

A database together with database software is database agnosticity.

Question 33

OLAP uses simple multidimensional "indexes" called aggregations in data mining applications.

Question 34

A database is a structured collection of data stored in a computer system or network.

Question 35

A database management system is independent of the application software therefore permitting upgrading or modifying the eBusiness application without changing data or database software.This is referred to as database agnosticity.

Question 36

The move to object-oriented design is due to the fact that OO databases outperform relational databases in a wide range of common tasks that are typically performed in a business environment.

Question 37

Object-oriented modeling can be easily transformed into OO program code.

Question 38

When a DBA is present and active within an organization,users are almost always willing to give up their responsibility for data elements.

Question 39

Database drivers,NOT database connectors,can be used to connect the business application to the DBMS.

Question 40

In some respects,the word "file" loses its meaning in a database environment.

Question 41

The computer language that allows a DBA to define the logical structure of the database is called ________.

Question 42

The smallest block of data that can be stored and retrieved in an information system is a(n)________.

Question 43

________ are one of the fundamental building blocks used to construct databases.

Question 44

A software database ________,also called a database connector,can be used to connect the business application to the DBMS.

Question 45

In-memory database differs from conventional databases in that the entire database is loaded into computer-internal high-speed random access memory or other high-speed electronic storage device.

Question 46

OLAP is a multidimensional generalization of the 2-dimensional ________ table.

Question 47

________ refers to the physical form that data will be stored in,such as BCD or EBCDIC.

Question 48

ACID is used to prevent database fraud.

Question 49

A database ________ is a collection of all data item names in a database,along with a description of the standardized representation form of the data items.

Question 50

Database ________ permits upgrading or modifying the eBusiness application without changing data or database software.

Question 51

In the E-R conceptual model,the term ________ is used instead of segment,and the term ________ is used to refer to individual fields or data items.

Question 52

A file that allows an individual to almost instantaneously retrieve records without the use of an index is a(n)________-access file.

Question 53

An invaluable benefit of DBMSs is their ability to provide ________ for databases.

Question 54

When the entire database is loaded into computer-internal high-speed random access memory or other high speed electronic storage device,it is called ________ database.

Question 55

A row in a relational database table is called a(n)________.

Question 56

The term ________ ________ order applies to a field on which the file is not sorted.

Question 57

________ fields cross-link segments in tree and network database structures.

Question 58

The first word usually found in an SQL statement intended to extract data from a database is ________.

Question 59

One primary objective of a data dictionary is to eliminate data ________ to the extent feasible.

Question 60

In an ISAM file organization,the portion of the disk on which the actual records are written is the ________ area.

Question 61

An analyst has identified a certain database as "indexed-sequential." This is an example of defining database architecture at the

A) physical level.
B) conceptual level.
C) logical level.
D) relational level.

Question 62

Variable-length records have characteristics that are not found in fixed-length records.An example of such a characteristic is

A) the field width can be adjusted for each data occurrence.
B) because of their size, most records stored on DASD are variable-length records.
C) the actual number of fields can vary from one data occurrence to another.
D) the field width can be adjusted for each data occurrence and the actual number of fields can vary from one data occurrence to another.

Question 63

A database has a hierarchical data structure.This is an example of defining database architecture at the

A) physical level.
B) conceptual level.
C) sequential level.
D) logical level.

Question 64

Fields associated with other fields in a logical grouping are known as

A) elements.
B) records.
C) data items.
D) attributes.

Question 65

To process and locate records in files,it is necessary to use a(n)

A) attribute.
B) key or record key.
C) parent.
D) element.

Question 66

A data item or combination of data items that uniquely identify a particular record in a file is called a(n)

A) key.
B) occurrence.
C) attribute.
D) variable-length field.

Question 67

The "A" in ACID stands for ________.

Question 68

In the CUSTOMER record,the field NAME contains the word "Jones" along with 20 spaces after the last character.This is an example of a

A) variable-length record.
B) data item.
C) fixed-length record.
D) trailer.

Question 69

In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2)
Which field is the parent?

A) STORE
B) CITY
C) VEND
D) STORE_NO

Question 70

In the object-oriented modeling technique,related groups of fields are known as

A) objects.
B) parents.
C) children.
D) object classes.

Question 71

In an entity-relationship data model,the concepts of part number,type,and cost are known as

A) entities.
B) attributes.
C) relations.
D) objects.

Question 72

Four records have the record structure: PART (PART_NO,WARHSE). PART (101,1)
PART (101,2)
PART (103,1)
PART (106,1)
Which of the following would be appropriate to use as a record key?

A) PART
B) PART_NO
C) WARHSE
D) Answers B and C combined would form a record key.

Question 73

In data management terminology,a record occurrence is a

A) secondary sort key.
B) trailer record containing additional data.
C) method of specifying variable-length records.
D) specific example of a record structure.

Question 74

Four records have the record structure: EQUIPMENT (EQUIP#,LOCATION). EQUIPMENT (204,1)
EQUIPMENT (204,2)
EQUIPMENT (208,1)
EQUIPMENT (209,1)
When sorting these records,which field is the primary sort key and which field is the secondary sort key?

A) EQUIPMENT is primary; no secondary sort key is required.
B) EQUIP# is primary; no secondary sort key is required.
C) EQUIP# is primary; LOCATION is the secondary key.
D) LOCATION is primary; EQUIP# is the secondary key.

Question 75

In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2)
Which field is the key?

A) STORE
B) STORE_NO
C) VEND
D) CITY

Question 76

In the record format STORE (STORE_NO,CITY,VEND#1,VEND#2)
Which field is repeated?

A) STORE
B) CITY
C) VEND
D) STORE_NO

Question 77

A trailer record is an extension of a(n)

A) master record.
B) attribute.
C) segment.
D) transaction record.

Question 78

________ in ACID means a transaction is not undone if the system fails after it is completed.

Question 79

The difference between segments and simple records is that

A) simple records have parents and children.
B) segment are collections of fields.
C) segments have parents and children.
D) segments have no fields.

Question 80

A database is defined in terms of the kind of information it includes and the purposes for which it is to be used.This is an example of defining database architecture at the

A) logical level.
B) conceptual level.
C) physical level.
D) relational level.