2. Sophia - Information Technology (3) - Unit 2

Jeremiah searches his computer for movie files that he recently shot during his vacation in Belize. Select the set of file types that Jeremiah should look for. .avi and .wmv .mov and .ods .mpg and .key .wma and .mpg

.avi and .wmv

Bernard is loading photos, drawings, and videos of his recent vacation into his movie editor software. As he searches his computers files, which file extension would his photos and images be saved as? .txt .png .wma .exe

.png

John queries the database shown to retrieve the number of customers in VA who purchased SKU 3441. How many records are displayed in the query? 6 2 3 1

1

Jeremy wants to buy a horse. He is looking for a Tennessee Walker that is at least five years old AND at least 15 hands tall from the below database table. How many records from the below table are returned by his query? COLORBREEDHANDSAGEBrownTennessee Walker14.57BlackTennessee Walker165BrownThoroughbred16.58BrownTennessee Walker145BrownTennessee Walker15.52BlackThoroughbred153BlackTennessee Walker159 1 2 0 3

2

Select the value whose only appropriate data type is numerical (number). $1,253.12 83.152 13:30 11/10/11

83.152

Kelly is looking at an entry in a restaurant's meals database that contains details about the cost, name of the dish, and ingredients for a specific meal.What type of database element is Kelly looking at? A record A table A column Quantitative data

A record

Paul is looking at his school's student database and finds the row that contains all of his information, including his name and student ID number. The row with all of Paul's information would be considered which of the following database elements? A flat file A record A field Quantitative data

A record

Select the example of a software application used appropriately within a domain. A.) A marketing manager uses Keynote to share graphics and sales trends with her team. B.) A manager uses Microsoft Word to record inventory and make sales queries. C.) A professor uses PowerPoint to enter exam scores and calculate averages. D.) A promoter uses Access to design a music poster for an upcoming concert.

A.) A marketing manager uses Keynote to share graphics and sales trends with her team.

Which of the following is NOT a feature of web-enabled data warehousing? A.) Analyzing the cost-effectiveness of the data warehouse B.) Analyzing the effect of marketing C.) Analyzing affiliated product relationships D.) Analyzing user preferences

A.) Analyzing the cost-effectiveness of the data warehouse

Simultaneously pressing the Windows key and the __________ key is a shortcut that opens File Explorer. A.) E B.) D C.) A D.) I

A.) E

Which of the following are the two main categories of elements within the Windows operating system? A.) System configuration and user interface B.) Productivity software and virtual memory C.) Device manager and Windows shell D.) Multitasking and multiuser

A.) System configuration and user interface

A __________ is the setting in which a software application is meant to function. A.) domain B.) category C.) database D.) spreadsheet

A.) domain

Database is a type of productivity software that is used for __________. A.) entering, retrieving, updating, and reporting information B.) creating high-resolution illustrations C.) typing, editing, and formatting text and images D.) performing numerical calculations and analysis, as well as creating charts

A.) entering, retrieving, updating, and reporting information

An operating system serves as the bridge between __________, making sure the resources required to function are allocated. A.) hardware and applications B.) peripherals and memory C.) open-source and commercial D.) the GUI and the user

A.) hardware and applications

A __________ is a subset of data in a database that answers a given question. A.) query B.) flat file C.) file extension D.) foreign key

A.) query

All data within an individual database should be __________. A.) related B.) qualitative C.) quantitative D.) in a single table

A.) related

When a computer is experiencing lag, it is usually a __________ problem. A.) system performance B.) programming C.) software D.) file management

A.) system performance

If users wanted to edit some of their basic system settings, they would use __________. A.) the control panel B.) the taskbar C.) Windows Explorer D.) the device manager

A.) the control panel

If you have an issue that you are unsure of how to fix, you can use __________, which is a combination of files on your computer and information from the Internet. A.) the help system B.) Windows Explorer C.) the system configuration D.) the taskbar

A.) the help system

Which of the following is most likely or appropriate to be a FIELD in a database table? Account_Balance $969.78 $1,345.20 $2,109.49

Account_Balance

Ron says that a computer's operating system provides an interface for the user. Vicki said that, with a few exceptions, all computing systems use an operating system. Ryan thinks an operating system provides a platform for software developers to create new applications. Alice says that many computers can be operational even without an operating system. Which person's statement about an operating system is FALSE? Ron Alice Vicki Ryan

Alice

___________ software are types of productivity software. A.) Presentation and utility B.) Spreadsheet and presentation C.) Virtual memory and system configuration D.) Programming and word processing

B.) Spreadsheet and presentation

In __________, data is standardized so that all information that is stored and reported is consistent. A.) a top-down system B.) a data warehouse C.) data mining D.) business analytics

B.) a data warehouse

When creating a data warehouse, a business must decide whether to start with the creation of data marts in a __________ approach, or to start with the creation of the data warehouse itself in a __________ approach. A.) centralized; performance B.) bottom-up; top-down C.) time-variant; non-operational D.) top-down; bottom-up

B.) bottom-up; top-down

A __________ is a two to four-character suffix on a file name that gives the operating system the information it needs to identify the file. A.) data file B.) file extension C.) software file D.) file manager

B.) file extension

The __________ is the field in a table that links to the __________ of another table. A.) primary key; primary key B.) foreign key; primary key C.) tuple; foreign key D.) primary key; title

B.) foreign key; primary key

Apple's software application Keynote would likely be used to __________. A.) write a report B.) make a presentation C.) analyze statistics D.) create data charts

B.) make a presentation

The following image is an example of a __________ database. A.) flat file B.) relational C.) qualitative D.) quantitative

B.) relational

A __________ is a way to organize related data in a database using rows and columns. A.) tuple B.) table C.) field D.) record

B.) table

When a computer is off, pressing the power button will initiate __________. A.) File Explorer B.) the boot process or sequence C.) a shut down D.) the start menu

B.) the boot process or sequence

File Explorer displays information from ___________ as a hierarchy of drives, folders, and files. A.) ROM B.) the hard disk C.) the CPU D.) RAM

B.) the hard disk

Which of the following programs would be used for creating a spreadsheet? A.) Microsoft Access B.) Microsoft Word C.) Microsoft Excel D.) Microsoft Powerpoint

C.) Microsoft Excel

__________ is software whose usage is free and whose source code is public, whereas __________ is software that costs money and whose source code is private to the developing company. A.) Graphical; command line B.) An operating system; application software C.) Open-source; commercial D.) Multiuser; multitasking

C.) Open-source; commercial

The process of analyzing data for trends or patterns to use in decision-making is known as __________. A.) business intelligence B.) big data C.) data mining D.) business analytics

C.) data mining

A file is considered to have a foreign file type when it is __________. A.) opened with the software that was used to edit the file B.) sent through email before being opened C.) opened with software that was not used to create the file D.) created in a different language

C.) opened with software that was not used to create the file

Web-enabled data warehousing captures __________ data in real-time, and uses that data in tandem with traditional data to gather more information. A.) trend and user preference B.) publicly accessible and government C.) screenshot and clickstream D.) browser history and screenshot

C.) screenshot and clickstream

In a table of student data, the __________ field would be used as the primary key because it is a unique identifier that will not change. A.) date of birth B.) last name C.) student ID D.) first name

C.) student ID

If an application is unresponsive, you can use the __________ to check its performance and force quit the application. A.) device manager B.) control panel C.) task manager D.) file folder

C.) task manager

Which of the following file extensions would be used for a sound file? A.) .csv B.) .wpd C.) .bat D.) .aac

D.) .aac

Which of the following statements about database management is true? A.) Single-user databases can be accessed through the Internet. B.) Some databases are accessed through software, while others are accessed through hardware. C.) Relational databases do not allow access to the stored data. D.) Accessing stored data is integral for business analysis and decision-making.

D.) Accessing stored data is integral for business analysis and decision-making.

Which of the following statements about data types is true? A.) Data types are a classification of what kinds of values a field will hold. B.) Data types inform the database on what kinds of actions can be performed on each field. C.) Data types inform the database on how much memory to allocate for each field. D.) All of the answer choices are correct.

D.) All of the answer choices are correct.

If you wanted to create a text document with a word processor, you could use __________. A.) Open Office Impress B.) Microsoft Excel C.) Microsoft Access D.) Google Docs

D.) Google Docs

Which of the following statements describes the challenge of data quality associated with data warehousing? A.) It is usually necessary to hire business-intelligence trained technicians who will be able to determine more effectively what the implications of the company's needs and desires are in order to design the best data warehouse. B.) It is difficult, but essential, to know what analyses will be performed on the data obtained ahead of time for the purpose of designing a data warehouse that will perform as intended for the needs of the company. sell. D.) Since data enters the data warehouse from multiple sources, there is a concern regarding the consistency and completeness of the data obtained, as well as a concern about duplicate data that may interfere with reporting.

D.) Since data enters the data warehouse from multiple sources, there is a concern regarding the consistency and completeness of the data obtained, as well as a concern about duplicate data that may interfere with reporting.

If the given database of university students were queried for female students born after 1994, how many records would be returned? First_NameLast_NameGenderAgeD.O.BAndreaJohnsonF207/18/1996CharlesFlynnM229/2/1994JasonMyersM233/28/1994NoraHansonF191/12/1998PeterSmithM2211/4/1995 A.) Zero B.) Three C.) One D.) Two

D.) Two

An operating system is considered multitasking when it __________. A.) runs on two different computers at once B.) utilizes multiple peripherals at once C.) supports multiple users at once D.) runs multiple software programs at once

D.) runs multiple software programs at once

What type of software is Access? Email Drawing Presentation Database

Database

Watch the short video and then select the Windows file action that did NOT occur during the video. Play Video Renaming a new folder Deleting a folder Creating a new folder Moving a file to another folder

Deleting a folder

Luis has an organized system of icons, files, and folders on his computer's home screen. Which element of the Microsoft Windows operating system is Luis using? Device Manager Control Panel Start Menu Desktop

Desktop

Select a challenge of data warehoDuplicated data Transitioning to a web-enabled data warehouse Working in a cloud computing environment Duplicated data Web traffic analysis

Duplicated data

Whose purpose would Google Docs best serve? Tim would like to analyze his salespersons' performance over time. Samaira wants to give a presentation at a meeting. Ethan wants to create an outline for a poster with his group for a school project. Shirley wants to keep track of her financial records.

Ethan wants to create an outline for a poster with his group for a school project.

Which of the following is an example of the data type yes/no? False -10 Andrew $5.00

False

Select the scenario that describes a bottom-up approach to data warehouse design. Dave's Appliances, which is expanding to new locations in the city, collects data into a centralized database, and then redistributes it to three new data marts. Hollywood Advertising combines established data marts from its San Diego, Los Angeles, and San Francisco offices into a single data warehouse. Jaime's Research Consulting Firm combines data from its clients into a central database, then redistributes the data to several individual contractors. Charley's Wholesalers combines data from its produce, meat, and dry goods vendors into a centralized data warehouse, then redistributes it among several data marts.

Hollywood Advertising combines established data marts from its San Diego, Los Angeles, and San Francisco offices into a single data warehouse

__________, which was created by OpenOffice, enables users to create slideshow presentations. Writer Access Pages Impress

Impress

Which statement is characteristic of a relational database? It is a simplistic type of database. Information is shared between tables. Edits made to one table do not change other tables. A single table is used.

Information is shared between tables.

Which productivity software is used to create tables from statistical data? Open Office Impress Google Docs Microsoft Word Microsoft Excel

Microsoft Excel

Pille runs a small business. She wants to create and send invoices to her customers that contain their individual purchase data and calculate their total cost. Which productivity software should Pille use? Google Slides OpenOffice Calc Microsoft Word MySQL

OpenOffice Calc

Select the person using PowerPoint. Patty is using a program to create a set of slides to be shown on an overhead screen. Jerome is using a program to write an office memo. Erin is using a program to analyze financial data. Charley is using a program to enter, retrieve, organize, and update customer sales records.

Patty is using a program to create a set of slides to be shown on an overhead screen.

Which of the following is a challenge of data warehousing? Cloud computing environments Updating data Low quantities of data Privacy concerns

Privacy concerns

Gabrielle's laptop often crashes when she starts it up.Which troubleshooting step/solution would you recommend to her? Defragment System Restore Safe Mode Task Manager

Safe Mode

When Marco returned from a vacation in Hawaii, he uploaded several pictures and video clips that he took at the beach. After editing some of the pictures using photo editing software, he opened a video-maker program to edit footage. Shortly after he opened the video-maker, the program stopped responding. Which tool or method is best for Marco to use to solve this issue? Safe Mode System Restore Help System Task Manager

Task Manager

Identify the true statement about Windows tasks. There is only one way for users to launch applications from Windows. The GUI controls the process for shutting down Windows. Pressing the Windows key and the E key simultaneously is one way to end a program. The Welcome screen lists the user accounts on the system.

The Welcome screen lists the user accounts on the system.

Which element of the Microsoft Windows operating system provides the main mechanism through which the GUI is presented? Device Manager Control Panel Taskbar Windows shell

Windows shell

The __________ approach starts by creating small data warehouses, called __________, to solve specific business problems. bottom-up, data marts top-down, data farms database design, data mines standardized, data environments

bottom-up, data marts

Merle cannot open documents created by one program on a machine that does not have the program installed. Merle is dealing with a(n) __________. network connectivity problem hardware crash file management issue application crash

file management issue

When Charlie attaches a file to an email message, the computer's __________ is responsible for managing his access to the location where the file is stored. hardware shell SSD operating system

operating system

Heather's computer hardware lags during execution of instructions sent to it by the software. Heather is experiencing a(n) __________. system performance problem software crash hardware crash external error

system performance problem