Question 1

One process when considering data storage design is to move from physical data models to logical data models.

Accepted Answer

A) True 
 B)False

Question 2

When moving from logical data models to physical data models,you should update your CRUD matrix.

Accepted Answer

A) True 
 B)False

Question 3

Jasmine is an example of an object-oriented database system.

Accepted Answer

A) True 
 B)False

Question 4

The most popular type of database today is the:

Accepted Answer

A) Hierarchical database 
B) Tree database 
C) Green database 
D) Relational database 
E) Piecemeal database 
A) Hierarchical database 
B) Tree database 
C) Green database 
D) Relational database 
E) Piecemeal database

Question 5

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

Accepted Answer

A) True 
 B)False

Question 6

The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.

Accepted Answer

A) True 
 B)False

Question 7

Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.

Accepted Answer

A) True 
 B)False

Question 8

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

Accepted Answer

A) True 
 B)False

Question 9

When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.

Accepted Answer

A) True 
 B)False

Question 10

Systems to support decision making generally need to update data frequently with a large volume of data.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is not a RDBMS?

Accepted Answer

A) Oracle 
B) NoSQL 
C) SQL 
D) MySQL 
E) None of these 
A) Oracle 
B) NoSQL 
C) SQL 
D) MySQL 
E) None of these

Question 12

Informix is a pure OODBMS package.

Accepted Answer

A) True 
 B)False

Question 13

Systems that support decision making will probably:

Accepted Answer

A) Do a lot of updating of data 
B) Be transaction processing systems 
C) Be audit files 
D) Use Gantt charts 
E) Usually just read data - and often in ad hoc ways 
A) Do a lot of updating of data 
B) Be transaction processing systems 
C) Be audit files 
D) Use Gantt charts 
E) Usually just read data - and often in ad hoc ways

Question 14

Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.

Accepted Answer

A) True 
 B)False

One process when considering data storage design is to move from physical data models to logical data models.

When moving from logical data models to physical data models,you should update your CRUD matrix.

Jasmine is an example of an object-oriented database system.

The most popular type of database today is the:

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.

Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.

Systems to support decision making generally need to update data frequently with a large volume of data.

Which of the following is not a RDBMS?

Informix is a pure OODBMS package.

Systems that support decision making will probably:

Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Use Case Analysis

Process Modeling

Data Modeling

Moving Into Design

Rchitecture Design

User Interface Design

Program Design

Moving Into Implementation

Transition to the New System

The Movement to Objects

Filters

Exam 11: Data Storage Design

One process when considering data storage design is to move from physical data models to logical data models.

When moving from logical data models to physical data models,you should update your CRUD matrix.

Jasmine is an example of an object-oriented database system.

The most popular type of database today is the:

When working on a major project,project teams will always select and stay with only one database format for consistency of development and use.

The two primary ways to optimize a relational database are (a)for storage efficiency and (b)for using the smallest amount of space.

Sanjay is creating a screen form that interfaces with a relational database.He should use the median (middle)value in the database as his default value - as that will make it easier for the users to move up and down in the table.

When changing from logical data models to physical data models,you will want to change the attributes of the logical ERD to fields in the physical ERD.

When converting a logical ERD into a physical data model,you will want to specify both primary keys and international keys.

Systems to support decision making generally need to update data frequently with a large volume of data.

Which of the following is not a RDBMS?

Informix is a pure OODBMS package.

Systems that support decision making will probably:

Although TJ did a lot of work normalizing the database so that it is in third normal form (3NF),he may want to 'denormalize' it so that access might be faster.

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Use Case Analysis

Process Modeling

Data Modeling

Moving Into Design

Rchitecture Design

User Interface Design

Program Design

Moving Into Implementation

Transition to the New System

The Movement to Objects

Filters