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 various indexes in teradata? Why are they preferred?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
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?
What is meant by a Least Cost Plan?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
If a Node is busy what are the steps you can take to avoid ?
What is dimensional modeling?
Explain fallback in teradata?
How do you see a ddl for an existing table?
Explain and compare pros and cons of start schemas?
What is smp and mpp platforms?
List out all forms of LOCKS that are available in Teradata.
Syntax for case when statement?
Which is more efficient group by or distinct to find duplicates?
