Database Administration Question: Download Questions PDF
Explain What is a lookup table in database? where can we use these type of table?
![Database Administration Interview Answer Database Administration Interview Question](https://globalguideline.com/public/images/interview/34.png)
Answer:
Lookup tables are like constraints which hold a value. The content in the lookup tables dosen't change often, hence refered as lookup (reference).
Example : Countries table
Countries are not added on regular bases hence one can consider the table as a lookup table. As and when needed in some other table the countries information can be fetched base on PK - Country-Code column. Eg - Emp_Per_Info.
Example : Countries table
Countries are not added on regular bases hence one can consider the table as a lookup table. As and when needed in some other table the countries information can be fetched base on PK - Country-Code column. Eg - Emp_Per_Info.
Download Database Administration Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain database clusters? | Explain Different types of table join? |