Computer Science Study Material for CGS Winston Final Exam

Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful.

integrity

The reliability and the accuracy of the information in a database is referred to as data ________.

integrity

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

Multiple Choice

A. Data Support

B. Data Security

C. Data Management

D. Data Administration

D (Data in the answer)

The DBMS subsystem that allows for data maintenance and data analysis, including providing the capability to create queries, reports, and forms is referred to as the data ________ subsystem.

manipulation or maintenance (look at answer choices.. maintenance for fill in the blank)

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

Multiple Choice

A. logical

B. dynamic

C. integrity

D. physical

A

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

Multiple Choice

A. manager

B. company

C. levels

D. hierarchy

D

Your college has a database with a Students table. Which of the following could be a primary key in the table?

Check All That Apply

A. Student number

B. Social Security Number

C. Street address

D. Last name

A and B

The type of database that uses common fields to create links between tables is called a(n) ________ database.

Multiple Choice

A. multidimensional

B. relational

C. linkage

D. object-oriented

B

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

Multiple Choice

A. forms

B. records

C. tables

D. reports

D

When you need to link two 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.

Multiple Choice

A. false key

B. supplemental

C. foreign key

D. secondary

C

You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In StubHub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ________.

database

Select what's true about database fields.

Check All That Apply

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 and C

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.

Multiple Choice

A. Management

B. Organizing

C. Administration

D. Operating

A (Data NOT in the answer)

The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application ________ subsystem.

generation

Large databases, often called data banks, that cover particular subjects are referred to as ________ databases.

commercial

(An example of a commercial database is LexisNexis.)

In a relational database, an important field that contains a unique value that identifies each record as individual is the ________ key.

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ____

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a(n) ________ key.

primary

record

foreign

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

Multiple Choice

A. Data configuration

B. Data type

C. Data specificity

D. Data mart

B

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

Multiple Choice

A. records

B. forms

C. tables

D. relationships

B

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.

Multiple Choice

A. definition

B. application

C. description

D. output

B

Select what's true about object-oriented databases.

Check All That Apply

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, videos, images, and extremely large files

C. use Object Query Language to construct queries that extract data from the database

D. are commonly referred to as relational databases

A B and C

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

Multiple Choice

A. joint-use

B. commercial

C. structured

D. distributed

D

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

Multiple Choice

A. form

B. report

C. relationship

D. field

D

Match the capacity with the storage device.

1. Typical laptop

2. DVD

3. Typical tablet or smartphone

500 GB-1 TB

16-256 GB

3-5 GB

1. 500 GB-1 TB

2. 3-5 GB

3. 16-256 GB

Select two characteristics of computer storage.

Check All That Apply

A. Connects the CPU to the memory

B. Sometimes referred to as secondary storage

C. Sometimes referred to as volatile memory

D. Retains data when power is turned off

B and D

One thousand kilobytes (KB) equals one ________.

Multiple Choice

A. byte

B. terabyte

C. gigabyte

D. megabyte

D

Blu-rays provide approximately ________ of storage space.

Multiple Choice

A. 50 GB

B. 4.5 GB

C. 700 MB

D. 300 MB

A

Solid state drives store data using ________.

Multiple Choice

A. laser markings

B. electronic circuits

C. magnetically charged particles

D. reflective coatings

B

CDs provide approximately ________ of data storage space.

Multiple Choice

A. 700 MB

B. 300 MB

C. 25 GB

D. 4.5 GB

A

Select two characteristics of a DVD.

Check All That Apply

A. Holds approximately 4.5 GB of data

B. A read/write head senses its magnetic charges

C. Uses pits and lands to store data

D. Uses capacitors and/or transistors to store data

A and C

A storage device that uses lasers to read CDs, DVDs, or Blu-ray discs is referred to as a(n) ________.

Multiple Choice

A. magnetic drive

B. optical drive

C. flash drive

D. external hard drive

B

A thousand gigabytes (GB) equals one ________.

Multiple Choice

A. megabyte

B. terabyte

C. yottabyte

D. petabyte

B

Because of its capability of storing data in multiple hard drives, data warehouses use ________ technology to ensure redundant data storage.

Multiple Choice

A. RAID

B. CPU

C. optical

D. Blu-ray

A

What are two commonly used names for USB drives?

Check All That Apply

A. DVD drives

B. Flash drives

C. Optical drives

D. Thumb drives

B and D

Most desktop computers use ________ to store data.

Multiple Choice

A. CD drives

B. RAM storage

C. magnetic hard drives

D. flash storage

C

Select two disadvantages of using cloud storage.

Check All That Apply

A. Data deteriorates over time.

B. Data is only available if you are online.

C. Data can easily be lost.

D. Data stored on someone else's server can be accessed by anyone who has administrator privileges to the server.

B and D

Though it could theoretically hold terabytes of data for thousands of years in a microscopic space, ________ storage, using genetic material, is a distant storage option.

Multiple Choice

A. optical

B. laser

C. DNA

D. cloud

C

Select two optical drives/Which two of the following are considered storage media.

Check All That Apply

A. USB drive

B. DVD drive

C. Hard disk

D. Blu-ray player

B and D

With regard to digital storage, RAID stands for ________.

Multiple Choice

A. relative access to incremental data

B. redundant array of independent discs

C. rational access to instant data

D. readily accessible identified data

B

The fact that data on servers is nearly always backed up onto other servers gives ________ storage a major advantage over other data storage methods.

Multiple Choice

A. cloud

B. optical

C. internal

D. external

A

Select three characteristics of a traditional hard drive.

Check All That Apply

A. Uses lasers to read data

B. Has a read/write head to detect magnetic charges

C. Has physically spinning platters

D. Uses magnetic charges to store data

B C and D

Which two could be used to store a single bit of data?

Check All That Apply

A. An e-mail

B. A hole in a punch card

C. A transistor

D. A program

B and C

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ________.

Multiple Choice

A. record

B. list

C. field

D. table

A

The cell tower's base transmission station is connected to a mobile ________ station.

Multiple Choice

A. data

B. transmission

C. switching

D. processing

C

Select the Amazon tablets.

Check All That Apply

A. Fire HD

B. Fire Kids

C. Kindle Paperwhite

D. Nexus Pro

A and B

Which of these devices are manufactured by Samsung?

Check All That Apply

A. Galaxy

B. Note

C. Lumia

D. Optimus F3

A and B

Amazon offers two lines of tablet computers: the Amazon Fire and the Amazon Fire ________.

Multiple Choice

A. Note

B. Pro Series

C. Pad

D. HDX

D

Select the cell phone manufacturers.

Check All That Apply

A. LG Electronics

B. Lenovo

C. Huawei

D. Oracle

A B and C

Select the functions of a Digital Signal Processor.

Check All That Apply

A. Analyzes signals received from the analog-digital converter to enhance audio quality.

B. Reduces unwanted noise

C. Moderates call volume.

D. Encrypts phone signal.

A B and C

Select the functions of a mobile switching station.

Check All That Apply

A. Assigns frequencies to your calls.

B. Sends your call to the receiver's MSS.

C. Changes the cell and base station your transmissions go through as you travel.

D. Assigns MAC addresses.

A B and C

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

Multiple Choice

A. microSD storage

B. cellular connectivity

C. Blu-ray storage

D. a traditional hard drive

A

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

Multiple Choice

A. OSX

B. Android

C. Windows 10

D. iOS 9

B

Select the advantages of a 5G phone.

Check All That Apply

A. more energy efficient—battery lasts longer

B. less expensive

C. faster connection/data transfer speeds

D. lower latency

C and D

Sometimes, particularly when traveling, 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 ________.

Multiple Choice

A. surfing

B. piggybacking

C. drifting

D. roaming

D

Select the names of Android operating systems.

Check All That Apply

A. Pie

B. Oreo

C. Android 11.0

D. OS X

A B and C

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

Multiple Choice

A. tethering

B. piggybacking

C. syncing

D. hitchhiking

A

Match the following regarding file compression:

1. Lossless

2. Lossy

3. Zip

reduces space required by reducing redundancy within files

a lossless compression format

reduces space required by removing less valuable data

1. reduces space required by reducing redundancy within files

2. reduces space required by removing less valuable data

3. a lossless compression format

Select the characteristics of a Blu-ray disc.

Check All That Apply

A. Holds approximately 50 GB of data

B. Uses capacitors and/or transistors to store data.

C. A read/write head senses the magnetic charges

D. Uses pits and lands to store data

A and D

DVDs/CDs store data using ________.

Multiple Choice

A. a magnetic coating that is sensed by a read/write head

B. a blue spectrum laser beam

C. a reflective coating that has pits and lands

D. electronic circuits

C

Using refracted laser light to store data on a photoreceptive substrate is essentially how ________ storage works. Theoretically this could store gigabytes of data within a cubic millimeter.

Multiple Choice

A. optical

B. holographic

C. flash

D. cloud

B

Select two reasons to compress a file.

Check All That Apply

A. Reduce the number of files required to store movies

B. Reduce bandwidth needed to transmit a file

C. Reduce storage space requirements

D. Reduce the memory needed to view a video file

B and C

Select three characteristics of SSD storage.

Check All That Apply

A. Uses magnetically charged particles to store data

B. Uses the same technology that is found in USB drives

C. Has no mechanically moving parts

D. Uses flash technology

B C and D

There are several ways to rename a folder in Windows. Which of these would work?

Check All That Apply

A. On the command bar, click Organize and then click Rename.

B. Click the folder icon and press F2 to activate the edit mode.

C. Right-click a folder and click Rename.

D. Double-click on the title bar. Click New and then click Folder.

A B and C

The interfaces for the logical view of a database and the physical view of a database are provided by the DBMS ________.

engine

If copyrighted software is illegally copied, distributed, modified or sold and is regarded as a direct infringement of copyright, this is called ________.

Multiple Choice

A. hardware theft

B. software borrowing

C. software piracy

D. application fraud

C

All of the following are true about RFID except

Multiple Choice

A. RFID stands for Radio Frequency Identification.

B. RFID can be used to identify a variety of objects including chip-implanted objects, and animals.

C. RFID doesn't require line-of-sight scanning.

D. RFID uses infrared transmissions.

Select three RFID characteristics.

Check All That Apply

A. RFID stands for Radio Frequency Identification.

B. RFID can be used to identify a variety of objects including objects, and animals implanted with an active RFID chip.

C. High-frequency RFID can transmit signals further than 1500 feet. H

D. RFID does not require line-of-sight scanning.

D

A B and D

In professional messages, avoid the use of emoticons and ________.

Multiple Choice

A. contact information

B. capital letters

C. acronyms

D. smiley faces

C

The capacity of a particular transmission medium is called its ________.

Multiple Choice

A. throughput

B. latency

C. bandwidth

D. band strength

C

Software that limits the material that a browser fetches or that a search engine displays are called ________.

Multiple Choice

A. plug-ins

B. filters

C. controllers

D. browsers

B

Choose the reasons for purchasing broadband Internet service.

Check All That Apply

A. You have several devices online at the same time.

B. You need relatively high-speed Internet service.

C. You want Wi-Fi in your home.

D. You want to save money over a dial-up connection.

A B and C

Select the advantages of using a USB drive instead of a DVD.

Check All That Apply

A. USB drive has shorter access time.

B. USB drive is less expensive.

C. USB drive is more durable.

D. USB drive is more accurate.

A and C

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

Multiple Choice

A. primary Key

B. table

C. report

D. field

B

If you have two folders open on your desktop and you want to copy a file from one folder to the other, hold down ________ and drag the file.

Multiple Choice

A. CTRL

B. TAB

C. SHIFT

D. ALT

A

Select the characteristics of a Base Transceiver Station.

Check All That Apply

A. connected to a cell tower

B. broadcasts weak microwave signals to create "cells" of mobile coverage

C. sends phone signals to the cellular provider's Mobile Switching Station (MSS)

D. sends phone signals to the recipient's Mobile Switching Station (MSS)

A B and C

In addition to activating ________ protection, it's a good idea to disable your router's SSID transmission once all your devices are connected.

Multiple Choice

A. WEP

B. WPA2

C. ping

D. modem

B

A switch distinguishes between various devices within a network by their ________ addresses.

Multiple Choice

A. BUS

B. IP

C. MCA

D. MAC

D

Your ________ can provide hardware firewall protection for your home network where it connects to the ISP's network, just as ISP networks have firewalls where they connect to the Internet.

Multiple Choice

A. router

B. switch

C. FSB

D. modem

A

Broadband is measured in ________.

Multiple Choice

A. Mbps

B. Kbps

C. Tbps

D. Gbps

A

What technology enables business-oriented transactions and information to be communicated electronically between people and organizations?

Multiple Choice

A. CAD

B. RFID

C. CPU

D. EDI

D

(Electronic data interchange)

A digital identity includes a number of digital attributes including which three of the following?

Check All That Apply

A. usernames and passwords

B. the spreadsheet program you use most often

C. personal data such as your social security number and birth date

D. online search activities

A C and D

RFID chips are found in many important items such as (select two):

Check All That Apply

A. wired earphones.

B. credit cards.

C. coins.

D. passports.

B and D

(Radio Frequency IDENTIFICATION)

The Federal ________ Commission is the main government organization that oversees Internet privacy.

Multiple Choice

A. Internet

B. Trade

C. Ethernet

D. World Wide Web

B

One category of E-commerce includes ________.

Multiple Choice

A. B2I (Business to Internet)

B. C2B (Consumer to Business)

C. B2B (Business to Business)

D. C2G (Consumer to Government)

C

(commerce=selling/trading, The three categories of E-commerce include B2C (Business to Consumer), C2C (Consumer to Consumer), and B2B (Business to Business).)

Select three advantages of helium hard drives over traditional hard drives.

Check All That Apply

A. Platters spin faster.

B. Lasers can read platters more accurately through helium.

C. Platters stay cooler.

D. More platters can be placed in the same amount of space.

A C and D

Select two characteristics of solid state drive storage devices.

Check All That Apply

A. Durable, no moving mechanical parts

B. Uses laser to read data

C. Uses electronic circuits to store data

D. Uses magnetic charges to store data

A and C

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?

Check All That Apply

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 and B

Select the common word processing file extensions.

Check All That Apply

A. .odf

B. .docx

C. .avi

D. .xls

A and B

The two major concerns regarding cloud storage are reliability and ________.

Multiple Choice

A. security

B. speed

C. cost

D. freedom

A

Select the reasons to purchase a prepaid phone.

Check All That Apply

A. no long-term contracts

B. useful if you just need a phone for calling or texting

C. useful if you just need a phone for emergencies

D. less expensive for video streaming

A B and C

The Internet service that tends to provide the most consistent speeds is ________.

Multiple Choice

A. DSL

B. cellular Internet

C. cable Internet

D. dial-up Internet

A

Select the statements that are true regarding a Wi-Fi's SSID.

Check All That Apply

A. An SSID is the Wi-Fi's name.

B. Most routers transmit the SSID every few seconds so roaming devices can find the signal.

C. In home networks, after all legitimate devices have connected to the SSID once, transmitting the SSID is unnecessary.

D. Once an SSID has been established it cannot be changed.

A B and C

Select the statements that are true regarding cable Internet service.

Check All That Apply

A. uses the same twisted pair line that brings the telephone signal

B. uses the same coaxial cable that brings the cable television signal

C. usually has more bandwidth than DSL lines

D. Internet service can often be bundled with television service.

B C and D

Match the item with its function.

1. Router

2. MAC address

3. Switch

4. Modem

connects two networks

identifies a device within a network

converts analog signals into digital signals and digital signals into analog signals

connects devices within a network

1. connects two networks

2. identifies a device within a network

3. connects devices within a network

4. converts analog signals into digital signals and digital signals into analog signals

Select the statements that are true regarding Fiber-Optic Internet service.

Check All That Apply

A. fastest home network option when available

B. not available in all areas

C. Fiber-optic cable typically goes into the home.

D. Signal is carried by light waves so it is less subject to electromagnetic interference.

A B and D

Twitter recommends that no more than ________ hashtags should be used per Tweet.

2

Viber is a messaging app similar to WhatsApp, but focuses on ________.

Multiple Choice

A. software downloading

B. video exchanging

C. Internet phone calling

D. photo sharing

C

The DMCA titles that directly affect digital copyright issues include all except

Multiple Choice

A. Title 5–Copyright Protection Proviso.

B. Title 3–Computer Maintenance Competition Assurance.

C. Title 1–WIPO Copyright and Phonograms Treaties and Implementation Act.

D. Title 2–Online Copyright Infringement Liability Limitation.

A

Select two characteristics of a traditional hard drive.

Check All That Apply

A. Uses magnetically charged plates to store data

B. Reads data with lasers

C. Uses solid state electronic circuitry to store data

D. Often found in desktop computers

A and D

Select the video file compression formats.

Check All That Apply

A. AVI

B. MP4

C. QuickTime

D. MP3

A B and C

An electronic element that stores data by changing its resistance based on the current that has passed through it (similar to RRAM) is called a(n) ________.

Multiple Choice

A. memristor

B. pixel

C. capacitor

D. transistor

A

The component of a computer that allows data to be retained after power is turned off is referred to as ________.

Multiple Choice

A. storage

B. CPU

C. processor

D. RAM

A