Loading…
Loading…
Q1. A primary key must be
Q2. Indexing every column in a heavily-written table is unwise because
Q3. A foreign key is a column that
Q4. A many-to-many relationship between Students and Subjects is implemented with
Q5. List ALL customers with their orders if any exist. You need
Q6. Filtering groups by an aggregate (COUNT, AVG) requires
Q7. Storing 'maths, physics, art' in one subject cell violates
Q8. ProductName depends only on ProductID inside a composite-key table. This is
Q9. An order row pointing to a customer who was deleted breaks
Q10. In a bank transfer, debit and credit must both complete or neither. This is