Define candidate key, alternate key, composite key?
Answer Posted / kamal
candidte key has following character
1 it is a combition of attributes that used to identify a database record without any extraneous data.
2 it has ability to became primary key.
3 it uniquely identifies the row in a table .there can be more than one canditate key in table ,in which one should be a primary key.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
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?
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?
How would you design a database for an online site, which would average a million hits a day?
Explain about the database management systems.
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?
How to use timestamp datatypes
I have a few records all are same structures data, I want to store data in multiple targets how
What are the types of database model?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Why does this query return 0?
Explain what a database is?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).
In which database can extended stored procedures be added?
Who are naive users?