Question
Which type of database key is a candidate key that has
not been chosen as the primary key?Solution
An Alternate Key is any candidate key that is not selected as the primary key of the table. Candidate keys are attributes (or combinations of attributes) that uniquely identify a row in a table. Among these, one is chosen as the primary key, while others are considered alternate keys. For example, in a table of students, both StudentID and Email might uniquely identify records. If StudentID is the primary key, Email becomes an alternate key. Alternate keys are useful for additional indexing or as foreign keys in related tables. Why Other Options Are Incorrect :
- Foreign Key : A foreign key establishes a relationship between two tables, linking a column to the primary key in another table.
- Composite Key : A composite key is made of two or more columns together acting as a primary key.
- Surrogate Key : This is a system-generated unique identifier for a row, not derived from application data.
- Super Key : A super key is a broader set of attributes that can uniquely identify a row, which may contain unnecessary attributes.
To help passengers track their lost belongings, the Western Railway has launched a service called 'Mission ___________.'
Who was the first Indian woman to win the Miss World title?
Recently Sivan passed away. Who was he?
Choose a hot water lake from the following:
The Minister of Fisheries, Animal Husbandry and Dairying Parshottam Rupala attended India's first ever “Animal Health Summit 2022” that was ...
Of which of the following who was the first ever industrialist to get the Bharat Ratna?
Which of the following statements are true regarding the Perfect Competition market structure?
1. All firms in a perfectly competitive market sel...
Which ocean contains the Java Trench, the deepest point in its basin?
Who was recently awarded the Sakharov Prize for Freedom of Thought in 2024?
In which state is Fort Madikeri located?