CGS2060 Final Exam Study Set

Table

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

Multidimensional

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

Distributed

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

Flowchart

A graphic representation of a process is called a _____________.

Relationship

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

Interpreter

A program that can be used to convert a single line of C# into machine language without having to compile the entire program is called a C# __________ .

JavaScript

A program that makes creating websites and webpages much faster is __________ .

Compiler

A program that takes an entire program, check the source code for errors, and converts it into machine language is a ________.

Integrity

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 _________.

Storage

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

Pinning

Adding an application's tile to the Start menu in Windows 10 is called _________ the app.

File Explorer

An efficient way to manage your files in Windows 10 is to use the ___________.

Dictionary

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

Java

An object-oriented programming language that is popular for writing apps for Android phones and tablets is ___ .

Management

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.

Databases

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 ___________.

Organize

Changing the appearance of your folder can make it easier to keep your information organized. To change your folder's appearance, first click on the folder, and then go to the command bar and click ______.

Hierarchy

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 ___________ .

First

Defining the problem is the _____ step in the Program Development Life Cycle

Electronic Data Interchange

EDI stands for ______.

The World Wide Web

HTML and it's 5th revision (HTML5) allow content to be displayed on _________ .

Binary

If it can be answered as either yes or no, or true or false, the question is called _________.

CTRL

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.

Texting

Ironically, the expenses for calling and _______ are among the smallest charges found on a cell phone bill.

microSD

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

CTRL + V

One way to copy a file to a new location is to click on the file and press CTRL + C, then move your cursor to the new site and press ________ .

Settings

Rather than going through the Control Panel, an easy way to change your system settings in Windows 10 is to open Cortana and type ________ in the search window.

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

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

a.A group of related characters in a database b.Represents a characteristic of someone or something c.Primary key is a field designation

Select what's true about database fields

Tethering

Sharing an Internet connection between two digital devices, for example, using your smartphone to create a hotspot and then using the hotspot to connect your laptop to the Internet, is referred to as ____________ .

Separation

Social networking is based on the six degrees of _____ concept which posits that you can connect with anyone through a chain of no more than six introductions or personal links.

Logical

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

Digital-Analog Converters

The devices inside your phone that convert analog waves (such as sound waves) into digital signals that your phone can process are called ________ .

Plus

To create a reminder in Windows 10, click Cortana, then select the light bulb, and then click the _______ sign.

Reports

To display or distribute information from a database, programmers or database administrators create ________ .

Intellectual

To protect against unauthorized software use, sale, or distribution of software, music, movies, video games, and many other digital products, there are ___ property laws.

CTRL + X

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.

Query

To search a database for information, create a _________.

dragging

To select a paragraph in a word processing program is usually as easy as ________ the left mouse button.

double-click

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.

Application

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.

Jump List

Windows 10 allows you to right-click on a app's icon in the taskbar and have a menu of options. It also shows you the most recent files you've had open in the app and allows you to "Pin" items. This menu is called a _________.

Development

Writing software follows a 5-step process called the PDLC. PDLC stands for the Program __________ Life Cycle

AJAX

A set of programs that allow data to be exchanged on a website without changing the website's display is ___________ .

0-1

A smartphone emits approximately __________ watts of microwaves.

Alpha

A test of new software conducted by the programmers themselves or by contracted evaluators working alongside the programmers is one of the first phases of the testing process in the PDLC. This is referred to as a(n) _________ test.

Debugging

After the code has been written there are nearly always mistakes. The 4th step in the PDLC involves finding and correcting these errors in a process called __________ .

English

After the problem has been clearly defined, the next step in the PDLC is to create the plan or algorithm. This plan is usually written as a flowchart, and is in written in an ordinary language, such as _________.

Settings Icon

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

Synching

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

Programming

Converting a task into commands that a computer can use to perform the task is called ___ .

Extensible Markup Language

Designed to display documents on the web, this version of the HTML set of protocols provides a smooth interface between natural language and machine language by wrapping data in "tags" for web display.

drag

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

Data Administration

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

Signal

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

Title 5

The titles in the DMCA that directly impact digital copyright issues include all of the following except____.

Data Type

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

extreme right of the taskbar

Where is the "Show Desktop" button on Windows 10?

iPhones

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.

Algorithm

Written in natural language and in the form of a flowchart, a programmer uses a(n) ________ to describe the problem the program will solve.

G2B

All of the following are considered e-commerce transactions except____.

Network

All of the following are part of an RFID system except _____.

Instagram is difficult to integrate with apps like Facebook and Foursquare

All of the following statements about Instagram are true except____.

Complex Database

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 _________________.

Large

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.

Peer-to-Peer

BitTorrent utilizes no central server, instead opting to utilize a _____ structure where each device connected to a network has equal access to the shared files.

Field

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

EFT Act

In the United States the federal _____ covers most consumer oriented electronic transactions. EFT Act

Record

In the data sheet view of a relational database (such as Microsoft Access) a row of information is called a ______________.

C++

The coding step of the PDLC might use which of the following languages?

Generation

The level of complexity of the programming language, or the degree from which it is separated from machine language itself, is called the ___________ of the programming language.

Trade

The main governmental organization that oversees Internet privacy is the Federal ___ Commission.

Relational

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

Windows Phone

Though not yet commercially successful, the _________ was developed by one of the world's largest software manufacturers.

right-click

To access an app's Jump List, just __________ on the app's icon in the taskbar.

Macros

Even a small degree of programming skill can be beneficial. Many apps allow you to create mini-programs that reduce the number of routine steps required to complete a task. These mini-programs are called _______ .

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

Select what's true about object-oriented databases

view

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

Forms

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

Start

To uninstall an app from your Windows 10 device a quick way is to first click the ______ .

Object

When inputs can easily be placed into different categories or classes, a(n) ________ -oriented analysis works well.

Foreign Key

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.

.gif

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

SaaS

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

right-click on the start button

Which of the following will open the account management area of Windows 10?

Extension

When you receive a file, you can tell what type it is by its ____________. This is a dot and 3 or more characters after the file's name.

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.

.exe

Which of these extensions, if you open it, will probably install software onto your computer?

Android

Which of these operating systems is based on Linux and used on smartphones?

JSON

Which of these programs make data more readable to programmers by parsing XML files?

iOS

Which of these is found on iPhones and iPads?

File Explorer icon

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 ___ (all Windows versions, on your toolbar) and access the Documents folder from there.