CGS FINAL EXAM

supply chain management software

SCMS makes lean manufacturing processes such as just-in-time inventory practical. SCMS stands for what?

shorter

The _____ the access time, the faster your data will reach your processor.

information systems program manager

The roles of directing IS technicians, working with senior management to procure and implement IS, and developing policies for corporate IS typically falls to Who?

registers, RAM, and caches

Three important types of memory in your computer are?

database

a collection of related data that can be sorted, logically organized, searched, and stored.

distributed

a database that stores data in different physical locations and that users access through client/server networks is what kind of database?

1 terabyte

a thousand gigabytes equals what?

USBs are more durable and have a shorter access time

advantages of using a USB drive instead of a DVD

can hold larger amounts of data and can provide improved data integrity

advantages of using a database

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.

BD-RE

blu-ray discs that can be recorded on multiple times

data integrity

centralized databases ensure what?

operations

decision making software such as MIS

byte

eight bits are considered to make one ____ of information.

cloud

emailing a file to yourself is an example of using what kind of storage?

1. instructing employees on standards 2. enforcing standards by creating firewalls, monitoring protocols, and filters 3. periodically reviewing computer-use policies

employee ethical standards include what three practices

microsoft SQL Server oracle database "a red A"

examples of DBMS software

blu-ray player DVD drive

examples of optical drives

student number social security number

examples of primary keys in a table

byte of data

how much data does a short email use?

primary key

in a relational database, an important field that contains a unique value that identifies each record as individual is the what?

record

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

4 books

items that use approximately 1 megabyte of data

commercial databases

large databases, often called data banks, that cover particular subjects are referred to as what?

database administrator

monitoring database systems performance, developing and maintaining databases, and establishing user privileges for databases are usual roles of a what?

gigabytes or terabytes

most laptops have hard drive capacities measured in what?(2)

honeypots

network intruder detection systems often have areas known as padded cells or _______ that are easy to hack into and are used to catch hackers

marketing

online advertising and using of social media, and search engine optimization

lands

optical discs, such as CDs, store data using pits and ____

Finance

providing current investment values and opportunities

1. compact disc 2. digital versatile disc (single layer) 3. digital versatile disc (double layer) 4. blu-ray disc

rank the following by capacity from smallest to largest: digital versatile disc (single layer) digital versatile disc (double layer) compact disc blu-ray disc

1. byte 2. megabyte 3. gigabyte 4. petabyte

rank these from smallest to largest: gigabyte byte megabyte petabyte

accounting

records keeping and reporting

queries

so that users can find specific info quickly by using filters based on specific criteria, databases allow the creation of what?

remote desktop software

software that gives network administrators the ability to provide computer assistance from a central location by allowing them to display and control any computer on the network.

monitoring

sometimes used in smaller business networks, employee ____ software is impractical for large networks because of the number of users and the potential for misuse.

information system technician

the role of installing maintaining repairing and replacing information system hardware and software typically falls to the who?

bit

the smallest unit of storage is called a what?

bit

the unit of storage that is the data held or processed by a single transistor

reports

to display or distribute info from a database, programmers or database administrators create what?

1. data stored on someone else's server can be accessed by anyone who has administrator privileges to the server 2. data is only available if you are online

two disadvantages of cloud storage

1. used electronic circuits to store data 2. durable, no moving mechanical parts

what are the characteristics of solid state drive storage devices?(2)

query

what do you create to search a database for info?

gigabytes

what kind of data is a laptop computer's memory capacity measured in?

executive support systems

when referring to management information systems, ESS stands for what?

transaction processing systems

when referring to management information systems, TPS stands for what?

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 _______ field in one table that links to the primary key in the other table