IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN
ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES
HOW?PLZ GIVE ME A EXAMPLE.




Answers were Sorted based on User's Feedback



Answer / oceanblue

Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.

e.g.

A Salary Table will have employee ID as primary key. The
table also contains TAX-ID which can not be null or duplicate.

Is This Answer Correct ?    7 Yes 0 No

Answer / rajiv senapati

yes

Is This Answer Correct ?    2 Yes 0 No

Post New Answer




More Teradata Interview Questions

any one pls tell me what are the table names in banking project?

2 Answers  


What is differnce between Error code and Error Level in Bteq

6 Answers   IBM,


what is sysdba and sysdbc ? which has high priority ?

0 Answers   Wipro,


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,


Difference between Qualify and group

4 Answers   CTS,






whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?

5 Answers   HCL,


what happen if a query fail in dispatcher?

1 Answers   Cap Gemini,


Can we load a Multi set table using MLOAD?

2 Answers  


I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  


how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,


one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?

3 Answers   IBM,


hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  






Categories