CGS2100 Final Exam

What are common audio file formats?

- .wav - .mp4 (M4A) - .mp3

Select all the tablet computers.

- Apple iPad - Samsung Galaxy Tab - Amazon Fire HD

There are several ways to create a new folder in Windows. Which of these would work?

- Right-click a folder in the folders list. Click New and then click Folder. - On the command bar, click New folder. - Right-click any blank area in the Contents pane. Click New and then click Folder.

Which two statements about Instagram are true?

- The Profile section lists your name, birthday, gender, and phone number. - If you don't want to be tracked, turn off geo-tagging in the Settings under Location Services.

Select the Amazon tablets.

-Fire HD -Fire Kids

Which of these devices are manufactured by Samsung?

-Galaxy -Note

There are several ways to rename a folder in Windows. Which of these would work?

-On the command bar, click Organize and then click Rename. -Click the folder icon and press F2 to activate the edit mode. -Right-click a folder and click Rename.

Select the major cell phone service providers in the U.S.

-Verizon -ATT -T-Mobile/Sprint

Which two of the following are true regarding LinkedIn?

-You can use LinkedIn to apply for jobs - LinkedIn includes a resume tool to assist you in creating a professional resume.

Select the reasons why you might want to add a microSD card to your smartphone.

-You want to save more music files -You want to save more image files(photos)

Select the reasons to purchase a prepaid phone.

-no long term contracts -useful if you need a phone for calling or texting -useful if you just need a phone for emergencies

Database file format

.accdb

Which of the following file extensions is commonly used for term papers and other word processing tasks?

.docx

Web Page file format

.html

Presentation file format

.pez

Select the common image file formats.

.png .jpg

Spreadsheet file format

.xlsx

You've started a report and want to save it to your Desktop. Place the following steps in order, with the first step on the top.

1. Click the File tab. 2. Select Save As. 3. Select Computer. 4. Select Desktop. 5. Name the file and click Save.

Place the following steps in order if you wish to view all your files' extensions.

1. Open File Explorer (if you do not have an icon for this in the taskbar, click Start, select Windows System, and then select File Explorer). 2. In File Explorer, click the View tab. 3. In the View tab, click the check box next to File name extensions to see file extensions. 4. View the file extensions for the various files in File Explorer.

Select what's true about object-oriented databases.

1. Store instructions for how to compute the data as well as the data to be processed 2. Equipped to handle unstructured data such as MP4 files, videos, images, and extremely large files 3. Use Object Query Language to construct queries that extract data from the database

List the following steps in the order that they occur after you press "send" on your phone.

1. The signal is sent via weak microwaves to a cell tower. 2. The cell tower's base transceiver station sends the signal to your MSS. 3. Your MSS sends the signal to the receiver's MSS. 4. The receiver's MSS locates the receiver's phone and sends a signal to the receivers BTS and associated cell tower.

Select three RFID system parts.

1. Transceiver 2. Transponder 3. Antenna

Put the following steps in order to open a Microsoft e-mail account (first step on top).

1. Type "onedrive.live.com" into your browser window. 2. Select Personal and Sign up for free. 3. Select Create a Microsoft account. 4. Select Get a new e-mail address.

How much storages comes with a Typical tablet or smartphone?

16-256 GB

How much storage does a DVD usually have?

3-5 GB

If you just need a phone for calling and texting, a ________ phone can save you money.

3G

How much storage does a typical laptop have?

500 GB-1 TB

Select the advantages of using a database instead of a traditional filing system.

A database can hold larger amounts of data. A database can provide better data integrity.

Select the video file compression formats.

AVI MP4 QuickTime

Once so commonly used that people even called it the "Crackberry," the ________ popularity dropped significantly in the United State after 2007.

Blackberry

To remove a file from one folder and place it in another, click on the item and press ________, then move your cursor to the new location and press CTRL + V.

CRTL+X

The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application ________ subsystem.

DBMS

Which two of the following are considered storage media?

DVDs Blu-ray Discs

The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ________ subsystem.

Data Administration

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

Select the characteristics of the iOS.

Developed by Apple for Apple products, Used on iPhones and iPods Comes with Siri, iTunes, iBooks, etc.

A quick way to rename files or folders in Windows is to select the item and then press the ________ key.

F2

You created a flyer and saved it in your Documents folder. To find this file you could open Cortana (in Windows 10) and type the flyer's name in the search window, or you could click on the ________ icon (all Windows versions, on your toolbar) and access the Documents folder from there.

File Explorer

Which is not considered an e-commerce transaction?

G2B

The two most common audio file formats are WAV and ________.

MP4

A million bytes of data equals one ________.

Megabyte

One advantage that the Samsung tablets have over the iPads is that you can add ________ to the Note or Tab.

MicroSD storage

Because it locates cellular devices, assigns frequencies, transmits signals to the correct sites, the ________ is probably the most important part of any cellular network.

Mobile Switching Station (MSS)

Select three advantages of helium hard drives over traditional hard drives.

Platters Spin Faster Platters Stay Cooler More platters can be placed in the same amount of space

Because of its capability of storing data in multiple hard drives, data warehouses use ________ technology to ensure redundant data storage.

RAID

All of the following are true about RFID except

RFID uses infrared transmissions

If you accidentally delete a file it's not lost forever! Just go to your Recycle Bin, select the item, and click ________.

Restore

Because they have no mechanically moving parts, ________ provide extremely fast, efficient storage.

SSDs

Which of the following refers to the distribution of computer applications over the Internet and is commonly referred to as web apps?

SaaS

You're tired of losing documents so you've decided to save your research paper to your desktop where you know you'll be able to locate it quickly. To save it to the desktop, you first click the File tab to open the file menu. Next you select ________.

Save As

A tablet is a highly-mobile computer with a mobile operating system and a touchscreen rather than a keyboard/touchpad. To differentiate a tablet from a smartphone, a tablet is generally understood to have a screen size of at least ________ inches.

Seven

In general, the ________ the access time, the faster the hard drive.

Shorter

The Federal ________ Commission is the main government organization that oversees Internet privacy.

Trade

Characteristics of Android 11.0

Used with Samsung phones and Google phones.

Select three characteristics of SSD storage.

Uses the same technology that is found in USB drives Has no mechanically moving parts Uses flash technology

Select two audio file compression formats.

WAV MP4

The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data?

What data type will be included What field name will the data fall under

Even though it was developed by one of the world's largest software manufacturers, the ____ was a commercial failure.

Windows Phone

Zip

a lossless compression format

DVDs store data using ________.

a reflective coating that has pits and lands

In professional messages, avoid the use of emoticons and ________.

acronyms

The smallest unit of data storage is a ________.

bit

One character of information, for example, a letter or a number comprises of one ________ of storage.

byte

The fact that data on servers is nearly always backed up onto other servers gives ________ storage a major advantage over other data storage methods.

cloud

Large databases, often called data banks, that cover particular subjects are referred to as ________ databases.

commercial

If you wish to e-mail a file to a friend, but find that it's too big for your e-mail server, you can always ________ the file.

compress

You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In StubHub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ________.

database

If you have two folders open on your desktop and you want to move a file from one folder to the other, simply ________ the file.

drag

The interfaces for the logical view of a database and the physical view of a database are provided by the DBMS ________.

engine

Theft of software occurs when someone engages in all the following except ________.

erasing a program you have purchased

In a database a ________ is a group of related characters in a database table that represents a characteristic of someone or something.

field

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ________ key.

foreign

When you need to link two tables in a database that don't have a field in common, one solution is to create a ________ in one table that links to the primary key in the other table.

foreign key

To control how information is entered into a database, programmers and database administrators create ________ to help ensure data integrity.

forms

The largest category of apps, both in terms of active downloads and in terms of revenue generated is ________.

game apps

Software piracy include all the following except

illegally learning about software

Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ________.

integrity

A short (simple text) e-mail uses about one ________ of data.

kilobyte

The DBMS subsystem that allows for data maintenance and data analysis, including providing the capability to create queries, reports, and forms is referred to as the data ________ subsystem.

manipulation

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem.

manipulation

Because of its potential to diagnose health issues, one of the largest data requirements of the future will likely be ________.

mapping patients' genomes

An electronic element that stores data by changing its resistance based on the current that has passed through it (similar to RRAM) is called a(n) ________.

memristor

Cell phones send and receive extremely weak ________ signals to and from cell towers.

microwave

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ________ database.

multidimensional

Blu-ray technology stores data using ________.

pits and lands that are read by a blue spectrum laser beam

To listen to an .mp4 (M4A) file, you'll need an app such as iTunes or QuickTime. These apps are called audio ________.

players

When creating a social media brand identity, it is important to ________ regularly to your social media sites.

post

lossy

reduces space required by removing less valuable data

Lossless

reduces spaces required by reducing redundancy in files

With regard to digital storage, RAID stands for ________.

redundant array of independent discs

The type of database that uses common fields to create links between tables is called a ________ database.

relational

A link between tables in a relational database that defines how the data is related is called a ________.

relationship

If you're in an area where your home network has no cell coverage, you may need to use the cellular network of a different provider. This is called ________.

roaming

Adding a microSD card (when possible) increases your phone's ________ capacity.

storage

The cell tower's base transmission station is connected to a mobile ________ station.

switching

A collection of related records in a database is referred to as a ________.

table

The sender of a snap in Snapchat can set the length of ________ the snap can be viewed before it is no longer visible.

time

Because of the popularity and bandwidth demands of video streaming, ________ data plans became very expensive. Tough competition for customers forced cell phone service providers to increase available bandwidth, so now these data plans are fairly common.

unlimited

Characteristics of iOS 15 series

used on iPhone 13 Pro

To change the size of your folder's icon, just right-click on a blank area of the Contents pane and click ________.

view