Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / tdguy
If a table in a database either has no natural key or the
natural key is so long that using it as the key would be
inefficient then we need to consider using a pseudokey
instead. Pseudokeys are usually given the same name as the
table they belong to with _id added to the end of the name.
They usually are defined to contain a number and use
autoincrement in mySQL or the equivalent in other versions
of SQL to dynamically allocate a value when new rows are
created.
source: http://www.felgall.com/mysql04.htm
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain teradata utilities?
In general, how do you optimze any sql in teradata?
What are different table types used in teradata?
Explain and compare pros and cons of snow flake schemas?
Why managing the data is important?
What are the commands to make a new table, change a table and remove a table in teradata?
What can be achieved by using the teradata rdbms?
What do you mean by teradata intellicloud?
Explain fallback in teradata?
Define views in teradata with general syntax.
What is meant by a Highest Cost Plan?
What are the functions involved in shared information architecture?
If a Node is busy what are the steps you can take to avoid ?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are tpump utility limitations?
