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