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 1 / 2
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
- / 2