CSCI Exam 2 Review Flashcards
SQL query
SELECT: used to clarify which column or row to display from the table
FROM: tables you want to pull from
WHERE: , =, OR, AND
ORDER by ASC or DESC
router
move info from divide to internet and internet to device
switch
box that takes one wireless plug and splits it into many outlets (internet powerbar) and makes sure that each connected device gets the right about of bandwidth (internet) smart internet splitter
NIC
network interface card: basically the HARDWARE responsible for connecting computer to internet
Wifi
technology that allows device to connect to the internet by connecting to a wireless router
Fastest cable that transmits media?
6a
Slowest cable that transmits media?
5
LAN
local area network: connected via direct connection or over wifi
WAN
wide area network: (worldwide) multiple LAM communicating with each other
What is the 802.11 standard used for?
guides how wifi and plan works
makes sure no channels overlap and each new version reduces interference from things (microwaves, bluetooth)
standard for wifi and plan
lpconfig
viewing and changing internet connection settings
ping
sends short message to another computer and measures how much time it took to receive a response
netstat
shows current connections your computer has to other computers
tracert
sends messages and shoes how many hops is between your computer and other computers
download
from internet to computer
upload
from computer to internet
3 things a network protocol should define about messages being sent between computers
Format of messages
Order of messages
Actions taken on the transmission or receipt of message
ARP
Address Resolution Protocol
How machines find the physical machine that data is coming from or going to by linking IP addresses to actual machines
MAC address
physical address of individual device (stored on NIC)
TCP
breaks message into packets (TCP segments) and delivers
slower but reliable transfer
typical applications:email, web browsing
transfer layer
UDP
fast but non-guaranteed transfer (best effort)
typical applications:VoIP
music streaming
transfer layer
collision
can occur when 2 stations transmit at the same time
it is thrown out and then resent
physical networking layer
sends data across the network through router
VoIP
voice over internet protocol: fully digital phone service
SKYPE
what are some top level domains
.com, .org, .net, .gov, .edu
HTTP
hypertext transfer protocol: allows files to be transferred from a web server so that you can see them on your computer from a browser
SMS
short message service: texting
MMS
multimedia message service: can include text, sound, images, and video clips to other phones or emails
GPS
global positioning system: 21 satellites built and operated by US military that constantly orbit Earth
satellites provide information to GPS-capabele devices to pinpoint locations on the earth
digital convergence
single unifying device
media, internet, entertainment, and telephony needs
example of digital convergence
smartphones
digital signal
electrical signal that translates info into binary.
analog signal
electrical signal where info is translated into electric pulses of varying amplitude; continuous
what hardware can capture an image and convert it to digital signal
digital camera
most popular type of database used throughout the world
relational databases; microsoft access
data mining
process where great amounts of data are analyzed and investigates
objective is to spot significant patterns and trends that would not be obvious
function of SQL verb Union
combines rows from 2 tables
SELECT name, email FROM students UNION SELECT name, email FROM teachers
primary key
unique for each record; only one primary key in relational databases
foreign key
foreign key in one table points to primary key in another
what does it mean to normalize a table in a relational database
remove duplicate data
HTML tag
controls formatting and display
only see text outside of tags
CSS
controls formatting and display
how elements are to be displayed on screen
saves a lot of work and controls layout of multiple web pages all at once
what is wrong w this:
Select * from employee where id=’5’
No quotes needed around 5
what is wrong w this: Select employee from * where id=5
Should be Select * from employee
what is wrong w this: Select * from employee where name=Zoey
’ ‘ need to be around Zoey
what is wrong w this: Select * from employee where name=’Zoey’ or ‘Gracie’
Should be “name=’Zoey’ or name=’Gracie’
