how many types of keys are there i.e primary key and foreign
key etc..?
Answers were Sorted based on User's Feedback
Answer / palzkumar
Piggynet is very close...
Actually there are 3 types of referential integrity constraints (i guess you referring this as keys) are available in DB...
1. Primary Key
2. Unique Key
3. Foreign Key
Composite Primary Key is same as PK, but its applied on combination of 2 or more columns.
-Palz
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / piggynet
Primary key
Foreign key
Composite key
Surrogate key
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sowmya
keys r of 4 types. 1.super key , 2.candidate key 3 primary
key 4.foreign key
| Is This Answer Correct ? | 3 Yes | 3 No |
What is the function of model design accelerator?
How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
how to get the all values from a prompt using 'ALL' use and display value in prompt
15. If I select the current month and year how can we display previous 11 months data?
It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?
How to create model and how to test model?
What is portal page?
What is a dashboard in Cognos Report Studio and how do we creae it
difference between imprompt and reportnwt1.1
----------------Diff b/w Dimensional modeling and Relational modeling?
what is boxtype