Define candidate key, alternate key, composite key?
- 30 Answers
- 141756 Views
- IAS, IBM, I also Faced
- E-Mail Answers
Answer Posted / rajneesh
primary key: should be unique and Not Null
Unique Key: accept 1 null value and unique
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
How would you design a database for an online site, which would average a million hits a day?
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?
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?
1. Using the XML Document below, with the URI “recipe.xml”
define
the following queries in XQuery:
a.) Give the names of all breakfast in the menu.
b.) Select breakfasts that have price lower than $7.00?
Explain about xml databases?
Can an extended stored procedure be called from inside a user-defined function?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Explain what a database is?
In which table collections errors are stored.
Explain about network model?
Explain the role of indexing in databases?
How can I detect whether a given connection is blocked?
Explain about post-relational databases?
How to combine two function together?
Write the fastest query to find out how many rows exist in a table?
