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 |
Can you define bitmap index?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
------------- How to identify the Revenue Column in Report?
How to test a cube?
How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?
how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......
Write various indexes used in cognos?
what is model and how to create model and how to test model?
My problem is as follows I made two pages of the portal; in the first page i have two reports and from one of these i would like to communicate in some way (i.e drill- through?) with the second page that contains four reports (prompt value [product] and three chart [sales revenue, sales quantity and budget]). Particularly I would like to communicate with the report that contains the prompt, passing the Product. How can i drill from the first page of the portal to the second page ? More generally, is it possible to move from one page, containing 2 report, to another page with 4 report, through a drill-through or any other mechanism? Thank in advance.
-----------With out using DrillThrough how to do Reports?
-------What are the Adv of Star Schema and Snow Flake Schema?
-------------What is a Conformed Dimension?