Define candidate key, alternate key, composite key?
Answer Posted / sonal singhal
Candidate keys-> A candidate key is a combination of
attributes that can be uniquely used to identify a database
record without any extraneous data. Each table may have one
or more candidate keys. One of these candidate keys is
selected as the table primary key.
Alternate keys-> Alternate Key or Unique Key is similar to
PK ,except it accepts null Values .So that the records can
still be entered submitting null values to this attribute.
Composite keys-> compound key (also called a composite key
or concatenated key) is a key that consists of 2 or more
attributes.
A composite Key can be either Primay or Unique
Key.More then One Key columns are said to be composite keys
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
What are the 18 schemas?
What is data modeling with example?
Explain the process of the user request and data generating?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Explain about relational operator join?
How you can make a parameterized view?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What are data modelling techniques?
I have a few records all are same structures data, I want to store data in multiple targets how
Why does this query return 0?
How to use online Backups?
How can you fix a poorly performing query?
How to read and create .LDC data files which are used by linguatic dictionary.
Who are end users in dbms?