CIS2750 Exam Questions with Complete
Solutions (Latest 2025)
what does the SQL join operation do - Correct Answers
✅select data from two or more tables by conceptually joining
tables by a common column
cross join - Correct Answers ✅operates like the cartesian
product, two tables are multiplied together to a new table
inner join - Correct Answers ✅tables are combined based
on a common column (we used this)
outer join - Correct Answers ✅combining all rows of one
table with only the matching rows of another table
self join - Correct Answers ✅a table is joined to itself, key
word that is used is as
what operator represents joins - Correct Answers ✅equals
sign
aliasing in sql - Correct Answers ✅creating queries with
shorter table names by aliasing the table name to an
abbreviation
three types of outer joins - Correct Answers ✅left, right,
and full
, CIS2750 Exam Questions with Complete
Solutions (Latest 2025)
view in SQL - Correct Answers ✅a view is a virtual table,
that does not really exist but appears to the user as it did
base tables in SQL - Correct Answers ✅real tables that
actually exist and require storage
when can views be updated - Correct Answers ✅only when
they are a simple row and column subset of a base table they
cannot be a join
flaws of sql - Correct Answers ✅strictly declarative, limited
data types, redundant, negative effects
what sql lacks - Correct Answers ✅time varying tables
why is interface design important - Correct Answers
✅interface can be the only contact user has with the system
conceptual model - Correct Answers ✅system designer's
way of representing the system to the user
what advances enabled the shift from user interfaces to
graphical user interfaces - Correct Answers ✅cheap RAM,
Success of raster graphics, fast and cheap CPUs
Solutions (Latest 2025)
what does the SQL join operation do - Correct Answers
✅select data from two or more tables by conceptually joining
tables by a common column
cross join - Correct Answers ✅operates like the cartesian
product, two tables are multiplied together to a new table
inner join - Correct Answers ✅tables are combined based
on a common column (we used this)
outer join - Correct Answers ✅combining all rows of one
table with only the matching rows of another table
self join - Correct Answers ✅a table is joined to itself, key
word that is used is as
what operator represents joins - Correct Answers ✅equals
sign
aliasing in sql - Correct Answers ✅creating queries with
shorter table names by aliasing the table name to an
abbreviation
three types of outer joins - Correct Answers ✅left, right,
and full
, CIS2750 Exam Questions with Complete
Solutions (Latest 2025)
view in SQL - Correct Answers ✅a view is a virtual table,
that does not really exist but appears to the user as it did
base tables in SQL - Correct Answers ✅real tables that
actually exist and require storage
when can views be updated - Correct Answers ✅only when
they are a simple row and column subset of a base table they
cannot be a join
flaws of sql - Correct Answers ✅strictly declarative, limited
data types, redundant, negative effects
what sql lacks - Correct Answers ✅time varying tables
why is interface design important - Correct Answers
✅interface can be the only contact user has with the system
conceptual model - Correct Answers ✅system designer's
way of representing the system to the user
what advances enabled the shift from user interfaces to
graphical user interfaces - Correct Answers ✅cheap RAM,
Success of raster graphics, fast and cheap CPUs
