Question 1

Keys may include:

Accepted Answer

A) primary keys. 
B) unique secondary keys. 
C) nonunique secondary keys. 
D) B and C 
E) A,B and C 
A) primary keys. 
B) unique secondary keys. 
C) nonunique secondary keys. 
D) B and C 
E) A,B and C E

Question 2

A multilevel index that allows both sequential and direct processing of data records is called a C-tree.

Accepted Answer

A) True 
 B)False  False

Question 3

A simple network is a collection of records and the 1:N relationships between them.

Accepted Answer

A) True 
 B)False  True

Question 4

A ________ is a file that has no repeating groups.

Accepted Answer

A) flat file 
B) stacked file 
C) record file 
D) key file 
E) secondary file 
A) flat file 
B) stacked file 
C) record file 
D) key file 
E) secondary file

Question 5

A tree structure cannot be represented using indexes.

Accepted Answer

A) True 
 B)False

Question 6

A collection of records and the 1:N relationships between them is a:

Accepted Answer

A) simple network. 
B) complex network. 
C) compound network. 
D) logical network. 
E) sequential network. 
A) simple network. 
B) complex network. 
C) compound network. 
D) logical network. 
E) sequential network.

Question 7

A two-way linked list has links in both directions.

Accepted Answer

A) True 
 B)False

Question 8

A collection of records and the N:M relationships between them is a:

Accepted Answer

A) simple network. 
B) complex network. 
C) compound network. 
D) logical network. 
E) sequential network. 
A) simple network. 
B) complex network. 
C) compound network. 
D) logical network. 
E) sequential network.

Question 9

A simple network can be represented using linked lists and indexes.

Accepted Answer

A) True 
 B)False

Question 10

Complex networks can be represented by reducing them to simple networks,which requires the introduction of a(n):

Accepted Answer

A) association record. 
B) link record. 
C) intersection record. 
D) sequential record. 
E) index record. 
A) association record. 
B) link record. 
C) intersection record. 
D) sequential record. 
E) index record.

Question 11

The term set refers to all records that have the same:

Accepted Answer

A) primary key. 
B) unique secondary key. 
C) nonunique secondary key. 
D) B and C 
E) A,B and C 
A) primary key. 
B) unique secondary key. 
C) nonunique secondary key. 
D) B and C 
E) A,B and C

Question 12

DBMS products represent trees using:

Accepted Answer

A) indexes. 
B) linked lists. 
C) sequential lists. 
D) A and B 
E) A,B and C 
A) indexes. 
B) linked lists. 
C) sequential lists. 
D) A and B 
E) A,B and C

Question 13

Linked lists can be used to keep records in:

Accepted Answer

A) logical order. 
B) physical order. 
C) sequential order. 
D) A and B 
E) B and C 
A) logical order. 
B) physical order. 
C) sequential order. 
D) A and B 
E) B and C

Question 14

A flat file is a file that has repeating groups.

Accepted Answer

A) True 
 B)False

Question 15

What is a linked list?

Accepted Answer

A linked list is a logical tool used to

Question 16

Linked lists can be used to keep records in a logical order even if they are not necessarily in physical order.

Accepted Answer

A) True 
 B)False

Question 17

What is a B-tree?

Accepted Answer

A B-tree is a multilevel index that allo

Question 18

How does a DBMS store data on its direct access files?

Accepted Answer

Usually the DBMS creates large

Question 19

The word key indicates a field or fields whose value uniquely or nonuniquely identifies a record.

Accepted Answer

A) True 
 B)False

Question 20

Complex networks can be represented by reducing them to simple networks,and then to represent the simple networks using:

Accepted Answer

A) indexes. 
B) linked lists. 
C) sequential lists. 
D) A and B 
E) A,B and C 
A) indexes. 
B) linked lists. 
C) sequential lists. 
D) A and B 
E) A,B and C

Exam 23: Data Structures for Database Processing

Keys may include:

A multilevel index that allows both sequential and direct processing of data records is called a C-tree.

A simple network is a collection of records and the 1:N relationships between them.

A ________ is a file that has no repeating groups.

A tree structure cannot be represented using indexes.

A collection of records and the 1:N relationships between them is a:

A two-way linked list has links in both directions.

A collection of records and the N:M relationships between them is a:

A simple network can be represented using linked lists and indexes.

Complex networks can be represented by reducing them to simple networks,which requires the introduction of a(n):

The term set refers to all records that have the same:

DBMS products represent trees using:

Linked lists can be used to keep records in:

A flat file is a file that has repeating groups.

What is a linked list?

Linked lists can be used to keep records in a logical order even if they are not necessarily in physical order.

What is a B-tree?

How does a DBMS store data on its direct access files?

The word key indicates a field or fields whose value uniquely or nonuniquely identifies a record.

Complex networks can be represented by reducing them to simple networks,and then to represent the simple networks using:

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

SQL for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

Managing Databases With SQL Server 2008 R2

Managing Databases With Oracle Database 11g

Managing Databases With MySQL 55

The Web Server Environment

Database Processing With XML

Database Processing for Business Intelligence Systems

Microsoft Access 2010

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2010

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Filters