7. Which statement about candidate keys is true?
- A candidate key is a minimal super key
- A relation can have only one candidate key
- Candidate keys may contain null values freely
- A foreign key is always a candidate key of its own relation
जवाब देखें
जवाब: A candidate key is a minimal super key
Candidate keys are super keys with no redundant attributes; a relation may have several.
पाठ: Relations, Keys and Integrity Constraints
9. Why can a column alias defined in SELECT not be used in the WHERE clause?
- Aliases are not allowed in SQL
- WHERE only accepts numbers
- WHERE is evaluated logically before SELECT computes the aliased columns
- Aliases are only valid in GROUP BY
जवाब देखें
जवाब: WHERE is evaluated logically before SELECT computes the aliased columns
Logical processing order is FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
पाठ: SQL Essentials for Fundamentals