Select the data type that can only be classified as a number.
13:30
$1,253.12
11/10/11
83.152
Designing a
... [Show More] 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.
How many records are displayed in the query?
Student_ID Student_Name State Birth_Year Degree
44352 Anderson, Tiffany IL 1994 Graduate Economics
98425 Avendano, Marco MN 1994 Graduate Accounting
67512 Barrett, Eliza IL 1992 Graduate Mathematics
97156 Brown, Amy MN 1994 Undergraduate Pre-Medicine
Student_ID Student_Name State Birth_Year Degree
36401 Elissa, Jose WI 1997 Undergraduate Accounting
97315 Grey, Nicole VT 1999 Undergraduate Theatre
54074 Harris, Blake IL 1992 Undergraduate Accounting
64782 Jensen, Allan MN 1990 Graduate Economics
1
2
3
4
Managing Data in a Database
11
Brian has a corrupted file that tries to load when his computer is booting up.
To solve this problem, he restarts the computer, then presses F8 to display
the Advanced Boot Options menu.
Which solution is Brian using?
Safe Mode
Control Panel
Help System
Windows Backup [Show Less]