©THESTAR 2024/2025 ALL RIGHTS RESERVED.
CIS2750 Exam Study Guide 100%
Guaranteed Pass.
Scripting Languages - Answer✔Generally Interpreted instead of compiled. This allows for rapid
development and change due to immediate execution.
Byte Code - Answer✔Source Code that has been converted to an intermediate, similar to
compilation. Executed by an interpreter which improves performance over purely interpreted
systems.
Extending - Answer✔Utilizing external programs and libraries to increase the functionality of
the language by binding existing programs to it.
Dynamic Typing - Answer✔System manages the types of variables without the programmer
explicitly stating the length or type of declaration.
Lists - Answer✔Ordered Collections of other objects that are accessed using an index.
Dictionaries - Answer✔Unordered collections of objects that are accessed using a key.
Tuples - Answer✔Immutable lists.
immutable1 = immutable2 - Answer✔Creates a copy of the tuple
mutable1 = mutable2 - Answer✔Creates a second variable that references the list
The Protocol Stack - Answer✔1. Communication Protocols
2. Built on top of each-other
3. Lowest Levels communicate bytes/packets between computers
4. Higher levels give fault tolerance
5. Highest levels are application specific
HTTP - Answer✔Hypertext Transfer Protocol
TCP - Answer✔Transmission Control Protocol
What does TCP do? - Answer✔Adds reliability, ordering, and error checking
1|Page
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED.
IP - Answer✔Internet Protocol
Relays Datagrams across networks
Routing Functionality
Basis of the internet
UDP - Answer✔User Datagram Protocol
Doesn't include reliability
Faster
Used for Gaming
When was HTTP/1, HTTP/2, and HTTP/3 published? - Answer✔1996, 2015, 2022 (Also
switched from QUIC to TCP in 2022)
Four Basic SQL Operations - Answer✔Select, Insert, Update, Delete
What are the 6 data types for SQL? - Answer✔Integer, Smallint, Decimal, Char, Varchar, Date
SQL: DESC - Answer✔When used in combination with "ORDER BY", creates an ordering in
descending order.
Aggregate Functions in SQL? - Answer✔COUNT, SUM, AVG, MAX, MIN
CROSS JOIN - Answer✔Multiplies the two tables into a new virtual table.
INNER JOIN - Answer✔Tables are combined based on a common column they share
OUTER JOIN - Answer✔Combines all rows of one table with only MATCHING rows from the
other table. Used to include rows that are missing (unmatched) in an inner join.
SELF JOIN - Answer✔Table joined to itself
LEFT OUTER JOIN - Answer✔( *= ) All rows from of left side of the join will be included. For
Example MoleculeAtom *= MoleculeBonds. All rows from MoleculeAtom will be included.
RIGHT OUTER JOIN - Answer✔(=* ) All rows from the right side of the join will be included.
For Example MoleculeAtom =* MoleculeBonds. All rows from MoleculeBonds will be included
FULL OUTER JOIN - Answer✔Ensures that all rows from both sides of the join will be
included.
SQL: VIEW - Answer✔A virtual table that does not actually exist but appears to the user as if it
did. Views can be used for security by hiding sensitive data from unauthorized users.
2|Page
CIS2750 Exam Study Guide 100%
Guaranteed Pass.
Scripting Languages - Answer✔Generally Interpreted instead of compiled. This allows for rapid
development and change due to immediate execution.
Byte Code - Answer✔Source Code that has been converted to an intermediate, similar to
compilation. Executed by an interpreter which improves performance over purely interpreted
systems.
Extending - Answer✔Utilizing external programs and libraries to increase the functionality of
the language by binding existing programs to it.
Dynamic Typing - Answer✔System manages the types of variables without the programmer
explicitly stating the length or type of declaration.
Lists - Answer✔Ordered Collections of other objects that are accessed using an index.
Dictionaries - Answer✔Unordered collections of objects that are accessed using a key.
Tuples - Answer✔Immutable lists.
immutable1 = immutable2 - Answer✔Creates a copy of the tuple
mutable1 = mutable2 - Answer✔Creates a second variable that references the list
The Protocol Stack - Answer✔1. Communication Protocols
2. Built on top of each-other
3. Lowest Levels communicate bytes/packets between computers
4. Higher levels give fault tolerance
5. Highest levels are application specific
HTTP - Answer✔Hypertext Transfer Protocol
TCP - Answer✔Transmission Control Protocol
What does TCP do? - Answer✔Adds reliability, ordering, and error checking
1|Page
, ©THESTAR 2024/2025 ALL RIGHTS RESERVED.
IP - Answer✔Internet Protocol
Relays Datagrams across networks
Routing Functionality
Basis of the internet
UDP - Answer✔User Datagram Protocol
Doesn't include reliability
Faster
Used for Gaming
When was HTTP/1, HTTP/2, and HTTP/3 published? - Answer✔1996, 2015, 2022 (Also
switched from QUIC to TCP in 2022)
Four Basic SQL Operations - Answer✔Select, Insert, Update, Delete
What are the 6 data types for SQL? - Answer✔Integer, Smallint, Decimal, Char, Varchar, Date
SQL: DESC - Answer✔When used in combination with "ORDER BY", creates an ordering in
descending order.
Aggregate Functions in SQL? - Answer✔COUNT, SUM, AVG, MAX, MIN
CROSS JOIN - Answer✔Multiplies the two tables into a new virtual table.
INNER JOIN - Answer✔Tables are combined based on a common column they share
OUTER JOIN - Answer✔Combines all rows of one table with only MATCHING rows from the
other table. Used to include rows that are missing (unmatched) in an inner join.
SELF JOIN - Answer✔Table joined to itself
LEFT OUTER JOIN - Answer✔( *= ) All rows from of left side of the join will be included. For
Example MoleculeAtom *= MoleculeBonds. All rows from MoleculeAtom will be included.
RIGHT OUTER JOIN - Answer✔(=* ) All rows from the right side of the join will be included.
For Example MoleculeAtom =* MoleculeBonds. All rows from MoleculeBonds will be included
FULL OUTER JOIN - Answer✔Ensures that all rows from both sides of the join will be
included.
SQL: VIEW - Answer✔A virtual table that does not actually exist but appears to the user as if it
did. Views can be used for security by hiding sensitive data from unauthorized users.
2|Page
