Define candidate key, alternate key, composite key?
Answer Posted / piyush kathayat
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 ? | 587 Yes | 62 No |
Post New Answer View All Answers
Explain about the storage and physical database design?
Write the fastest query to find out how many rows exist in a table?
What are the three types of database design?
What is the physical representation for a many-to-many relationship?
Which four data types cannot be used as a return type from a user-defined function?
Explain about the database management systems.
How long can an error message be in raiseerror function?
What is database design and development?
How can I detect whether a given connection is blocked?
How to use timestamp datatypes
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?
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?
explain detail about ftp in datastage?
How to read and create .LDC data files which are used by linguatic dictionary.
How to replace not in with not exist?