← All topics
Quiz: Keys and Constraints: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. A minimal super key is called a:
- Q2. How many primary keys can a table have?
- Q3. Which is true about a foreign key?
- Q4. Which constraint stops a salary of -500 from being inserted?
- Q5. Candidate keys that are not chosen as the primary key are called:
- Q6. Which statement is always true?
- Q7. Deleting an order must automatically delete its order items. Which foreign key option does this?
- Q8. Which is a difference between a primary key and a unique key?
- Q9. In enrollments(rollno, coursecode) the primary key is (rollno, coursecode). What kind of key is it?
- Q10. An INSERT gives no value for a column declared city VARCHAR(30) DEFAULT 'Jaipur'. What is stored?