In relational database management, which of the following is/are property/properties of candidate key? P : Uniqueness Q : Irreducibility
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: C. Both P and Q
Explanation
A candidate key must be unique and irreducible (minimal).
More Database Management Systems questions
- Which of the following statements are DML statements? (a) Update [tablename] = Set [ columnname] VALUE (b) Delete [tablename] (c) Select *…
- Hadoop (a big data tool) works with number of related tools. Choose from the following, the common tools included into Hadoop :
- A table has attributes Employee_id (primary key) and Manager_id (foreign key referencing Employee_id with ON DELETE CASCADE), with tuples (…
- An attribute A of datatype varchar(20) has the value 'xyz', and the attribute B of datatype char(20) has the value 'lmnop'. Then attribute…
- Data warehouse contains _____ data that is never found in the operational environment.
- _____command is used to remove a relation from an SQL database.