CGS 2060 Final Exam Review

Select the advantages of using a database instead of traditional filing system. - A database can hold larger amounts of data - A database can provide better data integrity - A database can never be hacked - Using a relational database, such as MS Access, is so easy that it requires no instruction

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

A smartphone emits approximately _____ watts of microwaves. - 10-15 - 20-50 - 2-5 - 0-1

0-1

If you just need a phone for calling and texting, a _____ phone can save you money. - Windows - 4G - 3G - LTE

3G

Two major categories of cell phones are available. Smartphones with LTE or 4G capability and _____ phones. - flip - Internet - 3G - Blackberry

3G

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

7

A set of programs that allow data to be exchanged on a website without changing the website's display is _____. - AJAX - Java - Swift - HTML

AJAX

Which of these operating systems is based on Linux and used on smartphones? - Windows 10 - Android - iOS 9 - OSX

Android

With its iPhone, _____ dominates the U.S. smartphone market. - LG - Nokia - Apple - Samsung

Apple

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. - Output - Definition - Description - Application

Application

If you plan to write software for PC games you should learn C or _____. - C++ - Javascript - BASIC - HTML5

C++

The coding step of the PDLC might use which of the following languages? - C++ - English - Russian - Spanish

C++

If you have 2 folders open on your desktop and you want to copy a file form one folder to the other, hold down _____ and drag the file. - CTRL - SHIFT - ALT - TAB

CTRL

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 _____. - CTRL + V - CTRL + P - SHIFT + X - ALT + B

CTRL + V

To remove a file form 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 - CTRL + C - CTRL + F - CTRL + R

CTRL + X

The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the _____ subsystem. - Data Administration - Data Management - Data Security - Data Support

Data Administration

What element of a database field specifies the data in a field such as text, numeric, or date/time? - Data Type - Data Configuration - Data Mart - Data Specifcity

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 - File cabinet - Spreadsheet - Infomart

Database

An integral part of database management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data _____. - Structure - Reference - Dictionary - Encyclopedia

Dictionary

A database that stores data in different physical locations and that users access through client/server networks is called a _____ database. - Distributed - Joint-use - Commerical - Structered

Distributed

A quick way to rename files or folders in Windows is to select the item and then press the _____ key. - F2 - ALT - R - CTRL

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 there. - Filer Explorer - Internet Explorer - Microsoft Edge - Control Panel

Filer Explorer

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 - False key - Supplemental - Secondary

Foreign key

To control how information is entered into a database, programmers and database administrators create _____ to help ensure data integrity. - Forms - Tables - Records - Relationships

Forms

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 - Levels - Manager - Company

Hierarchy

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 _____. - Authentication - Reliability - Integrity - Accuracy

Integrity

Which of these programs make data more readable to programmers by parsing XML files? - JSON - C# - Dreamweaver - JavaScript

JSON

An object-oriented programming language that is popular for writing apps for Android phones and tablets is _____. - Java - HTML5 - C# - C

Java

A program that makes creating websites and webpages much faster is _____. - JavaScript - Cocoa - Swift - C#

JavaScript

Select the program that uses small programs called scripts to speed the programming process while creating dynamic Web pages. - JavaScript - Dreamweaver - Swift - BASIC

JavaScript

The DBMS engine provides an interface for the end user of the database. This interface is called the _____ view. - Integrity - Logical - Dynamic - Physical

Logical

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. - Operating - Organizing - Management - Administration

Management

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 - Dictionary - Output - Definition

Manipulation

A complex database that organizes and stores information in a cube format and has measure attributes and features attributes is called a _____ database. - Object-oriented - Relational - Time-based - Multidimensional

Multidimensional

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, then go to the command bar and click _____. - Restore the selected items - New folder - Organize - Restore this item

Organize

The type of database that uses common fields to create links between tables is called a _____ database. - Relational - Linkage - Multi-dimensional - Object-oriented

Relational

A link between tables in a relational database that defines how the data is related is called a _____. - Link - Relationship - Join - Partnership

Relationship

Which of the following refers to the distribution of computer applications over the Internet and is commonly referred to as web apps? - MaaS - SaaS - IaaS - PaaS

SaaS

Though not yet commercially successful, the _____ was developed by one of the world's largest software manufacturers. - iPhone 6S - iPhone 5S - Samsung Galaxy - Windows Phone

Samsung Galaxy

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 - Documents - Desktop - Save As

Save As

To look for a file or folder in Windows 10, just type the file name in the _____ box. - Finder - Documents - Command - Search

Search

Since it comes with a full computer operating system, some consider ______ a laptop computer rather than a tablet computer. - Fire HDX - Galaxy Pad - Surface Pro 4 - iPad Pro

Surface Pro 4

A collection of related records in a database is referred to as a _____. - Report - Field - Table - Primary Key

Table

To change the size of your folder's icon, just right-click on a blank area of the contents pane and click _____. - Resize - View - Properties - Enlarge

View

Written in natural language and in the form of a flowchart, a programmer uses a(n) _____ to describe the problem the program will solve. - algorithm - calculation - Javascript - CPU

algorithm

A test of new software conducted by the programmers themselves or by contracted evaluator 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. - alpha - beta - midterm - sampling

alpha

If it can be answered as either yes or no, or true or false, the question is called _____. - binary - executed - programmed - coded

binary

To select a folder, simply put your cursor on it and _____. - double-click - right-click - click - scroll right

click

A program that takes an entire program, check the source code for errors, and converts it into machine language is a _____. - compiler - translator - C++ - JavaScript

compiler

If you wish to email a friend, but find that it's too big for your email server, you can always _____ the file. - defrag - expand - compress - format

compress

Being able to surf the web, watch videos, and listen to streaming audio is why service with a _____ plan is extremely popular in the U.S. - data - Internet - roaming - mobile

data

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 _____. - debugging - cleaning - sweeping - quarantining

debugging

Defining the problem is the _____ step in the Program Development Life Cycle. - second - final - third - first

first

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. - generation - syntax - code - progress

generation

Which of these is found on iPhones and iPads? - OS X - iOS - Blackberry - Android

iOS

While many 3rd party apps are available hough its App Store, apps for _____ must first be tested and approved before they're made available for downloading. - Android phones - Windows phones - Blackberry phones - iPhones

iPhones

In order to sync your iPhone to your MacBook you must first open the _____ app. - iTunes - App Store - settings - Safari

iTunes

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# _____. - interpreter - compiler - translator - executor

interpreter

Another term for a programming code is a programming ______. - language - process - identifier - macro

language

Instructions (software) that allow a computer (hardware) to be used are written using specific symbols, letters and numbers know as programming _____ or code. - language - syntax - development - category

language

Because of the large infrastructure cost of building antennae and mobile switching stations, as well as leasing the rights to use radio frequency, only _____ companies can compete nationally as cell phone providers. - partnership - large - sole propietorship - small

large

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_____. - macros - miniapps - subprograms - fun-sized

macros

If you just need a phone for emergencies, you might consider a _____ phone. - Wi-Fi - Internet - prepaid - 911

prepaid

Converting a task into commands that a computer can use to preform the task is called _____. - programming - navigating - editing - compiling

programming

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. - swipe - right-click - click - double-click

right-click

Sometimes, particularly when travlling, you may find yourself in an area where your home network has no cell coverage, but another network does have service. Using a different network is referred to as _____. - roaming - drifting - surfing - piggybacking

roaming

The two major concerns regarding cloud storage are reliability and _____. - freedom - cost - speed - security

security

Select what's true about database fields - A group of related characters in a database - Represents a characteristic of someone or something - Primary key is a field designation - A field is a row in a table

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

The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which if the following elements will be used to describe the data? - What field name will that data fall under - What data type will be included - What database manufacturer is used - When was the database created

- What field name will that data fall under - What data type will be included

Which of the following file extensions is commonly used for term papers and other word processing tasks? - .docx - .mp4 - .xls - .avi

.docx

Which of these extensions, if you open it, will probably install software onto your computer? Be careful! - .xlsx - .html - .exe - .jpeg

.exe

Which of the following file extensions is commonly used for drawings? - .avi - .mp4 - .gif - .xls

.gif

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 - Spreadsheets - Lists - Amazon.com

Databases

Writing software follows a 5-step precess called the PDLC. PDLC stand for the Program _____ Life Cycle. - Development - Determination - Drive - Disc

Development

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 flow chart, and is in written in an ordinary language, such as _____. - English - Java - C++ - Javascript

English

If you see the extension .xlsx, you know that you are looking at a(n) _____ file. - Excel - Access - PowerPoint - Webage

Excel

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. - Extensible Markup Language - JavaScript(Js) - C++ - Swift

Extensible Markup Language

In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something. - Form - Relationship - Field - Report

Field

To search a database for information, create a _____. - Query - Form - Report - Field

Query

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a _____. - Record - List - Field - Table

Record

To display or distribute information form a database, programmers or database administrators create _____. - Records - Tables - Reports - Forms

Reports

If you accidentally delete a file it's not lost forever! Just go to your recycle bin, select the item, and click _____. - Restore - Remove - Recycle - Activate

Restore

The devices inside your phone that convert analog waves (such as sound waves) into digital signals that your phone can process are called _____. - digital - analog converters - modulated to digital converters - CMOS chips - IR recievers

digital - analog converters

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 - click - right-click - scroll over

double-click

A graphic representation of a process is called a _____. - flowchart - program - procedure - brain storm

flowchart

In order to keep your files organized, it's a good idea to create _____ and place your files in them. - databases - spreadsheets - libaries - folders

folders

The largest category of apps, both in terms of active downloads and in terms of revenue generated is _____. - game apps - educational apps - lifestyle apps - business apps

game apps

To watch an .mpeg file, you'll need an app such as Windows Media Player or QuickTime. These apps are called video _____. - controllers - players - panels - instruments

players

An easy way to rename a folder in Windows in to _____ -click on the folder and then click Rename. - click - double-click - right-click - left-swipe

right-click

The most common method of renaming files and folders is to simply _____ on the item and select Rename. - right-click - click - hover - swipe

right-click

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. - settings - hourglass - magnifying glass - App Store

settings

The small computer within your phone that enhances the sound quality of your call is called a digital _____ processor. - modulated - demodulated - binary - signal

signal

Adding a microSD card (when possible) increases your phone's _____ capacity. - processing - storage - RAM - CPU

storage

Connecting your phone to your laptop to transfer photos, videos, or music files is referred to as _____. - pinging - syncing - tethering - piggybacking

syncing

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 _____. - piggybacking - hitchhiking - syncying - tethering

tethering

Ironically, the expenses for calling and _____ are among the smallest charges found on a cell phone bill. - texting - web surfing - conferencing - streaming

texting

HTML and it's 5th revision (HTML5) allow content to be displayed on _____. - the World Wide Web - desktops - PC games - The Pirate Bay

the World Wide Web

Some apps that use a surprising amount of data are those that include embedded ______. - cookies - video - audio - images

video

One advantage that the Samsung tablets have over the iPads is that you can add _____ to the Note or Tab. - Blu-ray storage - a traditional hard drive - microSD storage - cellular connectivity

microSD storage

When inputs can easily be placed into different categories or classes, a(n) _____ -oriented analysis works well. - object - planning - access - problem

object

To listen to an .mp4 (M4A) file, you'll need an app such as iTunes or QuickTime. These apps are called audio _____. - players - speakers - controllers - panels

players