Question 1

In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.

Accepted Answer

A)  cluster 
B)  denormalize 
C)  index 
D)  normalize 
E)  optimize 
A)  cluster 
B)  denormalize 
C)  index 
D)  normalize 
E)  optimize

Question 2

Describe the differences between an ORDBMS and an OODBMS, and list the advantages of using an OODBMS over an OODBMS.

Accepted Answer

The OODBMS leaves the relational model a

Question 3

Explain the difference in the way Structured Query Language processes data compared to traditional programs.

Accepted Answer

The key difference is that traditional p

Question 4

Explain the term Volumetrics.

Accepted Answer

Volumetrics involves estimating the size

Question 5

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.

Accepted Answer

A) True 
 B)False

Question 6

A(n) _____ can support large volumes of data and support applications that run an entire company.

Accepted Answer

A)  database 
B)  database management system 
C)  end-user database administrative system 
D)  end-user database management system 
E)  enterprise database management system 
A)  database 
B)  database management system 
C)  end-user database administrative system 
D)  end-user database management system 
E)  enterprise database management system

Question 7

Lauren and her team have been hired to create a transaction system for Mike's Motorcycles. Mike's is a medium size shop with 10 employees that sells motorcycle parts and does repair on motorcycles, lawn mowers, and other small engine systems (boats, dune buggies, tractors, etc.) As part of Lauren's team, you need to recommend relational database management system.

Accepted Answer

A) True 
 B)False

Question 8

Most object-oriented programming languages support sequential and random access files.

Accepted Answer

A) True 
 B)False

Question 9

A file contains an electronic list of information that is formatted for a particular transaction, and the information is changed and manipulated by programs that are written for those purposes.

Accepted Answer

A) True 
 B)False

Question 10

Explain the object persistence format type known as Relational databases.

Accepted Answer

Relational database management systems (

Question 11

Explain the term clustering.

Accepted Answer

Clustering records together physically s

Question 12

A(n) _____ is basically an electronic list of information that is stored on a disk.

Accepted Answer

A)  sequential access file 
B)  unordered sequential access file 
C)  ordered sequential access file 
D)  random access file 
E)  transaction file 
A)  sequential access file 
B)  unordered sequential access file 
C)  ordered sequential access file 
D)  random access file 
E)  transaction file

Question 13

Explain the object persistence format type known as Object-relational databases.

Accepted Answer

Object-relational database management sy

Question 14

Summarize the first three steps of the normalization process.

Accepted Answer

The first step of normalization involves

Question 15

The Object Relational DBMS has all advantages from both the Relational DBMS and the Object-Oriented DBMS.

Accepted Answer

A) True 
 B)False

Question 16

The two primary dimensions to optimize a relational database are storage efficiency and future needs.

Accepted Answer

A) True 
 B)False

Question 17

Discuss the three situations in which denormalization will reduce joins and improve data access performance.

Accepted Answer

One situation is in the case of look-up

Question 18

Sequential access files are very efficient for operations such as report writing.

Accepted Answer

A) True 
 B)False

Question 19

The leader in the database market and a system that can handle diverse data needs is the relational DBMS.

Accepted Answer

A) True 
 B)False

Question 20

It is likely easier today to find expertise in OODBMS than in RDBMS.

Accepted Answer

A) True 
 B)False

In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.

Describe the differences between an ORDBMS and an OODBMS, and list the advantages of using an OODBMS over an OODBMS.

Explain the difference in the way Structured Query Language processes data compared to traditional programs.

Explain the term Volumetrics.

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.

A(n) _____ can support large volumes of data and support applications that run an entire company.

Most object-oriented programming languages support sequential and random access files.

A file contains an electronic list of information that is formatted for a particular transaction, and the information is changed and manipulated by programs that are written for those purposes.

Explain the object persistence format type known as Relational databases.

Explain the term clustering.

A(n) _____ is basically an electronic list of information that is stored on a disk.

Explain the object persistence format type known as Object-relational databases.

Summarize the first three steps of the normalization process.

The Object Relational DBMS has all advantages from both the Relational DBMS and the Object-Oriented DBMS.

The two primary dimensions to optimize a relational database are storage efficiency and future needs.

Discuss the three situations in which denormalization will reduce joins and improve data access performance.

Sequential access files are very efficient for operations such as report writing.

The leader in the database market and a system that can handle diverse data needs is the relational DBMS.

It is likely easier today to find expertise in OODBMS than in RDBMS.

Introduction to Systems Analysis and Design

Project Management

Requirements Determination

Business Process and Functional Modeling

Structural Modeling

Behavioral Modeling

Moving on to Design

Class and Method Design

Human Computer Interaction Layer Design

Physical Architecture Layer Design

Construction

Installation and Operations

Filters

Exam 9: Data Management Layer Design

In order to reduce the number of joins that must be performed in a query and to increase the speed of data access, the data analyst will _____ the physical model.

Describe the differences between an ORDBMS and an OODBMS, and list the advantages of using an OODBMS over an OODBMS.

Explain the difference in the way Structured Query Language processes data compared to traditional programs.

Explain the term Volumetrics.

Up until recently, an object-oriented database is mainly used to support multimedia applications or complex systems involving graphics, video and sound.

A(n) _____ can support large volumes of data and support applications that run an entire company.

Most object-oriented programming languages support sequential and random access files.

A file contains an electronic list of information that is formatted for a particular transaction, and the information is changed and manipulated by programs that are written for those purposes.

Explain the object persistence format type known as Relational databases.

Explain the term clustering.

A(n) _____ is basically an electronic list of information that is stored on a disk.

Explain the object persistence format type known as Object-relational databases.

Summarize the first three steps of the normalization process.

The Object Relational DBMS has all advantages from both the Relational DBMS and the Object-Oriented DBMS.

The two primary dimensions to optimize a relational database are storage efficiency and future needs.

Discuss the three situations in which denormalization will reduce joins and improve data access performance.

Sequential access files are very efficient for operations such as report writing.

The leader in the database market and a system that can handle diverse data needs is the relational DBMS.

It is likely easier today to find expertise in OODBMS than in RDBMS.

Introduction to Systems Analysis and Design

Project Management

Requirements Determination

Business Process and Functional Modeling

Structural Modeling

Behavioral Modeling

Moving on to Design

Class and Method Design

Human Computer Interaction Layer Design

Physical Architecture Layer Design

Construction

Installation and Operations

Filters