how many types of keys are there i.e primary key and foreign
key etc..?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to merge 2 crosstabs thans

2169


What are products of cognos?

573


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1563


What are the types of catalogs in cognos?

687


What do you mean by drill through report?

584






Can you define transformer?

528


Is it possible to join multiple Databases in a Catalog?

652


What is a Pivot?

552


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1540


Cleared COG-112 with 100% score today. What next certification should i go for?

1426


How security is concerned with Reportnet? Explain its implementing steps.

1619


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1466


WHAT ARE THE DISTNICT VARIABLES?

1759


10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?

2014


-----------Diff b/w OLAP and RDBMS?

1630