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 Local Cache and how does it help in performance tuning
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
write a query to display to 10 max record from the employee table?
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
what is surrogate key give example?
Cleared COG-112 with 100% score today. What next certification should i go for?
You get a parsing error when you run a report. What will be your first steps to resolve the error?
set scope level in transformer
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.
How can we convert imr report into Impromptu web report?
How do you call a store procedure within a transformation?