100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
CIS2750 Exam Study Guide 100% Guaranteed Pass. $10.49
Add to cart

Exam (elaborations)

CIS2750 Exam Study Guide 100% Guaranteed Pass.

 0 purchase
  • Course
  • CIS2750
  • Institution
  • CIS2750

CIS2750 Exam Study Guide 100% Guaranteed Pass. Scripting Languages - AnswerGenerally Interpreted instead of compiled. This allows for rapid development and change due to immediate execution. Byte Code - AnswerSource Code that has been converted to an intermediate, similar to compilation. Execu...

[Show more]

Preview 2 out of 9  pages

  • January 17, 2025
  • 9
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • CIS2750
  • CIS2750
avatar-seller
TheStar
©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

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller TheStar. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $10.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

70073 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling
$10.49
  • (0)
Add to cart
Added