Answer / Preety

Statistics should be updated when there are significant changes to the data distribution in a table, such as inserting or deleting a large number of rows, or updating many existing rows. You can use DBMS_STATS package in Oracle to update statistics.

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1 Answers  

---

Is natural join same as inner join?

1 Answers  

---

How do I view tables in sql developer?

1 Answers  

---

Mention what plvcmt and plvrb does in pl/sql?

1 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

1 Answers  

---

What is minus?

1 Answers  

---

Why coalesce is used in sql?

1 Answers  

---

Can we insert data into view?

1 Answers  

---

What is the default value of CHAR type?

3 Answers   Bosch,

---

Can we call stored procedure in function?

1 Answers  

---

What is normalization in sql?

1 Answers  

---

What packages are available to pl/sql developers?

1 Answers  

---