DBMS%20Interview%20Questions%20and%20Answers
Question: What are partial, alternate, artificial, compound and natural key?Answer:1. Partial Key: It is a set of attributes that can uniquely identify weak entities and that are related to same owner entity. It is sometime called as Discriminator. 2. Alternate Key: All Candidate Keys excluding the Primary Key are known as Alternate Keys. 3. Artificial Key: If no obvious key, either stand alone or compound is available, then the last resort is to simply create a key, by assigning a unique number to each record or occurrence. Then this is known as developing an artificial key. 4. Compound Key: If no single data element uniquely identifies occurrences within a construct, then combining multiple elements to create a unique identifier for the construct is known as creating a compound key. 5. Natural Key: When one of the data elements stored within a construct is utilized as the primary key, then it is called the natural key. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is database or database management systems (DBMS)?
- What is SQL?
- What's the difference between file and database? Can files qualify as a database?
- What’s difference between DBMS and RDBMS?
- How many types of relationship exist in database designing?