100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
CIS2750 Exam Questions With Correct Answers 100% Guaranteed Pass. $10.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. CIS2750
  4.  
  5. CIS2750

Exam (elaborations)

CIS2750 Exam Questions With Correct Answers 100% Guaranteed Pass.
 0 purchase
  • Course
  • CIS2750
  • Institution
  • CIS2750

CIS2750 Exam Questions With Correct Answers 100% Guaranteed Pass. What does the SQL join operation do - Answerselect data from two or more tables by conceptually joining tables by a common column cross join - Answeroperates like the cartesian product, two tables are multiplied together to a ne...

[Show more]

Preview 2 out of 5  pages

Document information

  • January 16, 2025
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers

Subjects

  • cis2750 exam questions with correct answers 100 g

Written for

  • CIS2750
  • CIS2750

Seller

avatar-seller
TheStar

Reviews received

Content preview

CIS2750 Exam Questions With Correct
Answers 100% Guaranteed Pass.


What does the SQL join operation do - Answer✔select data from two or more tables by
conceptually joining tables by a common column
cross join - Answer✔operates like the cartesian product, two tables are multiplied together to a
new table
inner join - Answer✔tables are combined based on a common column (we used this)
outer join - Answer✔combining all rows of one table with only the matching rows of another
table
self join - Answer✔a table is joined to itself, key word that is used is as

what operator represents joins - Answer✔equals sign
aliasing in sql - Answer✔creating queries with shorter table names by aliasing the table name to
an abbreviation
three types of outer joins - Answer✔left, right, and full

view in SQL - Answer✔a view is a virtual table, that does not really exist but appears to the user
as it did
base tables in SQL - Answer✔real tables that actually exist and require storage

when can views be updated - Answer✔only when they are a simple row and column subset of a
base table they cannot be a join
flaws of sql - Answer✔strictly declarative, limited data types, redundant, negative effects
what sql lacks - Answer✔time varying tables

why is interface design important - Answer✔interface can be the only contact user has with the
system
conceptual model - Answer✔system designer's way of representing the system to the user
what advances enabled the shift from user interfaces to graphical user interfaces -
Answer✔cheap RAM, Success of raster graphics, fast and cheap CPUs

1|Page

, characteristics of a GUI - Answer✔graphical, objects, actions

characteristics of direct manipulation systems - Answer✔system is portrayed as an extension of
the real world, there is continuous visibility of objects and actions, actions are rapid and
incremental with visible display of results, incremental actions are reversible
characteristics of indirect manipulation systems - Answer✔uses words and text (typing instead of
pointing)
advantages of GUIs - Answer✔symbols: easy to recognize, learn, and aid in problem solving
errors can be prevented because not allowed through input,
reduces need for typing skills,
immediate feedback allows for better conceptual model,
more attractive then other interfaces
disadvantages of GUIs - Answer✔complexity increases, learning time, design guidelines,
inconsistency in techniques and terminologies, symbols and graphics are not always expressive
as language, development of new icons is expensive, guis can be inefficient
3 types of GUI objects - Answer✔data objects (represent information), container objects (hold
other objects), device objects (physical objects in the real world)
characteristics of GUI objects - Answer✔attributes define characteristics, objects can be acted on
or manipulated
GUI views - Answer✔way of looking at an object

4 types of GUI views - Answer✔composed (present information and objects contained in an
object), contents (list components of objects), settings (permit manipulation of object attributes),
help (provide help functions)
principles of GUI design - Answer✔aesthetically pleasing, realistic looking metaphors, clarity,
compatibility, comprehensibility, configurability, consistency, control, directness, efficiency,
familiarity, flexibility, forgiveness, predictability, recovery, responsiveness, simplicity,
transparency
overview of the design process - Answer✔understand, involve, perform, modify and iterate,
integrate
HTML - Answer✔hyper text markup language, scripting language that describes how the page is
laid out
HTTP - Answer✔Hypertext transfer protocol - communications framework to navigate
webservers and pages




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)

70713 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

Recently viewed by you

Summary ·

(0)

Duidelijke samenvatting Ontwerp van Overtuigende Teksten (OOT) CIW

Exam (elaborations) ·

(0)

NCLEX-PN TESTBANK (SOLVED QUESTIONS AND ANSWERS UPDATED 2023 MAY.

Exam (elaborations) ·

(0)

Chapter 1: Introduction To USPAP With Complete Solutions 100% 2024

Package deal ·

(0)

International Trade 1e John McLaren (Instructor Manual with Test Bank)

Exam (elaborations) ·

(0)

AACVRP CCRP Exam Questions with Correct Answers |VERIFIED |UPDATED!!!!
$10.49
  • (0)
Add to cart
Added