Interested to Buy Any Domain ? << Click Here >> for more details...
Define candidate key, alternate key, composite key?
- 30 Answers
- 144540 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / shiv om mishra
candidate key- is a combination of two attributes taht can be uniquely used to identify a datbase record without any extraneous data.
Each table may have one or more candidate key.
A candidate key of a relation tells us all teh set of all its attribute is a superkey.
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How is data stored in dbms?
What are the main phases of database development?
Explain about network model?
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?
State the acid rules?
What are the three basic rules which are to be followed for the relational model of the database?
How can you fix a poorly performing query?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
Explain what a database is?
In which database can extended stored procedures be added?
fact table and dimension table containg one to many relationship or many to one relastionship
How to use online Backups?
How you can make a parameterized view?
What is the database development process?
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?
