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.
What is the Mediation Fund under The Mediation Act, 2023?
Which of the following is not provided under S.89 of CPC?
Which of the following sections of the Act, waives the proof of judicial admissions_____.
Before the industrial disputes act was implemented in the year 1947, which act took care of the industrial disputes?
What is the liability of abettor when one act is abetted and different act is done?
Under section 6 of the Prevention of Corruption Act, 1988 the Special judges can pass a sentence of imprisonment for a term not exceeding _________year
Which section of Payment of Gratuity Act, 1972 deals with the determination of the amount of ‘Gratuity’?
A company shall have at least one director who stays in India for a total period of not less than one hundred and eighty-two days ______________
“No person shall be compelled to be a witness against himself” is a ?
A contract to do an act which, after the contract is made, becomes impossible, or, by reason of some event which the promisor could not prevent, unlawfu...