Question 1

___________________ is a language, which supports complete database creation, maintenance and usage, and is the DDL and DML of most relational databases.

Accepted Answer

The answer of ___________________ is a language, which supports complete...

Question 2

Most organizations build several databases, each one sharing data with several information systems. Thus, there will be some redundancy between databases.

Accepted Answer

A) True 
 B)False

Question 3

The EmployeeID field in an employee table cannot be left blank. This is an example of:

Accepted Answer

A)  key integrity 
B)  domain integrity 
C)  referential integrity 
D)  logical integrity 
E)  schema integrity 
A)  key integrity 
B)  domain integrity 
C)  referential integrity 
D)  logical integrity 
E)  schema integrity

Question 4

Specialized computer software that is used to create, access, control, and manage the database is called:

Accepted Answer

A)  network system 
B)  database management system 
C)  operating system 
D)  network operating system 
E)  none of these 
A)  network system 
B)  database management system 
C)  operating system 
D)  network operating system 
E)  none of these

Question 5

An employee and a customer file are both examples of which type of file?

Accepted Answer

A)  master 
B)  transaction 
C)  scratch 
D)  table 
E)  archive 
A)  master 
B)  transaction 
C)  scratch 
D)  table 
E)  archive

Question 6

Record structures that allow different records in the same file to have different lengths is known as:

Accepted Answer

A)  a fixed length record structure 
B)  a standard deviation record structure 
C)  a variance record structure 
D)  a variable length record structure 
E)  none of these 
A)  a fixed length record structure 
B)  a standard deviation record structure 
C)  a variance record structure 
D)  a variable length record structure 
E)  none of these

Question 7

Which of the following is NOT a step of database capacity planning?

Accepted Answer

A)  Calculate the record size by summing the field sizes in each table. 
B)  Calculate the table size by multiplying the record size times the number of records. 
C)  Sum the table sizes. 
D)  Optionally, add a slack capacity buffer. 
E)  none of these 
A)  Calculate the record size by summing the field sizes in each table. 
B)  Calculate the table size by multiplying the record size times the number of records. 
C)  Sum the table sizes. 
D)  Optionally, add a slack capacity buffer. 
E)  none of these

Question 8

Database technology provides superior ____________________, meaning that the database and the systems that use it can be grown or expanded to meet the changing needs of an organization.

Accepted Answer

The answer of Database technology provides superior ____________________, meaning that...

Question 9

A(n) ______________________ is the set of all occurrences of a given record structure. In database systems, it is frequently called a table.

Accepted Answer

The answer of A(n) ______________________ is the set of all...

Question 10

The alternate name for a foreign key that clearly distinguishes the purpose that foreign key serves in the table is known as:

Accepted Answer

A)  role name 
B)  attribute name 
C)  service pointer 
D)  domain name 
E)  none of these 
A)  role name 
B)  attribute name 
C)  service pointer 
D)  domain name 
E)  none of these

Question 11

A(n) ______________________________________________________ is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

Accepted Answer

database m

Question 12

Database architecture refers to the database technology including the database engine, database utilities, database CASE tools for analysis and design, and database application development tools.

Accepted Answer

A) True 
 B)False

Question 13

During the creation of database schemas, _________________________ means the field does not have to have a value; whereas,  ___________________ means the field must have a value.

Accepted Answer

The answer of During the creation of database schemas, _________________________...

Question 14

Contemporary data architecture allows for Internet-enabled database technology.

Accepted Answer

A) True 
 B)False

Question 15

Every nonkey field is called a(n):

Accepted Answer

A)  secondary key 
B)  foreign key 
C)  descriptive field 
D)  record 
E)  none of these 
A)  secondary key 
B)  foreign key 
C)  descriptive field 
D)  record 
E)  none of these

Question 16

Pointers to the records of a different file in a database, they are used to link records of one type to those of another type:

Accepted Answer

A)  attributes 
B)  referential pointers 
C)  descriptive fields 
D)  foreign keys 
E)  none of these 
A)  attributes 
B)  referential pointers 
C)  descriptive fields 
D)  foreign keys 
E)  none of these

Question 17

Centralization is the simplest and easiest solution to maintain.

Accepted Answer

A) True 
 B)False

Question 18

___________________________ is the term used to describe the use of query tools and decision support tools used to generate reports and analyses off of data warehouses.

Accepted Answer

The answer of ___________________________ is the term used to describe...

Question 19

Database technology provides better technology for client/server and network computing architectures.

Accepted Answer

A) True 
 B)False

Question 20

A collection of fields arranged in a predefined format is known as a(n):

Accepted Answer

A)  attribute 
B)  file 
C)  concatenated key 
D)  record 
E)  none of these 
A)  attribute 
B)  file 
C)  concatenated key 
D)  record 
E)  none of these

___________________ is a language, which supports complete database creation, maintenance and usage, and is the DDL and DML of most relational databases.

Most organizations build several databases, each one sharing data with several information systems. Thus, there will be some redundancy between databases.

The EmployeeID field in an employee table cannot be left blank. This is an example of:

Specialized computer software that is used to create, access, control, and manage the database is called:

An employee and a customer file are both examples of which type of file?

Record structures that allow different records in the same file to have different lengths is known as:

Which of the following is NOT a step of database capacity planning?

Database technology provides superior ____________________, meaning that the database and the systems that use it can be grown or expanded to meet the changing needs of an organization.

A(n) ______________________ is the set of all occurrences of a given record structure. In database systems, it is frequently called a table.

The alternate name for a foreign key that clearly distinguishes the purpose that foreign key serves in the table is known as:

A(n) ______________________________________________________ is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

Database architecture refers to the database technology including the database engine, database utilities, database CASE tools for analysis and design, and database application development tools.

During the creation of database schemas, _______ means the field does not have to have a value; whereas, _ means the field must have a value.

Contemporary data architecture allows for Internet-enabled database technology.

Every nonkey field is called a(n):

Pointers to the records of a different file in a database, they are used to link records of one type to those of another type:

Centralization is the simplest and easiest solution to maintain.

___________________________ is the term used to describe the use of query tools and decision support tools used to generate reports and analyses off of data warehouses.

Database technology provides better technology for client/server and network computing architectures.

A collection of fields arranged in a predefined format is known as a(n):

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Data Modeling and Analysis

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters

Exam 14: Database Design

___________________ is a language, which supports complete database creation, maintenance and usage, and is the DDL and DML of most relational databases.

Most organizations build several databases, each one sharing data with several information systems. Thus, there will be some redundancy between databases.

The EmployeeID field in an employee table cannot be left blank. This is an example of:

Specialized computer software that is used to create, access, control, and manage the database is called:

An employee and a customer file are both examples of which type of file?

Record structures that allow different records in the same file to have different lengths is known as:

Which of the following is NOT a step of database capacity planning?

Database technology provides superior ____________________, meaning that the database and the systems that use it can be grown or expanded to meet the changing needs of an organization.

A(n) ______________________ is the set of all occurrences of a given record structure. In database systems, it is frequently called a table.

The alternate name for a foreign key that clearly distinguishes the purpose that foreign key serves in the table is known as:

A(n) ______________________________________________________ is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

Database architecture refers to the database technology including the database engine, database utilities, database CASE tools for analysis and design, and database application development tools.

During the creation of database schemas, _________________________ means the field does not have to have a value; whereas, ___________________ means the field must have a value.

Contemporary data architecture allows for Internet-enabled database technology.

Every nonkey field is called a(n):

Pointers to the records of a different file in a database, they are used to link records of one type to those of another type:

Centralization is the simplest and easiest solution to maintain.

___________________________ is the term used to describe the use of query tools and decision support tools used to generate reports and analyses off of data warehouses.

Database technology provides better technology for client/server and network computing architectures.

A collection of fields arranged in a predefined format is known as a(n):

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Data Modeling and Analysis

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters

During the creation of database schemas, _______ means the field does not have to have a value; whereas, _ means the field must have a value.