Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

0 Answers  

---

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

How does indexing improve query performance?

4 Answers   Satyam,

---

What is teradata? What are some primary characteristics of teradata?

0 Answers  

---

What is the purpose of using case expression in teradata?

0 Answers  

---

What is a dimension table?

0 Answers  

---

What is difference between user and database in teradata?

0 Answers  

---

What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  

---

Give a justifiable reason why Multi-load supports NUSI instead of USI.

0 Answers  

---