CSCI Exam 2 Review

Question 1

SQL query

Answer 1

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

Question 2

router

Answer 2

move info from divide to internet and internet to device

Question 3

switch

Answer 3

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

Question 4

NIC

Answer 4

network interface card: basically the HARDWARE responsible for connecting computer to internet

Question 5

Wifi

Answer 5

technology that allows device to connect to the internet by connecting to a wireless router

Question 6

Fastest cable that transmits media?

Answer 6

6a

Question 7

Slowest cable that transmits media?

Answer 7

5

Question 8

LAN

Answer 8

local area network: connected via direct connection or over wifi

Question 9

WAN

Answer 9

wide area network: (worldwide) multiple LAM communicating with each other

Question 10

What is the 802.11 standard used for?

Answer 10

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

Question 11

lpconfig

Answer 11

viewing and changing internet connection settings

Question 12

ping

Answer 12

sends short message to another computer and measures how much time it took to receive a response

Question 13

netstat

Answer 13

shows current connections your computer has to other computers

Question 14

tracert

Answer 14

sends messages and shoes how many hops is between your computer and other computers

Question 15

download

Answer 15

from internet to computer

Question 16

upload

Answer 16

from computer to internet

Question 17

3 things a network protocol should define about messages being sent between computers

Answer 17

Format of messages
Order of messages
Actions taken on the transmission or receipt of message

Question 18

ARP

Answer 18

Address Resolution Protocol

How machines find the physical machine that data is coming from or going to by linking IP addresses to actual machines

Question 19

MAC address

Answer 19

physical address of individual device (stored on NIC)

Question 20

TCP

Answer 20

breaks message into packets (TCP segments) and delivers
slower but reliable transfer
typical applications:email, web browsing
transfer layer

Question 21

UDP

Answer 21

fast but non-guaranteed transfer (best effort)
typical applications:VoIP
music streaming
transfer layer

Question 22

collision

Answer 22

can occur when 2 stations transmit at the same time

it is thrown out and then resent

Question 23

physical networking layer

Answer 23

sends data across the network through router

Question 24

VoIP

Answer 24

voice over internet protocol: fully digital phone service

SKYPE

Question 25

what are some top level domains

Answer 25

.com, .org, .net, .gov, .edu

Question 26

HTTP

Answer 26

hypertext transfer protocol: allows files to be transferred from a web server so that you can see them on your computer from a browser

Question 27

SMS

Answer 27

short message service: texting

Question 28

MMS

Answer 28

multimedia message service: can include text, sound, images, and video clips to other phones or emails

Question 29

GPS

Answer 29

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

Question 30

digital convergence

Answer 30

single unifying device

media, internet, entertainment, and telephony needs

Question 31

example of digital convergence

Answer 31

smartphones

Question 32

digital signal

Answer 32

electrical signal that translates info into binary.

Question 33

analog signal

Answer 33

electrical signal where info is translated into electric pulses of varying amplitude; continuous

Question 34

what hardware can capture an image and convert it to digital signal

Answer 34

digital camera

Question 35

most popular type of database used throughout the world

Answer 35

relational databases; microsoft access

Question 36

data mining

Answer 36

process where great amounts of data are analyzed and investigates

objective is to spot significant patterns and trends that would not be obvious

Question 37

function of SQL verb Union

Answer 37

combines rows from 2 tables

SELECT name, email FROM students UNION SELECT name, email FROM teachers

Question 38

primary key

Answer 38

unique for each record; only one primary key in relational databases

Question 39

foreign key

Answer 39

foreign key in one table points to primary key in another

Question 40

what does it mean to normalize a table in a relational database

Answer 40

remove duplicate data

Question 41

HTML tag

Answer 41

controls formatting and display

only see text outside of tags

Question 42

CSS

Answer 42

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

Question 43

what is wrong w this:

Select * from employee where id=’5’

Answer 43

No quotes needed around 5

Question 44

what is wrong w this: Select employee from * where id=5

Answer 44

Should be Select * from employee

Question 45

what is wrong w this: Select * from employee where name=Zoey

Answer 45

’ ‘ need to be around Zoey

Question 46

what is wrong w this: Select * from employee where name=’Zoey’ or ‘Gracie’

Answer 46

Should be “name=’Zoey’ or name=’Gracie’