Question: A(n) _____’s main function is to help one understand the complexities of the real-world environment.

Answer Options:

node
entity
model
database

Answer: model

 

Question: A(n) _____ represents a particular type of object in the real world.

Answer Options:

attribute
entity
relationship
node

Answer: entity

 

Question: A(n) _____ is the equivalent of a field in a file system.

Answer Options:

attribute
entity
relationship
constraint

Answer: attribute

 

Question: A(n) _____ is a restriction placed on the data.

Answer Options:

attribute
entity
relationship
constraint

Answer: constraint

 

Question: MySQL is an example of the _____.

Answer Options:

hierarchical model
file system data model
relational data model
entity relationship model

Answer: relational data model

 

Question: A(n) _____ enables a database administrator to describe schema components.

Answer Options:

extensible markup language (XML)
data definition language (DDL)
unified modeling language (UML)
query language

Answer: data definition language (DDL)

 

Question: An example of a capacity requirement would be:

Answer Options:

Transmissions require 287K of data
The system’s uptime will be 99%
The response time must be 2-3 seconds for any transaction
The inventory database will be updated in real time

Answer: Transmissions require 287K of data

 

Question: An n-tiered architecture is distinguished by:

Answer Options:

The number of drives installed
The number of logins on the local server
The number of terminals on the network
The number of specialized server computers
None of these

Answer: The number of specialized server computers

 

Question: Client-server architecture holds the client responsible for _______, and server is only responsible for _______.

Answer Options:

Application Logic; Presentation Logic
Presentation Logic, Data Access Logic, and Data Storage
Data Access Logic and Presentation Logic; Data Storage
Application Logic; Data Storage
Data Storage; Application Logic

Answer: Presentation Logic, Data Access Logic, and Data Storage

 

Question: Server virtualization involves:

Answer Options:

Partitioning a physical server into smaller virtual servers
Stacking blade servers
Using a laptop as a server
All of these

Answer: Partitioning a physical server into smaller virtual servers

 

Question: The cost of infrastructure associated with Server-Based systems is:

Answer Options:

Low
Low-Medium
High-medium
High
Very High

Answer: High

 

Question: The major architectural components of any system are the __________.

Answer Options:

IT Department
Hardware
Software
Hardware and Software

Answer: Hardware and Software

 

Question: The objective of architecture design is to determine __________.

Answer Options:

How aesthetically pleasing the server system will be
What parts of the application software will be assigned to what hardware
How the computers will be arranged to provide ample storage
Where the mainframe will be situated
None of these

Answer: What parts of the application software will be assigned to what hardware

 

Question: The scalability associated with Client-Server systems is:

Answer Options:

Low
Low-Medium
High-medium
High
Very High

Answer: High

 

Question: The _____ model uses the term connectivity to label the relationship types.

Answer Options:

relational
network
object-oriented
entity relationship

Answer: entity relationship

 

Question: Which of the following is true of NoSQL databases?

Answer Options:

They do not support distributed database architectures.
They are not based on the relational model.
They are geared toward transaction consistency; not performance.
They do not support very large amounts of sparse data.

Answer: They are not based on the relational model.

 

Question: Mac OS and iOS applications are developed using ________.

Answer Options:

Java
C#
Objective-C

Answer: Objective-C

 

Question: A software package, used in hospitals, helps schedule appointments and bill patients. This software package is an example of ________.

Answer Options:

Virtual application software
Cloud-based application software
Vertical-market application software
Horizontal-market application software

Answer: Vertical-market application software