CGS 2060 Final

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

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

Distributed

Which of these devices are manufactured by Samsung?

Galaxy Note

Select the email services.

Gmail Outlook iCloud

Amazon offers 2 lines of tablet computers, the Amazon Fire and the Amazon Fire ___ .

HDX

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

The mobile switching station can connect calls to mobile switching stations belonging to other cellular networks.

TRUE

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?

What field name will the data fall under What data type will be included

Though not yet commercially successful, the ___ was developed by one of the world's largest software manufacturers.

Windows Phone

Select the reasons why you might want to add a microSD card to your smartphone.

You want to save more music files. You want to save more image files (photos).

The smallest unit of data storage is a ___ .

bit

Intrusion Detection Systems (IDS) use several techniques to protect networks. One is called a "halt", which stops the hacker from progressing into the network. Another is called a(n) ___, which closes the access point used by the hacker.

block

Select the common Internet transmission media.

coaxial cable telephone wire cell phone radio waves

Select the characteristics of a Base Transceiver Station

connected to a cell tower broadcasts weak microwave signals to create "cells" of mobile coverage sends phone signals to the cellular provider's Mobile Switching Station (MSS)

Errors in data occurring while entering, reading, processing, storing or transmitting is known as data ___.

corruption

Collecting data, interpreting information gleaned from a database, and preparing reports for senior management are tasks that are typically assigned to a ___ .

data analyst

Monitoring database systems performance, developing and maintaining databases, and establishing user privileges for databases are usual roles of a ___ .

database administrator (DBA)

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

Select the storage devices.

external hard drives USB drives

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

filters

When referring to digital storage, RAID stands for ___ .

redundant array of independent discs

Select the characteristics of a OneDrive account

requires a Microsoft Email account provides free cloud storage can serve as extra storage space

Select the characteristics of computer storage.

retains data when power is turned off sometimes referred to as secondary storage

Sometimes, particularly when travelling, 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

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

storage

Visiting pornography sites while using a company computer and/or network violates your company's computer-use policy. You've signed a policy that requires you to report any computer ethics violations to your boss. You observe a co-worker visiting porn sites at work and determine that you should report this activity. Other co-workers also noticed this violation. You should

tell your boss that you've witnessed the co-worker visiting porn sites while using the company computer or network.

What are some commonly used names for USB drives?

thumb drives flash drives

Using information systems to help foresee corporate business opportunities and threats might be done by all levels of management, but it is most important for which management level?

top level managers

Because of the popularity and bandwidth demands of video streaming, ___ data plans are not as common as they were in the past.

unlimited

Select the characteristics of a traditional hard drive.

uses magnetic charges to store data has a read/write head to detect magnetic charges has physically moving platters

Which of the following file extensions is commonly used for term papers and other word processing tasks?

.docx

To search a database for information, create a ___ .

Query

Select the audio file compression formats.

WAV MP4

Server banks have capacities measured in ___ .

petabytes

A form of Email fraud where criminals change the account where money is being transferred is called a ___ scam.

wire-wire

Which of these extensions, if you open it, will probably install software onto your computer? Be careful!

.exe

Most new cell phones today come with approximately ___ of RAM.

500 MB - 2 GB

A tablet is a highly-mobile computer with a mobile operating system and a touchscreen rather than a keyboard/touchpad. To differentiate a tablet from a smartphone, a tablet is generally understood to have a screensize of at least ___ inches.

7

CDs provide approximately ___ of data storage space.

700 MB

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

Business owners, copyright holders, and network administrators publish ___ so that users understand what is expected and permissible when they use the network, computer equipment, and/or software.

AUPs

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

Android

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

Select the cell phone manufacturers.

Blackberry Xiaomi Huawei

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.

CTRL

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.

DNA

Which of the following are considered storage media?

DVDs Blu-ray discs

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

Business management software that encompasses nearly all business activities in a corporation is called ___ software.

ERP

Which of these should business owners do to help protect their data.

Establish strong firewall protection for their business's network. Ensure antivirus software is installed and up-to-date. Create strong password protections and protocols.

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

Select the usual roles of information systems (IS) technicians.

Installing IS hardware and software. Maintaining IS hardware and software. Repairing and replacing IS hardware and software.

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

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

Logical

The 2 most common audio file formats are WAV and ___ .

MP4

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

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

Because it locates cellular devices, assigns frequencies, transmits signals to the correct sites, the ___ is probably the most important part of any cellular network.

Mobile Switching Station (MSS)

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ___ database.

Multidimensional

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

On the command bar, click Organize and then click Rename. Click the folder icon and press F2 to activate the edit mode. Right-click a folder and click Rename.

You own a pet care center. what fields might you enter when you create a table for dogs that you care for?

Owner's last name Pet's name Owner's address

The type of database that uses common fields to create links between tables is called a ___ database.

Relational

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

Reports

Which category of management information systems (MIS) combines the forecasting capability of decision support software with the records keeping capability of transaction processing systems software to help businesses manage inventories efficiently?

SCMS

Because they have no mechanically moving parts, ___ provide extremely fast, efficient storage.

SSDs

To look for a file or folder in Windows 10, just type the file name in the __ box.

Search

Select what's true about object-oriented databases.

Store instructions for how to compute the data as well as the data to be processed Equipped to handle unstructured data such as MP4 files, video, images, and extremely large files Use Object Query Language to construct queries that extract data from the database

Select the usual tasks of information systems (IS) program managers.

Supervising IS technicians. Working with developers and senior management to procure and implement IS processes. Developing training plans and policies for IS.

Examples of management information systems (MIS) include _____ .

TPS DSS ESS

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

Table

Which would be used to store a single bit of data?

a transistor a hole in a punch card

What 3 items are needed to install a home WiFi network?

an Internet signal a modem a router

In order to change sound waves into digital signals, smartphones contain ___ - digital converter.

analog

Select the functions of a Digital Signal Processor

analyzes signals received from the analog-digital converter to enhance audio quality reduces unwanted noise moderates call volume

Cell towers are connected to ___ .

base transceiver stations

When reporting a computer ethics violation of a co-worker to your employer, it's important to ______.

be brief and direct state only what you witnessed

The largest category of apps, both in terms of active downloads and in terms of revenue generated is ___ .

game apps

Select the characteristics of a Blu-ray disc.

holds approximately 25 GB of data uses pits and lands to store data

A refracted laser beam striking a photoreceptor from many different angles allows ___ storage to retain many bits of data in the same location.

holographic

Match the operating system with it's characteristic: iOS 9 series Marshmallow Lollipop

iOS 9 series- Used on iPhones Marshmallow- Android OS released in 2015 Lollipop- Android OS released in 2014

Apple's mobile device with the largest display is the ___ .

iPad Pro

In order to sync your iPhone to your MacBook you must first open the ___ app.

iTunes

In the body of a professionally formatted business email, where should a request be placed?

in the first sentence of the body of your email

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.

large

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

microSD storage

Cell phones send and receive extremely weak ___ signals to and from cell towers.

microwave

Select the usual tasks of database administrators (DBAs).

monitors the database's performance develops and maintains the database itself establishes user privileges for the database to help protect the data

Though legal, which of the following would likely be prohibited by a typical business computer-use policy?

online personal shopping

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

optical drive

Select the characteristics of a traditional hard drive.

uses magnetically charged plates to store data commonly found in desktop computers

Some apps that use a surprising amount of data are those that include embedded ___ .

video