Does view contain data?

1046

---

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?

2292

---

what is the difference between nested subquery and correlated subquery?

1068

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1133

---

What is a composite primary key?

1109

---

Explain the purpose of %type and %rowtype data types with the example?

1007

---

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

1046

---

What do you mean by stored procedures?

1027

---

What is case function?

1049

---

How many row comparison operators are used while working with a subquery?

1044

---

What are the 3 modes of parameter?

1174

---

Is it possible for a table to have more than one foreign key?

1042

---

Explain the difference between rename and alias?

1029

---

What do you mean by rowid?

994

---

Explain dml and ddl?

1016

---