BI 255 EXAM QUESTIONS AND ANSWERS
LATEST UPDATE
My dog Winston's current weight would be an example of what component of a
veterinary information system?
Data
An example of an information technology that can be used for a competitive
advantage is:
Radio-frequency identification (RFID) tagging or bar coding of items
If I receive an email which says I have won the "$2,000,000 Google Email Lottery",
what should I do?
Delete it... it's a scam!
The data hierarchy of data stored in a database does NOT include which element?
Computers
An index improves access to records in a database by:
Providing the record number where the database can find the requested data item
A person's address can always be stored in what type of data model?
Strict hierarchical data model
How are records related in a relational data model?
The foreign key value in a record relates that record to the primary key of a record in a
second table
What key combines the values of several fields together to create the value of the
unique primary key?
Compound primary key
Which component of a database management system works directly with the
physical data files?
Database engine
Which component of a database management system would be used to create or
change the data dictionary?
Data definition
Important keywords in Structured Query Language (SQL) queries?
Select, Update, Insert
The process of creating a data warehouse involves:
The extraction, transformation, and loading (ETL) of data from multiple data sources
into raw data that is summarized and processed into the data warehouse.
Ab object-oriented database would be a good choice for:
An online content-delivery system, such as for purchase and delivery of digitalized
movies, to improve speed of delivery
Who would be the primary users of the data administration component of a
database management system?
Database administrators
What is a data mart?
, A subset of a data warehouse, intended for a specific department or set of users in the
organization
The actual data in MS Access database is stored in:
Tables
Information formatted for print or display as pages would be created in an MS
Access:
Report
Data types available for MS Access table fields are:
Currency, Number, Date/Time
The design view of a MS Access table represents which component of a database
management system (DBMS)
Data dictionary or data definition
The typical relationship between a primary key field in a table and the
corresponding foreign key field in a second table is:
One-to-many
What "view" of reports displays actual report data, but allows changes such as
resizing of fields, and field display re-ordering on the page?
Layout View
What computer "building block" allows connection of many different types of
external devices to the computer, such as keyboards, mice, printers, and memory
sticks?
Universal Serial Bus (USB)
What software component controls and manages computer hardware and
software, and performs repetitive tasks for users such as file services, network
services, and print services?
Operating System (OS)
Approximately how many megabytes are in a gigabyte?
1,000
One recent strategy employed by computer manufactures to increase overall
performance of the central processing unit (CPU) is:
Produce CPUs with multiple processing cores, allowing parallel processing
The central processing unit (CPU) of a computer communicates with the
computer's internal disk drives through which computer building block?
Internal bus
What is likely happening when your cell phone receives a major update, during
the time you can't use it?
The Programmable Read-Only Memory (PROM) is being updated, or "flashed", with an
updated phone operating system
One of the first character sets invented was ASCII, which specified that each
character would be stored in on byte (8 bits) of storage. Later character sets,
such as Unicode, expanded the number of bytes per character, allowing more
character codes to be defined. Why?
So that European accented characters, and symbolic Asian languages (such as
Chinese) could be displayed and processed by computers.
What is the set of steps or process for solving a problem, which is implemented
in a computer program, called?
LATEST UPDATE
My dog Winston's current weight would be an example of what component of a
veterinary information system?
Data
An example of an information technology that can be used for a competitive
advantage is:
Radio-frequency identification (RFID) tagging or bar coding of items
If I receive an email which says I have won the "$2,000,000 Google Email Lottery",
what should I do?
Delete it... it's a scam!
The data hierarchy of data stored in a database does NOT include which element?
Computers
An index improves access to records in a database by:
Providing the record number where the database can find the requested data item
A person's address can always be stored in what type of data model?
Strict hierarchical data model
How are records related in a relational data model?
The foreign key value in a record relates that record to the primary key of a record in a
second table
What key combines the values of several fields together to create the value of the
unique primary key?
Compound primary key
Which component of a database management system works directly with the
physical data files?
Database engine
Which component of a database management system would be used to create or
change the data dictionary?
Data definition
Important keywords in Structured Query Language (SQL) queries?
Select, Update, Insert
The process of creating a data warehouse involves:
The extraction, transformation, and loading (ETL) of data from multiple data sources
into raw data that is summarized and processed into the data warehouse.
Ab object-oriented database would be a good choice for:
An online content-delivery system, such as for purchase and delivery of digitalized
movies, to improve speed of delivery
Who would be the primary users of the data administration component of a
database management system?
Database administrators
What is a data mart?
, A subset of a data warehouse, intended for a specific department or set of users in the
organization
The actual data in MS Access database is stored in:
Tables
Information formatted for print or display as pages would be created in an MS
Access:
Report
Data types available for MS Access table fields are:
Currency, Number, Date/Time
The design view of a MS Access table represents which component of a database
management system (DBMS)
Data dictionary or data definition
The typical relationship between a primary key field in a table and the
corresponding foreign key field in a second table is:
One-to-many
What "view" of reports displays actual report data, but allows changes such as
resizing of fields, and field display re-ordering on the page?
Layout View
What computer "building block" allows connection of many different types of
external devices to the computer, such as keyboards, mice, printers, and memory
sticks?
Universal Serial Bus (USB)
What software component controls and manages computer hardware and
software, and performs repetitive tasks for users such as file services, network
services, and print services?
Operating System (OS)
Approximately how many megabytes are in a gigabyte?
1,000
One recent strategy employed by computer manufactures to increase overall
performance of the central processing unit (CPU) is:
Produce CPUs with multiple processing cores, allowing parallel processing
The central processing unit (CPU) of a computer communicates with the
computer's internal disk drives through which computer building block?
Internal bus
What is likely happening when your cell phone receives a major update, during
the time you can't use it?
The Programmable Read-Only Memory (PROM) is being updated, or "flashed", with an
updated phone operating system
One of the first character sets invented was ASCII, which specified that each
character would be stored in on byte (8 bits) of storage. Later character sets,
such as Unicode, expanded the number of bytes per character, allowing more
character codes to be defined. Why?
So that European accented characters, and symbolic Asian languages (such as
Chinese) could be displayed and processed by computers.
What is the set of steps or process for solving a problem, which is implemented
in a computer program, called?
