Define candidate key, alternate key, composite key?
Answer Posted / deepak v
candidate key:-A candidate key uniquely identifies the rows
in a table.there can be more than 1 candidate key in a
table, in which one should be a primary key.
alternate key:-In the candidate key the key which is not
primary key is the alternate key.
composite key:- A key formed bythe combination of 2 or more
columns is the composite key.
Is This Answer Correct ? | 122 Yes | 50 No |
Post New Answer View All Answers
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.
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
What are the three basic rules which are to be followed for the relational model of the database?
Explain about relational operator join?
Explain the process of the user request and data generating?
Explain about network model?
Explain about the relational database?
How to use timestamp datatypes
Who are end users in dbms?
Explain the role of indexing in databases?
How to generate OIDS
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 main phases of database development?
What is database design and development?
What is data modeling with example?