MANAGEMENT OA AND PA 2026-2027 BANK
2 VERSIONS CURRENTLY TESTING
COMPLETE EXAM QUESTIONS WITH
DETAILED VERIFIED ANSWERS /EXPERT
VERIFIED /ALREADY GRADED A+
A large hotel chain needs to develop a system that would
coordinate its airport shuttle service with its customer's
needs. This requires that their systems analysis staff
interacts with both customers and shuttle drivers to
identify and document the necessary requirements.
In which role would a systems analyst assume to address
this issue?
a- supporting expert
b- change agent
c- problem solver
d- communicator - ....ANSWER...d- comunicator
Which tool is appropriate for use in the design phase of
information systems development to specify the detailed
,logic of a business process in narrative form in a manner
easily translatable into any programming language?
a- work breakdown structure
b- unified modeling language
c- flowchart
d- pseudocode - ....ANSWER...d- pseudocode
A company has many separate departments that focus on
different business aspects and uses data warehouse subsets
to hold data specific to each individual department. The
company started a new department and created a new
subset.
What is this new subset called?
a- primary data
b- data tuple
c- data mart
d- secondary data - ....ANSWER...c- data mart
An auto parts manufacturer is creating a new relational
database to more accurately identify their customers and
,vendors. The manufacturer's database design team decided
to use "vendorID" to link a given vendor to a specific
product.
What type of attribute is "vendor ID"?
a- primary key in record "vendor"
b- primary key in record "product"
c- foreign key in record "vendor"
d- master key in record "product" - ....ANSWER...a-
primary key in record "vendor"
Which database type, used frequently in early style
databases buy much less frequently today, contained
inflexible data relationships that formed a treelike
structure?
a- hierarchical database
b- relational database
c- object-oriented database
d- analytical database - ....ANSWER...a- hierarchical
database
Amanda has been asked to regularly extract and process
databases from many sources into a data warehouse,
, which will be used by several divisions within the
company.
a- historical
b- external
c- static
d- variable - ....ANSWER...d- variable
A marketing research firm is planning a study involving
consumer preferences toward new coffee flavors. The
company needs to analyze coffee data from the coffee
manufacturer, as well as preference data from consumers
in order to discover whether certain flavors are more or
less popular among certain segments of the population.
Which database technology would help the company
conduct this research project?
a- business intelligence system utilizing data mining
technology
b- multi-user transactional database that integrates data
from various sources
c- data reporting tool capable of generating ad hod
managerial reports