CIS2750 Exam Guide With
Complete Solution
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
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,
Complete Solution
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
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,
