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
What are the joins in teradata and how many types of joins are there in teradata?
What are the available primary index types?
Highlight the differences between Primary Key and Primary Index.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain parsing engine in teradata?
What is the difference between fastload and multiload?
What is bteq script in teradata?
How is MLOAD Teradata Server restarted after execution?
Explain the term 'columns' related to relational database management system?
What are the components provided on node?
What is the difference between teradata and basic rdbms?
How to eliminate product joins in a teradata sql query?
Explain the types of join supports by teradata?
How can bottlenecks be identified?
What are the multiload utility limitations?
