Sophia – Information Technology - Unit 2 Milestone 2 –
(100% CORRECT)
Select the data type that can only be classified as a number.
•
13:30
•
$1,253.12
•
11/10/11
•
83.152
Designing a Database
2
__________,
...
Sophia – Information Technology - Unit 2 Milestone 2 –
(100% CORRECT)
Select the data type that can only be classified as a number.
•
13:30
•
$1,253.12
•
11/10/11
•
83.152
Designing a Database
2
__________, developed by Apple, can be used to calculate and organize financial
information.
•
Calc
•
Keynote
•
Numbers
•
Excel
Selecting Software
3
Select the scenario that describes a bottom-up approach to data warehouse design.
•
Dave’s Appliances, which has five locations in the city, combines data from each store
to a single database, and distributes it to three new data marts.
•
Jaime’s Research Consulting Firm combines data from its clients into a central
database, then shares the data with several individual contractors.
•
Hollywood Advertising combines data marts from its San Diego, Los Angeles, and San
Francisco offices into a single data warehouse.
•
Charley’s Wholesalers combines data from its produce, meat, and dry goods vendors
into a single data warehouse, and distributes it among several data marts.
Data Warehousing
4
Althea launches a program to remove some software she no longer uses.
Which element of the Microsoft Windows operating system is Althea using?
•
Windows Search
•
Start Menu
•
Control Panel
•
Windows Mobility
The Microsoft Windows Operating System
5
While saving a document to her hard drive, Connie's computer screen suddenly changed to
display an error message on a blue background. The error code indicated that there was a
problem with her computer's RAM.
Connie's computer is affected by a(n) __________.
•
application error
•
file compatibility issue
•
hardware crash
•
system performance issue
Troubleshooting with Microsoft Windows
6
Which of the following correctly describes a record?
•
A record contains all the data about one instance of an item in a database.
•
A record contains all the qualitative data in a database.
•
A record represents a single type of information found in a database.
•
A record is an organized collection of data associated with other data in a database.
Introduction to Databases
7
Which of the following is the FIELD in a database table?
•
6/5/1985
•
[email protected]
•
Emily Walker
•
Name
Introduction to Databases
8
Which statement describes an example of database software?
•
Microsoft Excel enables users to perform calculations and statistical analyses.
•
Microsoft Word enables users to write and edit text documents.
•
Microsoft Access enables users to create, store, and retrieve records.
•
Microsoft PowerPoint enables users to create animated presentations that can be
projected on a screen.
Productivity Application Software
9
Sarah is creating custom reports from her company's database.
Select the set of file types that Sarah will use to create these reports.
•
.tif and .db
•
.sql and .xml
•
.txt and .dat
•
.csv and .pptx
Application Software File Types and Formats
10
An enrollment counselor queries the following database table to identify undergraduate
accounting majors.
........continued........
