Is it possible to have more than one row on the same table
with the same foreign key?
Answer Posted / naveen
Yes, it is possible.
Eg., EMP table consists of many employee records where each
employee is designated to one department#.Here the
department# is the foreign key in the emp table.
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Describe the differences between a data warehouse and data mart.
Explain what are components of reportnet?
Explain what are the basic needs to join two sources in a source qualifier?
if you use oracle sql*loader , how do you transform data with it during loading?
What is a fact, dimension, measure?
What are the reasons to use a chameleon method in data warehousing?
What are the main steps to build the data warehouse?
What are data modeling and data mining?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is surrogate key? Where we use it explain with example?
Explain what is the difference between datawarehouse and bi?
What are the mapping paramaters and maping variables?
What are the stages that are required in data warehousing?
What is index awareness in universe?