WGU C182

WGU C182

Leave the first rating Students also studied Terms in this set (57) Science Computer Science Save

SQL Chapter 4: Data Manipulation (...

• terms

Caleb_REICH8Preview R — Core Functions, Data Structures,...26 terms Daniel_Aguilar748 Preview ISYS 284 Final Exam Study Guide 147 terms Codythongsavanh Preview Ch 1 W 23 terms tf20 Practice questions for this set Learn1 / 7Study using Learn Allow user to monitor system performance.Application SoftwarePrograms end users run to accomplish tasks.Productivity SoftwareApplication software used to aid in productivity. I.E. Presentation software, word processor, spreadsheets.Internet Usage SoftwareEmail, FTP client, web browser Choose an answer 1Utility Programs2Application Software 3Services (Daemons)4Server Software Don't know?

System SoftwareConsists of programs that make up the OS and directly support system itself.**Includes services or DAEMONS Server SoftwareWorks with hardware to provide network service.Local ApplicationSoftware stored on an individual computer.IntranetA LAN that uses IP. Used to communicate within organization.Cloud ComputingAllows organization to access resources/app anywhere, anytime. Beneficial because an org. may access resources it may not normally have.Operating SystemsAllows a user to easily access hardware/software, required to maintain computer environment.KernelCore component of OS.Loads when computer first boots Sits on top of hardware, is interface b/w hardware and software.Device DriversInterface b/w OS and hardware.ShellInterface for user, often personalized. The shell provides access to the kernel.I.E. The GUI will translate mouse motions into calls to kernel/routines. Desktop elements include shortcuts, windows theme, menus, background.Services (Daemons)OS programs that start when OS is loaded. They run in the background and wait for an event to initiate.Utility ProgramsAllow user to monitor system performance.Web ServerRole is to respond to HTTP requests.*Most HTTP requests are for HTML docs, but could include any web accessible resource.It's all combined into the URL.**APACHE is most popular web server-can execute scripts for dynamic pages, use security mechanisms, log request for trend tracking.Proxy ServerActs as a giant cache and allows pages accessed frequently in an organization to be accessed locally.*Also provides degree of anonymity, since IP address recorded is for proxy server and not individual client.*Can also be used to block requests to certain servers (i.e Facebook) *Can reject responses that contain certain content (i.e "porn") **SQUID is most common, but APACHE can also be used as proxy server.Database ServerPermits dB access across a network.Performs tasks such as data analysis, data manipulation, security,and archiving.May/may not store database itself.**MySQL is popular.

FTP ServerHosts files and allows clients access to files.Access is in form of uploading/downloading files.Requires either user has an account or logs in as anonymous user.File ServerComputer with large hard disk storing files, but can also store software to be run over network.Email ServerProvides email service.Accepts email request from clients.

IMAP,POPS,HTTP,MAPI,MIME

String DataAlphanumeric or text

Ex: James (Last name)

623 Hill Street Number IntegerNumeric data, whole numbers.

Ex: 4

Floating PointDecimal.

Ex: 4.2

Date/TimeType of Data Boolean/LogicalType of Data.

Ex: True/False (in reply to active subscriber?)

Only two possible answers: yes/no or true/false

Flat File DatabaseOne large single table without relations between tables.*Most common is CSV file (files separated by comma) *Flat file is used if amount of data is fairly small.

Ex: Spreadsheet

Relational DatabaseMost common structure for database.*Distinguished by multiple tables with interrelated fields.*When queried, data can be pulled form any # of relations that may be contained in multiple databases.*Provides lots of flexibility.Hierarchical DatabaseOrganizes data by using tree-like or organizational chart type structure.*Main data points can have multiple sub-data points (Parent/child structure)- Subpoints can only have one main data point.

• Records can be broken up so one portion is in one location and another is in

another section.Ex: Employee database could list all employees, but a child relation could contain info about employee position, pay level, responsibilities. Another child relation could include info about employee projects. Sub data is always specific to main data point.TuplesRecords represented by rows.

Unshielded Twisted Pair (UTP)Most commonly used network connections. Looks just as it sounds, wires twisted together in a pair.Fiber Optic CableTransmits via light pulses as opposed to electromagnetic ones.Twisted PairNetwork connection commonly used in the past. It is still seen a lot today because it was used extensively in the phone systems. Is cheap and and already in place.**transmits using electromagnetic waves.Coaxial CableCommonly used network connection.*Transmits using electromagnetic waves.BandwidthTransfer rate permissible over the media, and is described as bps or b/s (bits per second).**Modern bandwidth is described in millions/billions bits per second (i.e. Mbps or Gbps) *Older tech limited to thousands, (i.e. 56 Kbps) Network HubDevice that connects multiple computers together.*Broadcasts to all connected devices, even if message is intended for just one.Network SwitchDevice that connects multiple computers together.**Able to broadcast to just one if message is intended for one, but has ability to send message to all if needed.RouterUsed to connect multiple networks together.**Has decision making abilities, can purposefully drop messages if message traffic exceeds capacity. In the event multiple messages are sent, router can make the decision to determine which message is sent first.TransmissionLast step network performs when sending a message.ReceptionFirst step when network receives message.Circuit Switch NetworkRequires full pathway (or circuit) to be established and maintained during entire submission.

Ex: Phone network b/c path exists during entire conversation and communication

can be both ways.Packet Switch NetworkMessage pathway established as it's sent. The choice of the pathway is determined by network availability.

Ex: Message traffic.

Peer to PeerWorkstation in which each computer is equal to another.*Cheaper than other types of servers and workstations.Client-ServerClient is computer that will request info from another computer (the server) .The server takes requests and responds.*More expensive than peer to peer.

BENEFITS: More storage=faster response time.