Define candidate key, alternate key, composite key?
Answers were Sorted based on User's Feedback
Answer / palanivel
primary key:- The attribute or combination of attributes
that uniquely identifies a row or record.
Foreign Key:- an attribute or combination of attribute in a
table whose value match a primary key in another table.
Composite key:- A primary key that consistsof two or more
attributes is known as composite key
candidate key:- is a column in a table which has the
ability to become a primary key.
Alternate Key:- Any of the candidate keys that is not part
of the primary key is called an alternate key.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / divya
candidate key: is a column in a table which has thhe ability
to become a primary key.
alternate key:any of the candidate key that is not part of
the primary key.
Is This Answer Correct ? | 34 Yes | 33 No |
Answer / garima sinha
candidate keys are those key which can be treated as
primary key when required.
composite key is made up of more than on key and treated as
primary key.
Alternate key (or secondary key) is any candidate key which
is not selected to be the primary key.
Is This Answer Correct ? | 7 Yes | 6 No |
Answer / vishal sharma
hi, to all. In a interview i asked a question that
"How to apply practically candidate key in SQL SERVER ?
like for primary key we apply PRIMERY KEY keyword how to apply in SQL-SEVER ?"
Plz help me to solve this question Plzzzzzzzz
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / zulfiqar ali
ANSWER 22.. 1 A candidate key is the combination of one or
more attributes which is used to identify records uniquely a
candidate can be selected as a primary key.
2 A key which is not selected is called Alternate key.
3 combination of attributes is called composite key.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / jaison
Candidate key: A candidate key of an entity set is a
superkey for which no proper subset is a superkey
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vishnu
Combine all foreign key in a table is none as composite key
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / koteswararao bora
candidate key:the minimum set of attributes which uniquely
identifies the touples in a table .
primary key:any candidate key choosen by the developer is
called primary key.
composite key: a candidate key which have more than one
attribute is called composite key.
alternate key: a candidate key other than primary key
is called alternate key.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / deependra kumar shukla
Candidate key:- A key 'X' is said to be candidate key if proper subset of 'X' is not a key where X is simple or composite key.
Alternate key:- A candidate key is said to be Alternate key if it is not defined as primary key.An Alternate key may accept null values.
Composite key:- A key is said to be composite key if it contain more than one atribute of the relation.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sanjay p sonar
Candidate key:-A candidate key is unique. We may say that
candidate key is another name of primary key. We can have
more than one candidate key. From which we have to choose
one as a primary key.
Alternate key:-The Candidate key other than primary key is
Alternate key. We can have more than one Alternate keys.
Composite key:- When we combine more than 1 column by key
then that key is called Composite key
Clustered Key:- When we combine more than 1 column to form
Primary key then it will become Cluster key.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain the process of the user request and data generating?
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?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How to create an external table.
What is denormalization and when would you go for it?
What is data modeling with example?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
What is the physical representation for a many-to-many relationship?
A) Which two are benefits of Teradata's support for ANSI Standard SQL? (Choose two.) 1.data is distributed automatically 2.queries get optimized to better plans 3.submit queries from other database systems 4.can interface with BI tools B) Which statement is true when comparing the advantages of third normal form to star schema? 1.Star schema tends to have fewer entities. 2.Star schema requires additional data storage. 3.Third normal form tends to have fewer entities. 4.Third normal form requires additional data storage. C)Which two sets of functions does the Parsing Engine (PE) perform? (Select two.) 1.sorting, formatting, and aggregating of the final answer set 2.flow control of the data to and from the participating tables 3.SQL statement interpretation, syntax validation, and semantic evaluation 4.dispatching the step execution sequence to the AMP via the BYNET D) Which two can be achieved with Teradata Active System Management (TASM)? (Choose two.) 1.disable hardware 2.react to hardware failure 3.influence response times 4.collect metadata E) Which three mechanisms can be used to ensure security within the Teradata Database? (Choose three.) 1.views 2.spool limits 3.roles 4.access rights 5.profiles
Explain about normal forms?
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me