what are pl/sql collections?

4 Answers   JPMorgan Chase, Oracle,

---

What is the benefit of foreign key?

0 Answers  

---

What is an exception in PL/SQL? What are the two types of exceptions?

0 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

---

Is it important to partition hard disk?

0 Answers  

---

1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,

---

What is the difference between partitioning and sharding?

0 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

What is java sql drivermanager?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

Types of backups ?

3 Answers   TCS,

---