ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Teradata
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
Please tell me a query to find the Primary key,Foreign 
key,primary Index,PPI for the Database?
 Question Submitted By :: Ramya85
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
Answer
# 1
We can find the information of all the indexes in the 
system table "dbc.indices"
 
Is This Answer Correct ?    12 Yes 1 No
Bhanu Prasad
 

 
 
 
Other Teradata Interview Questions
 
  Question Asked @ Answers
 
How does indexing improve query performance? Satyam3
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?  1
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ? IBM3
Explain about Skew Factor?  4
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 IBM4
How a Referential integrity is handled in Teradata?  2
What is use of compress in terdata?Explain?  3
What is Join Index in TD and How it works? TCS1
can I use “drop” statement in the utility “fload”? Accenture1
Can we load a Multi set table using MLOAD?  1
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?  2
Why Fload doesn’t support multiset table?  5
How to find No. of Records present in Each AMP or a Node for a given Table through SQL? IBM1
What are the types of tables in Teradata Infosys8
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.  5
What is FILLER command in Teradata? CTS3
What is a common data source for the central enterprise data warehouse?  1
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility? IBM2
IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.  4
What is the diffrence between Multiload & Fastload interms of Performance? Intel3
 
For more Teradata Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com