Question: Legacy databases might include ________ and ________.

Answer Options:

Master files and transaction files
Audit files and lock-up files
Hierarchical databases and network databases
NoSQL databases
ERDs and data dictionaries

Answer: Hierarchical databases and network databases

 

Question: Most relational database systems support:

Answer Options:

Referential integrity
Pop-up menus
Customizable user-interface colors and graphics
The “three-click” rule
Broadband connectivity

Answer: Referential integrity

 

Question: New databases collectively referred to as NoSQL databases have appeared in recent years. Which of the following are NOT categorized as a NoSQL database?

Answer Options:

Document-oriented database
Wide column stores
Graph databases
Extensible record stores
Relational Database system

Answer: Relational Database system

 

Question: The acronym for the standard language used to access data in relational databases is:

Answer Options:

ERD
CRM
ERP
BPR
SQL

Answer: SQL

 

Question: The most popular type of database today is the:

Answer Options:

Hierarchical database
Tree database
Green database
Relational database
Piecemeal database

Answer: Relational database

 

Question: The two basic formats for data storage:

Answer Options:

Spreadsheets and documents
Files and databases
Databases and presentations
Flash and web forms
ERDs and Use cases

Answer: Files and databases

 

Question: This type of file is used to update a master file:

Answer Options:

Roster files
Training files
Master files
Transaction files
Integrated files

Answer: Transaction files

 

Question: This type of file records “before” and “after” images of data as the data gets altered.

Answer Options:

Intelligent files
Audit files

Answer: Audit files

 

Question: When designing navigational controls, which is NOT commonly assumed?

Answer Options:

That users have not read the manual
That users have not attended training
That users do not have help readily at hand
That users have knowledge of the system and the interface
That users have not read the documentation

Answer: That users have knowledge of the system and the interface

 

Question: The first principle of designing navigation controls is __________.

Answer Options:

It was tough to build, it should be tough to use
Users have attended training
To prevent users from making mistakes
See that all screens can be reached in the four-click rule
Build appropriate icons (like a blank page for new document or form)

Answer: To prevent users from making mistakes

 

Question: It is better to make menus _______.

Answer Options:

Broad and shallow
Narrow and deep
Broad and deep
Narrow and shallow
Wide and tall

Answer: Broad and shallow

 

Question: A __________ is used when several fields must be entered before the form can be processed.

Answer Options:

Completeness check
Format check
Range check
Check digit check
Consistency check

Answer: Completeness check

 

Question: A __________ is used when fields are numeric or contain coded data.

Answer Options:

Completeness check
Format check
Range check
Check digit check
Consistency check

Answer: Format check

 

Question: A __________ is used when you want to verify that data fits within correct minimum and maximum values.

Answer Options:

Completeness check
Format check
Range check
Check digit check
Consistency check

Answer: Range check

 

Question: In most automated cases, data stores from logical DFDs will be converted to ________.

Answer Options:

Binary tables
CD Rom disks
Paper files
Into database files/tables
Encrypted hexadecimal values

Answer: Into database files/tables

 

Question: By definition, external entities on the DFD:

Answer Options:

Are used as the starting point for the physical data flow diagram
Are outside the scope of the system
Will be the top of the structure chart
Will become database table entries
Are updated with metadata to become part of the physical DFD

Answer: Are outside the scope of the system

 

Question: Processes from logical DFDs might show up on a physical data flow diagram as:

Answer Options:

Tables in a database
External entities
Outside the human-machine boundary

Answer: Tables in a database

 

Question: A client-server application that requires nothing more than a browser is called a(n) ________.

Answer Options:

Native application
Website
Thick-client application
Thin-client application

Answer: Thin-client application