Explain What is a lookup table in database? where can we use these type of table?
Submitted by: AdministratorLookup 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Database Administration Job Interview Questions And Answers
Top Database Administration Questions
| ☺ | What are the types of synonyms in Oracle? |
| ☺ | What is Parallel Server in Oracle? |
| ☺ | Explain Can we decrease the Datafile size? |
| ☺ | Explain database clusters? |
| ☺ | Explain What is a database instance? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
