Interested to Buy Any Domain ? << Click Here >> for more details...
What is a pseudo key? What is its use???
- 2 Answers
- 18926 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
it is used in locks the rowhash
best to tell EXPLAIN in this explanation we locks pseudo key
then it start
| Is This Answer Correct ? | 0 Yes | 10 No |
Syntax for case when statement?
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com
201 Answers Cognizant, Deloitte, IBM, Prometric, Syntel,
How would you load a very large file in teradata in general?
How do you do backup and recovery in teradata?
where we can use the delimiter in mload? pls let me know
what is use of PI(primary index) AND SI(secondary index)
Can any one plz provide the teradata interview questions?
How do you Generate sequence at the time of Display?
What are the different design perspectives used in teradata?
What is the opening step in basic teradata query script?
What do you mean by teradata intelliflex?
Teradata 
