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.
How much did new investments grow in Q2 of FY25 compared to Q1, as per recent data?
Which ministry launched the PM E-DRIVE Scheme?
Match the following mountain ranges in India with their respective locations in the southern direction:
1. Nanda Devi
2. K2
3. Anamudi
4. Dodabetta
The Reserve Bank of India imposed a penalty of ₹1 crore on which bank for offering gifts in the form of paying first-year life insurance premiums?
The "loom" was a central technological innovation during which era?
 Birju Maharaj is related to which of the following fields?
ICICI Bank was constituted as first Universal Bank in India
The headquarters of the West Central Railway is situated in which city?
Which of the following is NOT a petrochemical centre of India?
Which of the following is not a solvency ratio?