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.