Question 1

Which is not an enterprise DBMS?

Accepted Answer

A) Microsoft Access 
B) SQL Server 
C) Oracle 
D) DB2 
E) Jasmine 
A) Microsoft Access 
B) SQL Server 
C) Oracle 
D) DB2 
E) Jasmine A

Question 2

Applications are of little use without the data that they support.

Accepted Answer

A) True 
 B)False  True

Question 3

Data is generally stored in one of two different formats: as files or as databases.

Accepted Answer

A) True 
 B)False  True

Question 4

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

Question 5

CRUD stands for 'create','read','update' and 'delete'.

Accepted Answer

A) True 
 B)False

Question 6

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zipcode,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

Accepted Answer

A) Multidimensional 
B) Hierarchical 
C) Legacy 
D) Object 
E) Relational 
A) Multidimensional 
B) Hierarchical 
C) Legacy 
D) Object 
E) Relational

Question 7

MySQL is a popular database management system made by Microsoft.

Accepted Answer

A) True 
 B)False

Question 8

What is the best way to optimize storage efficiency in a relational database?

Accepted Answer

The best way to optimize stora

Question 9

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 10

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

Accepted Answer

A) True 
 B)False

Question 11

Data storage components are designed and developed by the programming staff in the Implementation phase of the SDLC.

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

What is the best ways to optimize access speed in relational databases?

Accepted Answer

The best ways to optimize acce

Question 15

Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').

Accepted Answer

A) True 
 B)False

Question 16

The concept of putting records that are somehow related together on the same server (or storage device)is called:

Accepted Answer

A) Carmelization 
B) Clustering 
C) Joining 
D) Normalization 
E) Hybrid technologies 
A) Carmelization 
B) Clustering 
C) Joining 
D) Normalization 
E) Hybrid technologies

Question 17

When changing logical data models to physical data models,you will want to change entities to tables or files.

Accepted Answer

A) True 
 B)False

Question 18

Which is NOT a step in moving from a logical data model to a physical data model?

Accepted Answer

A) Change entities to tables (or files) 
B) Change data flows to create / read / update / delete (CRU
D) operations 
C) Change Attributes to Fields 
D) Add primary keys 
E) Add foreign keys 
A) Change entities to tables (or files) 
B) Change data flows to create / read / update / delete (CRU
D) operations 
C) Change Attributes to Fields 
D) Add primary keys 
E) Add foreign keys

Question 19

Data warehousing is the practice of taking data from a company's transaction processing systems,transforming the data and storing the data for use in decision support systems.

Accepted Answer

A) True 
 B)False

Question 20

Which is not an element of a CRUD matrix?

Accepted Answer

A) Combine or join 
B) Update or refresh 
C) Erase or delete 
D) Read or retrieve 
E) Make or create 
A) Combine or join 
B) Update or refresh 
C) Erase or delete 
D) Read or retrieve 
E) Make or create

Which is not an enterprise DBMS?

Applications are of little use without the data that they support.

Data is generally stored in one of two different formats: as files or as databases.

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.

CRUD stands for 'create','read','update' and 'delete'.

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zipcode,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

MySQL is a popular database management system made by Microsoft.

What is the best way to optimize storage efficiency in a relational database?

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.

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

Data storage components are designed and developed by the programming staff in the Implementation phase of the SDLC.

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

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

What is the best ways to optimize access speed in relational databases?

Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').

The concept of putting records that are somehow related together on the same server (or storage device)is called:

When changing logical data models to physical data models,you will want to change entities to tables or files.

Which is NOT a step in moving from a logical data model to a physical data model?

Data warehousing is the practice of taking data from a company's transaction processing systems,transforming the data and storing the data for use in decision support systems.

Which is not an element of a CRUD matrix?

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Data Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters

Exam 11: Data Storage Design

Which is not an enterprise DBMS?

Applications are of little use without the data that they support.

Data is generally stored in one of two different formats: as files or as databases.

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.

CRUD stands for 'create','read','update' and 'delete'.

Omar is creating an order database for a multiple site car dealership.The data will be fairly simple: names,addresses,city,state,zipcode,make of car,model,style,color,etc.Probably the best choice for him would be a _____________ database.

MySQL is a popular database management system made by Microsoft.

What is the best way to optimize storage efficiency in a relational database?

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.

The standard method language for accessing the data in relational database tables is: SQL - Standard Query Logic.

Data storage components are designed and developed by the programming staff in the Implementation phase of the SDLC.

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

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

What is the best ways to optimize access speed in relational databases?

Decision support systems are not designed to find individual records,but to find aggregated information (such as 'what three products sold the best in Boston in February').

The concept of putting records that are somehow related together on the same server (or storage device)is called:

When changing logical data models to physical data models,you will want to change entities to tables or files.

Which is NOT a step in moving from a logical data model to a physical data model?

Data warehousing is the practice of taking data from a company's transaction processing systems,transforming the data and storing the data for use in decision support systems.

Which is not an element of a CRUD matrix?

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Data Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters