Looking for INF 202 Database Management Systems 1 (Meruyert Raiymbekova) test answers and solutions? Browse our comprehensive collection of verified answers for INF 202 Database Management Systems 1 (Meruyert Raiymbekova) at moodle.sdu.edu.kz.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
SELECT PName FROM Products WHERE Price IS NULL OR Price > 1000 OR Price < 1000;
Which product names will be returned? (Choose all that apply)
PName | Price |
iPhone 4 | 750 |
iPad 2 | 1500 |
Milestone | NULL |
EOS 550D | 1200 |
Which is the correct statement to modify columns of existing SQL tables?
Builds a relation from two specified relations, consisting of all possible concatenated pairs of tuples, one from each of the two relations.
If ___, then A -> B has non-trivial functional dependency.
Drop Table cannot be used to drop a table referenced by a _________ constraint.
The SUM() function returns :
If you delete data from the Category table that has a DELETE trigger on it, what happens to the data when the trigger fires?
While operating with strings, what does “_ _ _%” match with?
When a table contains only one candidate key, _____ are considered to be equivalent.
If a directed arrow (→) points from the relationship set advisor to both entity sets instructor and student, what type of cardinality does this represent?