CGS 2060 Final Exam

What is the extension for a database?

.accdb

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

.docx

What extension, if you open it, will probably install software onto your computer? Be careful!

.exe

Which of the following file extensions is commonly used for drawings?

.gif

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.Use Object Query Language to construct queries that extract data from the database 3. Equipped to handle unstructured data such as MP4 files, video, images, and extremely large files

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

1. What field name will the data fall under 2. What data type will be included

Why would you want to add a microSD card to your smartphone?

1. You want to save more music files. 2. You want to save more image files (photos).

What are the functions of a Digital Signal Processor?

1. analyzes signals received from the analog-digital converter to enhance audio quality 2. reduces unwanted noise 3. moderates call volume

What are the advantages of using a database instead of a traditional filing system.

A database can hold larger amounts of data and a database can provide better data integrity

What are examples of tablet computers?

Amazon Fire HD, Samsung Galaxy NotePRO, and Apple iPad

In order to change sound waves into digital signals, smartphones contain ___ - digital converter.

Analog

What operating system is based on Linux and used on smartphones?

Android

When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ___ generation subsystem.

Application

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

Data Type

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ___ .

Database

Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ___ .

Databases

An integral part of a databases management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ___ .

Dictionary

A database that stores data in different physical locations and that users access though client/server networks is called a ___ database.

Distributed

When you ___ a file Windows should automatically open it. If it can't Windows will prompt you to select the correct app to open the file.

Double click

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

F2

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

Forms

Amazon offers 2 lines of tablet computers, the Amazon Fire and the Amazon Fire ___ .

HDX

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ___ .

Hierarchy

Which cloud storage is an organization uses servers in the cloud instead of buying and maintaining storage servers for their day-to-day business operations.

IaaS

Because of the large infrastructure cost of building antennae and mobile switching stations, as well as leasing the rights to use radio frequencies, only ___ companies can compete nationally as cell phone providers.

Large

The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view.

Logical

What is the operating system that Android OS released in 2014?

Lollipop

Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ___ System.

Management

What is the operating system that Android OS released in 2015?

Marshmallow

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

Microwave

By upgrading to it's maximum capacity of 16 GB of RAM and 1 TB of storage, the ___ tablet could be an extremely powerful computer!

Mircrosoft Surface Pro 4

What are the Samsung Galaxy tablet options?

Note series and Tab series

Microsoft offers free cloud storage for everyone who has a Microsoft email account. This storage is called Microsoft ___ .

OneDrive

Which cloud storage is a programming environment used to develop, test, and disseminate web apps via the Internet.

PaaS

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

Players

To search a database for information, create a ___ .

Query

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .

Record

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

Which cloud storage is the distribution of computer applications over the Internet. Commonly referred to as web apps.

SaaS

To look for a file or folder in Windows 10, just type the file name in the __ box.

Search

Cell towers are connected to ___ .

base transceiver stations

What transmission media has the largest bandwidth?

fiber optic

What is found on iPhones and iPads?

iOS

What is the operating system that is used on iPhones?

iOS 9 series

Apple's mobile device with the largest display is the ___ .

iPad Pro

What are some examples of iPhones?

iPhone 6S, iPhone 6S Plus, and iPhone 6 Plus

While many 3rd party apps are available through its App Store, apps for ___ must first be tested and approved before they're made available for downloading.

iPhones

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

mircroSD storage

When choosing a cell phone provider, factors to consider include what?

network size/coverage, service/speed, and pricing

An easy way to create a new folder in Windows is to ___ on any area in the Contents pane, and then click New and Folder.

right-click

Connecting your phone to your laptop to transfer photos, videos, or music files is referred to as ___ .

syncing

Some apps that use a surprising amount of data are those that include embedded ___ .

video

What is the extension for a webpage?

.html

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

What are the common word processing file extensions.

.odf and .docx

What is the extension for a presentation?

.pez

What is the extension for a spreadsheet?

.xlsx

What are the common audio file formats?

1. .mp3 2. .mp4 (M4A) 3. .wav

What are the advantages of using a database instead of a traditional filing system?

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

What are some cell phone manufacturers?

1. Blackberry 2. Xiaomi 3. Huawei

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.

CTRL + X

If you wish to email a file to a friend, but find that it's too big for your email server, you can always ___ the file.

Compress

Before you can start tethering, verify that it's included in your cell phone's ___ plan

Data

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

Field

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

In order to keep your files organized, it's a good idea to create ___ and place your files in them.

Folders

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 complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database.

Multidimensional

After verifying that your data plan includes tethering, the first step in creating a hotspot with your Android phone is to click on the ___ icon.

Setting

The small computer within your phone that enhances the sound quality of your call is called a digital ___ processor.

Signal

Your college has a database with a Students table. Which of the following could be a primary key in the table?

Student number and Social Security Number,

Since it comes with a full computer operating system, some consider the ___ a laptop computer rather than a tablet computer.

Surface Pro 4

In urban areas, the cell towers become more numerous and the cell signals transmitted by the cell towers are ___, than those in less populated areas.

Weaker

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

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

What's true about database fields?

1. A group of related characters in a database 2. Represents a characteristic of someone or something 3. Primary key is a field designation

What's true about database fields?

1. A group of related characters in a database 2.Represents a characteristic of someone or something 3. Primary key is a field designation

What are the amazon tablets?

1. Fire HD 2. Fire HDX 3. Kindle Paperwhite

What are the advantages of a 3G phone?

1. more energy efficient - battery lasts longer 2. less expensive

Being able to surf the web, watch videos, and listen to steaming audio is why cell service with a ___ plan is extremely popular in the U.S.

Data

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

Table

You own a pet care center. what fields might you enter when you create a table for dogs that you care for?

1. Owner's last name 2. Pet's name 3. Owner's address

True or False: When you drag a file into the Recycle Bin it cannot be recovered.

False

True or False: By default Windows hides file extensions for known file types but you can unhide them if you wish.

True

True or False: The mobile switching station can connect calls to mobile switching stations belonging to other cellular networks.

True

A smartphone emits approximately ___ watts of microwaves.

10-15

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

Data Administration

in what ways could you create a new folder in Windows?

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

What are the functions of a Mobile Switching Station?

1. assigns frequencies to your calls 2. sends your call to the receiver's MSS 3. changes the cell and base station your transmissions go through as you travel

What are the reasons to purchase a prepaid phone?

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

What are the characteristics of a OneDrive account

1. requires a Microsoft Email account 2. provides free cloud storage 3. can serve as extra storage space

Two major catagories of cell phones are available. Smartphones with LTE or 4G capability and ___ phones.

3G

If you have 2 folders open on your desktop and you want to copy a file from one folder to the other, hold down ___ and drag the file.

CTRL

When you need to link 2 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 display or distribute information from a database, programmers or database administrators create ___ .

Reports

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

Restore

The most common method of renaming files and folders is to simply __ on the item and select Rename

Right-click

Why would you compress a file?

To reduce the bandwidth needed to transmit a file or to reduce storage space requirements