Does view contain data?

1090

---

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?

2351

---

what is the difference between nested subquery and correlated subquery?

1105

---

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

1181

---

What is a composite primary key?

1152

---

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

1052

---

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

1090

---

What do you mean by stored procedures?

1073

---

What is case function?

1099

---

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

1079

---

What are the 3 modes of parameter?

1215

---

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

1096

---

Explain the difference between rename and alias?

1075

---

What do you mean by rowid?

1025

---

Explain dml and ddl?

1068

---