What is a pseudo key? What is its use???

Answers were Sorted based on User's Feedback



What is a pseudo key? What is its use???..

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

What is a pseudo key? What is its use???..

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

Post New Answer

More Teradata Interview Questions

Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  


Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  


What is upsert statement in teradata?

0 Answers  


How many codd's rules are satisfied by teradata database?

0 Answers  


Fast Load Script is failed and error tables are available then how do you restart?

3 Answers   TCS,






Comment whether bottleneck is an error or not.

0 Answers  


Which is faster fastload or multiload?

0 Answers  


What is a pseudo key? What is its use???

2 Answers   Mphasis,


i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 Answers  


What are the things to be considered while creating secondary index?

0 Answers  


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

0 Answers  


What are the string manipulation operators and functions associated with teradata?

0 Answers  


Categories