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
State the acid rules?
I have a few records all are same structures data, I want to store data in multiple targets how
What are data modelling techniques?
Explain about xml databases?
How to combine two function together?
Who are naive users?
What is the database development process?
How can you log an error to the server event log from a stored procedure?
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?
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?
In which database can extended stored procedures be added?
What are the three basic rules which are to be followed for the relational model of the database?
What is database design and development?
How would you design a database for an online site, which would average a million hits a day?
What is normalization? Explain different levels of normalization?