8/22/25, 7:45 AM CIS2750 Exam | Complete Exam Questions and CORRECT Answers| (2025 update) Assured success| grade A+ Flashcards | Quizlet
CIS2750 Exam | Complete Exam Questions and
CORRECT Answers| (2025 update) Assured
success| grade A+
Save
Practice questions for this set
Learn 1 /7 Study with Learn
Terms in this set (76)
what does the SQL join select data from two or more tables by conceptually
operation do joining tables by a common column
operates like the cartesian product, two tables are
cross join
multiplied together to a new table
tables are combined based on a common column (we
inner join
used this)
combining all rows of one table with only the
outer join
matching rows of another table
https://quizlet.com/1067505585/cis2750-exam-complete-exam-questions-and-correct-answers-2025-update-assured-success-grade-a-flash-cards/ 1/8
, 8/22/25, 7:45 AM CIS2750 Exam | Complete Exam Questions and CORRECT Answers| (2025 update) Assured success| grade A+ Flashcards | Quizlet
self join a table is joined to itself, key word that is used is as
what operator represents equals sign
joins
creating queries with shorter table names by aliasing
aliasing in sql
the table name to an abbreviation
three types of outer joins left, right, and full
a view is a virtual table, that does not really exist but
view in SQL
appears to the user as it did
base tables in SQL real tables that actually exist and require storage
when can views be only when they are a simple row and column subset
updated of a base table they cannot be a join
strictly declarative, limited data types, redundant,
flaws of sql
negative effects
what sql lacks time varying tables
why is interface design interface can be the only contact user has with the
important system
system designer's way of representing the system to
conceptual model
the user
what advances enabled cheap RAM, Success of raster graphics, fast and
the shift from user cheap CPUs
interfaces to graphical
user interfaces
characteristics of a GUI graphical, objects, actions
system is portrayed as an extension of the real world,
characteristics of direct there is continuous visibility of objects and actions,
manipulation systems actions are rapid and incremental with visible display
of results, incremental actions are reversible
characteristics of indirect uses words and text (typing instead of pointing)
manipulation systems
https://quizlet.com/1067505585/cis2750-exam-complete-exam-questions-and-correct-answers-2025-update-assured-success-grade-a-flash-cards/ 2/8
CIS2750 Exam | Complete Exam Questions and
CORRECT Answers| (2025 update) Assured
success| grade A+
Save
Practice questions for this set
Learn 1 /7 Study with Learn
Terms in this set (76)
what does the SQL join select data from two or more tables by conceptually
operation do joining tables by a common column
operates like the cartesian product, two tables are
cross join
multiplied together to a new table
tables are combined based on a common column (we
inner join
used this)
combining all rows of one table with only the
outer join
matching rows of another table
https://quizlet.com/1067505585/cis2750-exam-complete-exam-questions-and-correct-answers-2025-update-assured-success-grade-a-flash-cards/ 1/8
, 8/22/25, 7:45 AM CIS2750 Exam | Complete Exam Questions and CORRECT Answers| (2025 update) Assured success| grade A+ Flashcards | Quizlet
self join a table is joined to itself, key word that is used is as
what operator represents equals sign
joins
creating queries with shorter table names by aliasing
aliasing in sql
the table name to an abbreviation
three types of outer joins left, right, and full
a view is a virtual table, that does not really exist but
view in SQL
appears to the user as it did
base tables in SQL real tables that actually exist and require storage
when can views be only when they are a simple row and column subset
updated of a base table they cannot be a join
strictly declarative, limited data types, redundant,
flaws of sql
negative effects
what sql lacks time varying tables
why is interface design interface can be the only contact user has with the
important system
system designer's way of representing the system to
conceptual model
the user
what advances enabled cheap RAM, Success of raster graphics, fast and
the shift from user cheap CPUs
interfaces to graphical
user interfaces
characteristics of a GUI graphical, objects, actions
system is portrayed as an extension of the real world,
characteristics of direct there is continuous visibility of objects and actions,
manipulation systems actions are rapid and incremental with visible display
of results, incremental actions are reversible
characteristics of indirect uses words and text (typing instead of pointing)
manipulation systems
https://quizlet.com/1067505585/cis2750-exam-complete-exam-questions-and-correct-answers-2025-update-assured-success-grade-a-flash-cards/ 2/8
