Question 1

In this subsystem,a user can create data entry forms.

Accepted Answer

A)  data administration
B)  DBMS engine
C)  data definition
D)  application generationE) B) and D)
F) B) and C)

Question 2

Individual databases are the foundation of management information systems.

Accepted Answer

A) True 
 B)False

Question 3

A(n) ________ is a collection of related records.

Accepted Answer

A)  entity
B)  field
C)  table
D)  attributeE) A) and B)
F) C) and D)

Question 4

In ________,data is processed at the same time the transaction occurs.

Accepted Answer

A)  batch processing
B)  group processing
C)  real-time processing
D)  consignment processingE) B) and D)
F) B) and C)

Question 5

A network database utilizes these special connections between parent nodes and child nodes that allow multiple paths between records.

Accepted Answer

A)  connectors
B)  links
C)  strings
D)  pointersE) All of the above
F) C) and D)

Question 6

Explain the components of data organization.

Accepted Answer

Data organization involves structuring a...

Question 7

The analysis tools associated with the ________ subsystem include query-by-example and structured query languages (SQL) .

Accepted Answer

A)  application generation
B)  data manipulation
C)  attribute analysis
D)  data administrationE) All of the above
F) A) and B)

Question 8

A hierarchical database uses many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 9

Which view of data deals with how the data is actually formatted and located?

Accepted Answer

A)  physical view
B)  logical view
C)  information view
D)  technical viewE) None of the above
F) All of the above

Question 10

In a(n) ________ database,not all the data in a database is physically located in one place.

Accepted Answer

A)  distributed
B)  commercial
C)  individual
D)  companyE) All of the above
F) C) and D)

Question 11

Querying the database and generating reports is assisted by the application generation subsystem.

Accepted Answer

A) True 
 B)False

Question 12

A(n) ________ represents a collection of attributes that describe an entity.

Accepted Answer

A)  record
B)  character
C)  attribute
D)  entityE) B) and D)
F) A) and B)

Question 13

In this database model,the fields or records are structured in nodes.

Accepted Answer

A)  relational
B)  hierarchical
C)  multidimensional
D)  object-orientedE) A) and B)
F) B) and D)

Question 14

In a network database,a node can be traced down through different branches.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ________ database is a collection of integrated files primarily used by just one person.

Accepted Answer

A)  company
B)  distributed
C)  commercial
D)  individualE) All of the above
F) A) and B)

Question 16

List and describe the five basic DBMS subsystems.

Accepted Answer

A Database Management System (DBMS) is a...

Question 17

Describe the workings of an object-oriented database.

Accepted Answer

Object-oriented databases (OODB) are des...

Question 18

Data redundancy can occur due to lack of data integrity.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is an advantage of using multidimensional databases?

Accepted Answer

A)  smaller hard disk usage
B)  network ability
C)  simpler relationships
D)  conceptualizationE) A) and D)
F) A) and C)

Question 20

A field that uniquely identifies each record.

Accepted Answer

A)  ID
B)  primary key
C)  common
D)  numericE) B) and D)
F) None of the above

Exam 11: Databases

A network database utilizes these special connections between parent nodes and child nodes that allow multiple paths between records.

Correct AnswerverifiedShow Answer

In this subsystem,a user can create data entry forms.

Correct AnswerverifiedShow Answer

Explain the components of data organization.

Correct AnswerAnswered by ExamLex AIData organization involves structuring a...View AnswerShow Answer

In ________,data is processed at the same time the transaction occurs.

Correct AnswerverifiedShow Answer

In a network database,a node can be traced down through different branches.

Correct AnswerverifiedShow Answer

A(n) ________ is a collection of related records.

Correct AnswerverifiedShow Answer

A hierarchical database uses many-to-many relationships.

Correct AnswerverifiedShow Answer

List and describe the five basic DBMS subsystems.

Correct AnswerAnswered by ExamLex AIA Database Management System (DBMS) is a...View AnswerShow Answer

Describe the workings of an object-oriented database.

Correct AnswerAnswered by ExamLex AIObject-oriented databases (OODB) are des...View AnswerShow Answer

Data redundancy can occur due to lack of data integrity.

Correct AnswerverifiedShow Answer

In this database model,the fields or records are structured in nodes.

Correct AnswerverifiedShow Answer

A(n) ________ represents a collection of attributes that describe an entity.

Correct AnswerverifiedShow Answer

Which of the following is an advantage of using multidimensional databases?

Correct AnswerverifiedShow Answer

Which view of data deals with how the data is actually formatted and located?

Correct AnswerverifiedShow Answer

Querying the database and generating reports is assisted by the application generation subsystem.

Correct AnswerverifiedShow Answer

In a(n) ________ database,not all the data in a database is physically located in one place.

Correct AnswerverifiedShow Answer

A(n) ________ database is a collection of integrated files primarily used by just one person.

Correct AnswerverifiedShow Answer

The analysis tools associated with the ________ subsystem include query-by-example and structured query languages (SQL) .

Correct AnswerverifiedShow Answer

A field that uniquely identifies each record.

Correct AnswerverifiedShow Answer

Individual databases are the foundation of management information systems.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
Answered by ExamLex AI
Data organization involves structuring a...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
Answered by ExamLex AI
A Database Management System (DBMS) is a...
View Answer

Correct Answer
Answered by ExamLex AI
Object-oriented databases (OODB) are des...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified