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 explain health care project and which reports we can create in health care doain?

6358


How to do Performence Tunning in Cognos Reports?

2077


What are initial page components of Cognos connection?

612


Can you define slice?

628


What are the ways to import data into catalog?

638






Can you explain dynamic query mode?

592


What is a Cube?

691


What is defined as Query studio?

619


What is a Framework manager?

565


Can we test the report other than manual testing?

1664


Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

560


how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1492


How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?

2803


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

1977


9. What was the most complex type of report you dealt with?

1737