CGS2060 Final Final Final
To select a folder, simply put your cursor on it and ___.
Click
To adjust your Windows computer's display settings, it's often easiest to go to the ___ panel.
Control
To adjust your Windows computer's time and date settings, it's often easiest to go to the ___ panel.
Control
The digital personal assistant that comes with Microsoft's Windows 10 is called ___ .
Cortana
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
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 program that makes creating websites and webpages much faster is ___ .
JavaScript
To look for a file or folder in Windows 10, just type the file name in the __ box.
Search
Which of the following file extensions is commonly used for term papers and other word processing tasks?
.docx
Which of these extensions, if you open it, will probably install software onto your computer? Be careful!
.exe
Select what's true about database fields: A. A group of related characters in a database B. Represents a characteristic of someone or something. C. Primary key is a field designation D. A field is a row in a table
A, B, C
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
Where can you type your question to search for files, folders, and apps in Windows 10, along with searching the web and interacting with Cortana?
Ask Me Anything window
A program that takes an entire program, check the source code for errors, and converts it into machine language is a ___ .
Compiler
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
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data Type
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
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
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
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
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
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
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
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
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database.
Multidimensional
To listen to an .mp4 (M4A) file, you'll need an app such as iTunes or QuickTime. These apps are called audio ___ .
Players
To watch an .mpeg file, you'll need an app such as Windows Media Player or QuickTime. These apps are called video ___ .
Players
Converting a task into commands that a computer can use to perform the task is called ___ .
Programming
To personalize your desktop in Windows 10, just put your cursor on any open area of the desktop, ___ and select "Personalize".
Right-click
To uninstall an app from your Windows 10 device a quick way is to first click the ___ .
Start
A collection of related records in a database is referred to as a _____.
Table
Where is the "Show Desktop" button on Windows 10?
The extreme right of the taskbar
HTML and it's 5th revision (HTML5) allow content to be displayed on ___ .
the World Wide Web
Which of the following file extensions is commonly used for drawings?
.gif
If you see the extension .xlsx, you know that you are looking at a(n) ___ file.
Excel
A graphic representation of a process is called a ___ .
Flowchart
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 control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.
Forms
To search a database for information, create a ___.
Query
Which of the following refers to the distribution of computer applications over the Internet and is commonly referred to as web apps?
SaaS
If you want to save a file to a particular folder or site on your computer (such as the Documents folder or your desktop), be sure to click File and then select ___ in the File menu.
Save As
The two major concerns regarding cloud storage are reliability and ___ .
Security
Want to get rid of one of the app's on your Windows 10 taskbar? It's easy! First ___ the app's icon, then click "Unpin this app".
Right-click
Select the advantages of using a database instead of a traditional filing system: A. A database can hold larger amounts of data B. A database can provide better data integrity C. A database can never be hacked D. Using a relational database, such as MS Access, is so easy that it requires no instruction
A, B
To display or distribute information from a database, programmers or database administrators create ___ .
Reports
Microsoft recommends when that you create passwords with upper and lower case letters, numbers, symbols, and use at least ___ characters.
8
The coding step of the PDLC might use which of the following languages? A. C++ B. English C. Russian D. Spanish
A
Which of these programs make data more readable to programmers by parsing XML files? A. JSON B. C# C. Dreamweaver D. JavaScript
A
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 ___ .
English
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.
Extension
A quick way to rename files or folders in Windows is to select the item and then press the ___ key.
F2
In a database a _____ is a group of related characters in a database table that represents a characteristic of someone or something.
Field
An efficient way to manage your files in Windows 10 is to use the _____.
File Explorer
If you plan to write software for PC games you should probably learn C or ___ .
C++
If it can be answered as either yes or no, or true or false, the question is called ___ .
Binary
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .
Record
To access an app's Jump List, just ___ on the app's icon in the taskbar.
Right-click
To create a reminder in Windows 10, click Cortana, then select the light bulb, and then click the ___ sign.
plus
Which of the following will open the account management area of Windows 10? A. Hold down Ctrl+Alt+Delete and then click the Start button B. Right-click File Explorer and then select account C. Right-click the Start button D. Double-click the Start button
C
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 + C
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
The DBMS engine provides an interface for the end user of the database. This interface is called the ___ view.
Logical
Adding an application's tile to the Start menu in Windows 10 is called ___ the app.
Pinning
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
To select a paragraph in a word processing program is usually as easy as ___ the left mouse button.
Triple-clicking
Removing an application's tile from the Start menu in Windows 10 is called ___ the app.
Unpinning
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.
Shift
A set of programs that allow data to be exchanged on a website without changing the website's display is ___ .
AJAX
An object-oriented programming language that is popular for writing apps for Android phones and tablets is ___ .
Java
Another term for a programming code is a programming ___ .
Language
Writing software follows a 5-step process called the PDLC. PDLC stands for the Program ___ Life Cycle.
Development
Defining the problem is the ___ step in the Program Development Life Cycle.
First
The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data? A. What field name will the data fall under B. What data type will be included C. What database manufacturer is used D. When was the database created
A, B
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ___ subsystem.
Data Administration
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
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
Select the program that uses small programs called scripts to speed the programming process while creating dynamic Web pages.
JavaScript
The standard code of respectful behavior governing the use of electronic communications software and hardware is called electronic etiquette or _____.
Netiquette
When inputs can easily be placed into different categories or classes, a(n) ___ -oriented analysis works well.
Object
To type on a touchscreen device with Windows 10, enable the ______.
On-screen keyboard
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 ___.
Organize
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
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.
Alpha
To change the size of your folder's icon, just right-click on a blank area of the contents pane and click ___ .
View
In order to download an app from the Microsoft Store will need to ___ .
be logged into a Microsoft account
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 ___.
Jump List
Instructions (software) that allow a computer (hardware) to be used are written using specific symbols, letters and numbers known as a programming ___ or code.
Language
When you open the Windows 10 start menu, colorful boxes containing constantly updated (when you're online) information appears. Microsoft calls these boxes ___ .
Live Tiles
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
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
If you accidentally delete a file it's not lost forever! Just go to your recycle bin, select the item, and click ___ .
Restore
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
An easy way to rename a folder in Windows is to ___ -click on the folder and then click Rename.
Right-click
The most common method of renaming files and folders is to simply __ on the item and select Rename.
Right-click
To open the shortcut menu inside the Documents folder, just ___ in any open area of the Documents window.
Right-click
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 As
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.
Settings