Is hive a database?

0 Answers  

---

What is OQL?

4 Answers  

---

Explain inner and outer joins with examples.

0 Answers   Agilent,

---

utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

2 Answers   Accenture,

---

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

---

---

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers   HP,

---

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  

---

characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,

---

Differentiate between delete and truncate table?

0 Answers  

---

Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?

0 Answers  

---

What is the role of tester in discovery(in Checklist)?

0 Answers  

---

Explain various types of locks in a transaction? Which is better and why?

0 Answers   Agilent,

---