Define candidate key, alternate key, composite key?
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
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?
What is the physical representation for a many-to-many relationship?
Write the fastest query to find out how many rows exist in a table?
Why does this query return 0?
How can you fix a poorly performing query?
What is normalization? Explain different levels of normalization?
How to replace not in with not exist?
What are the three types of database design?
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?
What is the database development process?
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.
How can you log an error to the server event log from a stored procedure?
What is a database development?
What is dbms and its application?
Explain the cube operator?