Define candidate key, alternate key, composite key?
Answer Posted / vishnu
Combine all foreign key in a table is none as composite key
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the three basic rules which are to be followed for the relational model of the database?
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 about the database management systems.
Who are naive users?
Explain about relational operator join?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What is data modeling with example?
Explain about network model?
Write the fastest query to find out how many rows exist in a table?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is the physical representation for a many-to-many relationship?
I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS
Explain about the storage and physical database design?
What are the main phases of database development?