Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to have more than one row on the same table
with the same foreign key?
- 2 Answers
- 6452 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / pradeeshkumar
Yes, it's possible.
A foreign key in a table can have duplicate values.
For example, One or more employees can belong to same
project.EMPLOYEE_ID is the ptimary key of the Employee
table and PROJECT_ID is a foreign key that references
another table(Project).
EMPLOYEE_ID EMPLOYEE_NAME PROJECT_ID
----------------------------------------
0001 SAM DEX01
0002 MARK DEX01
0003 JUKE MKX02
| Is This Answer Correct ? | 6 Yes | 0 No |
Explain what is the extension of file to save template?
What is surrogate key?
What is data merging, data cleansing and sampling?
What is Drill by? drill through?
What is latest version of power center / power mart?
Explain me what is vldb?
What are components of reportnet?
Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best
Explain what are the basic needs to join two sources in a source qualifier?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How Materialized Views are linked with Oracle DataWare house?
How to create different types of templates?
Teradata 
