Question: Smart devices will increasingly need __________. (select all that apply)

Answer Options:

new protocols
higher bandwidth
less cache
less memory

Answer: higher bandwidth

 

Question: Bits are used for computer data because they __________.

Answer Options:

are represented exclusively as alphabets
can have three possible states at a time
are easy to represent physically
are more complex than bytes

Answer: are easy to represent physically

 

Question: Main memory is also known as __________.

Answer Options:

optical memory
read-only memory
cache memory
random access memory

Answer: random access memory

 

Question: Which of the following is an example of SaaS?

Answer Options:

iCloud
Oracle on Demand
Amazon S3
Microsoft Windows Azure

Answer: iCloud

 

Question: Which of the following refers to the three tiers in the three-tier architecture?

Answer Options:

TCP, IP, and HTTP
tunnel, switch, and access point
HTML, XML, and JSON
user, server, and database

Answer: user, server, and database

 

Question: Identify the closed-source DBMS product(s) among the following. (Select all that apply)

Answer Options:

DB2
MySQL
Access
Oracle Database

Answer: DB2 Oracle Database

 

Question: The characteristics of an entity are referred to as _______.

Answer Options:

attributes
relationships
primary key(s)
foreign key(s)

Answer: attributes

 

Question: Which of the following is a NoSQL (i.e., not-relational) DBMS? (select all that apply)

Answer Options:

Access
SharePoint
Dynamo
Cassandra

Answer: Dynamo Cassandra

 

Question: A data integrity problem will occur only if __________.

Answer Options:

the database is very large
queries are sent simultaneously to the database
a database has multiple administrators
data are duplicated in a database

Answer: data are duplicated in a database

 

Question: An employee database includes a column named “Employee Number” to assign unique numbers to each employee. This column is referred to as a(n) __________.

Answer Options:

functionally dependent key
primary key
foreign key
master key

Answer: primary key

 

Question: In an E-R diagram, which symbol is used to indicate that at least one entity of that type is required?

Answer Options:

arrow
small oval
triangular block
vertical bar

Answer: vertical bar

 

Question: Which of the following is an international standard language for processing a database?

Answer Options:

JavaScript
SQL
DBScript
HTML

Answer: SQL

 

Question: Which of the following refers to the problem that exists in database applications when two users modify the same data item, but only one of those changes is recorded?

Answer Options:

bullwhip effect
data administrator’s dilemma
lost-update problem
normalization problem

Answer: lost-update problem

 

Question: Before developing a database design, an administrator should create a _________.

Answer Options:

query model
data application
data aggregator
data model

Answer: data model

 

Question: _________ repository entries are updated to reflect specific technology decisions as they are made.

Answer Options:

DFD
Sequential
CASE
Hardware
None of these

Answer: CASE

 

Question: Which of the following lists indicates the correct ordering of deliverables in a system specification document?

Answer Options:

System Acquisition Weighted Alternative Matrix, Interface Design, Physical Data Model Data Storage Design
Data Storage Design, Interface Design, Architecture Design, Updated CRUD Matrix
Hardware and Software Specifications, Interface Design, Data Storage Design, Architecture Design
Program Design Specifications, Physical Data Model, Data Storage Design, Architecture Design
Update CASE Repository Entries, Update CRUD Matrix, Interface Design, Architecture Design

Answer: System Acquisition Weighted Alternative Matrix, Interface Design, Physical Data Model Data Storage Design

 

Question: If on a limited time budget, the best way to be sure you remain efficient and effective in designing a system is to utilize the __________.

Answer Options:

Porter’s 5 Forces Model
Outsourcing Model
RAD and Timeboxing Techniques
Hire/Fire Motivational Theory
Not Attempt the Project

Answer: RAD and Timeboxing Techniques

 

Question: For efficiency purposes, it is wise to ___________ when there is a basic software need to be satisfied.

Answer Options:

Implement a company-wide project team to handle a custom software scripting
Purchase a packaged system
Design a blueprint and contract an outside vendor to develop a program
Make do with the current software package
Utilize a professional consultant to develop a system of servers?

Answer: Purchase a packaged system