BCIS FINAL EXAM UPDATED ACTUAL
QUESTIONS AND CORRECT ANSWERS
Three-tier architecture and how each tier works - CORRECT ANSWER -1. PRESENTATION
TIER: Top most level of the application is the user interface. The main function is to translate
tasks/project the picture a user understands.
2.LOGIC TIER: Level that coordinates the app, process commands, makes logical decisions and
evaluation and performs calculations. Also moves and processes data between two surrounding layers.
3. DATA TIER: Information is stored and retrieved from the data base here. It is the passed back up to the
logic tier for processing and then eventually back to the user.
Characteristics of Cloud Computing Services - CORRECT ANSWER -1. ON DEMAND SELF
SERVICE: users are able to use cloud computing services without human interaction.
2.BROAD NETWORK ACCESS: Can access from any location using multiple tools.
3.RESOURCE POOLING: Enables employees to enter/use data without the business management
software at the same time from any location.
4.RAPID ELASTICITY: Speed of retrieving data.
5. MEASURED SERVICE: Paying for the amount of storage being used.
Advantages of using cloud computing services - CORRECT ANSWER --Speed of getting data
-can access data from almost anywhere.
-can be more cost efficient
-lowers computer costs
-software updates
improves document format compatibility.
Disadvantages of using cloud computing services - CORRECT ANSWER --requires internet
connection
-does not work well with low speed connection
-security issues
-data can get lost
, Four streams of information in an organization - CORRECT ANSWER -1.INPUT: captures raw
data from organization or external environment.
2.PROCESSING: converts raw data into meaningful form.
3.OUTPUT: transfers processed information to people or activities that use it.
4. FEEDBACK:
Which stream of information we try to manage using a relational database management system (Like MS
Access) - CORRECT ANSWER -
Contents of a database - CORRECT ANSWER -
ERD - CORRECT ANSWER -ENTITY RELATIONSHIP DIAGRAM
ERD Purpose - CORRECT ANSWER -To model or define database structures
What is the purpose of a query? - CORRECT ANSWER -retrieves specific data from one or more
tables to answer a question
Relational Schema and its purpose - CORRECT ANSWER -creates a connection. name of relation,
name of attributes, attributes domains. Consists of the schema of all of the relations in the database.
Information Security - CORRECT ANSWER -Protecting an organization's information and
information systems from unauthorized access, use, disclosure, disruption, modification, or destruction.
Information Systems Security - CORRECT ANSWER -The protection of information systems,
applications and data.
Major elements of security problems - CORRECT ANSWER -1. Threat
2. Vulnerability
3. Safeguards
QUESTIONS AND CORRECT ANSWERS
Three-tier architecture and how each tier works - CORRECT ANSWER -1. PRESENTATION
TIER: Top most level of the application is the user interface. The main function is to translate
tasks/project the picture a user understands.
2.LOGIC TIER: Level that coordinates the app, process commands, makes logical decisions and
evaluation and performs calculations. Also moves and processes data between two surrounding layers.
3. DATA TIER: Information is stored and retrieved from the data base here. It is the passed back up to the
logic tier for processing and then eventually back to the user.
Characteristics of Cloud Computing Services - CORRECT ANSWER -1. ON DEMAND SELF
SERVICE: users are able to use cloud computing services without human interaction.
2.BROAD NETWORK ACCESS: Can access from any location using multiple tools.
3.RESOURCE POOLING: Enables employees to enter/use data without the business management
software at the same time from any location.
4.RAPID ELASTICITY: Speed of retrieving data.
5. MEASURED SERVICE: Paying for the amount of storage being used.
Advantages of using cloud computing services - CORRECT ANSWER --Speed of getting data
-can access data from almost anywhere.
-can be more cost efficient
-lowers computer costs
-software updates
improves document format compatibility.
Disadvantages of using cloud computing services - CORRECT ANSWER --requires internet
connection
-does not work well with low speed connection
-security issues
-data can get lost
, Four streams of information in an organization - CORRECT ANSWER -1.INPUT: captures raw
data from organization or external environment.
2.PROCESSING: converts raw data into meaningful form.
3.OUTPUT: transfers processed information to people or activities that use it.
4. FEEDBACK:
Which stream of information we try to manage using a relational database management system (Like MS
Access) - CORRECT ANSWER -
Contents of a database - CORRECT ANSWER -
ERD - CORRECT ANSWER -ENTITY RELATIONSHIP DIAGRAM
ERD Purpose - CORRECT ANSWER -To model or define database structures
What is the purpose of a query? - CORRECT ANSWER -retrieves specific data from one or more
tables to answer a question
Relational Schema and its purpose - CORRECT ANSWER -creates a connection. name of relation,
name of attributes, attributes domains. Consists of the schema of all of the relations in the database.
Information Security - CORRECT ANSWER -Protecting an organization's information and
information systems from unauthorized access, use, disclosure, disruption, modification, or destruction.
Information Systems Security - CORRECT ANSWER -The protection of information systems,
applications and data.
Major elements of security problems - CORRECT ANSWER -1. Threat
2. Vulnerability
3. Safeguards
