Answer / Nibha Kumari

SQL Join Syntax:nLEFT JOIN: SELECT table1.column, table2.column FROM table1 LEFT JOIN table2 ON table1.common_column = table2.common_columnnRIGHT JOIN: SELECT table1.column, table2.column FROM table1 RIGHT JOIN table2 ON table1.common_column = table2.common_columnnINNER JOIN: SELECT * FROM table1 INNER JOIN table2 ON table1.common_column = table2.common_columnnnORACLE Join Syntax:nLEFT OUTER JOIN: SELECT table1.*, table2.* FROM table1, table2 WHERE (table1.common_column = table2.common_column) AND (table2.column IS NULL)nRIGHT OUTER JOIN: SELECT table1.*, table2.* FROM table1, table2 WHERE (table1.common_column = table2.common_column) AND (table1.column IS NULL)

Explain rename?

1 Answers  

---

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 Answers   Wipro,

---

waht is the difference between primary key and super key?

9 Answers  

---

What is a Data File ?

1 Answers  

---

Explain an index?

1 Answers  

---

What is a table in oracle?

1 Answers  

---

a query to select maxmun 3 salaries of employee table

12 Answers   IBM, Polaris,

---

How are the index updates?

1 Answers  

---

Explain the use of file option in exp command.

1 Answers  

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---

State and explain the different types of data models?

1 Answers  

---

How to use "startup" command to start default instance?

1 Answers  

---