Define candidate key, alternate key, composite key?
Answer Posted / manumole
Candidate key:
Candidate keys for a table includes the set of columns
which satisfies the criteria of a primary key.
Primary key : a column/combination of columns which
uniquely identifies a row and whose values are not null.
Clustered Key:when a combination of columns becomes a
primary key it is called as clustered key.
Alternate keys:the set of columns which is avialble in the
candidate keys and are not selected as primary key.
Eg:Customer table
candidate keys:{ CustomerID, MobNo(defined as not null) }
primary key: if Db designer selected as CustomerID,then
Alternate key is MobNo
Clustered key:if both combination CustomerID- MobNo is
taken as primary key,it is nothing but a clustered key
Is This Answer Correct ? | 24 Yes | 22 No |
Post New Answer View All Answers
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are the types of database model?
What is data modeling with example?
explain detail about ftp in datastage?
Explain the cube operator?
Explain about the relational database?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
How to use timestamp datatypes
How is data stored in dbms?
What are the three types of database design?
Write the fastest query to find out how many rows exist in a table?
Explain the role of indexing in databases?
What is an application role and explain a scenario when you would use one?
What are the key features of dbms?
Who are end users in dbms?