Answer Posted / md sajjad

No We cannot create index on view:
e.g
1* create view emp_view as select * from emp where
deptno=20
SQL> /

View created.


1* create index indx_emp on emp_view(empno)
SQL> /
create index indx_emp on emp_view(empno)
*
ERROR at line 1:
ORA-01702: a view is not appropriate here

Can group functions be used in the order by clause in oracle?

999

---

Explain how are indexes update?

1068

---

How will you write a query to get a 5th rank student from a table student_report?

1866

---

How to pass a cursor variable to a procedure?

1111

---

What are the predefined tablespaces in a database?

1086

---

What is Redo Log Buffer in Oracle?

1210

---

How to estimate disk space needed for an export job?

1051

---

What is the difference between primary key and unique key and foreign key in oracle?

982

---

What is where clause in oracle?

1031

---

How to create a new table by selecting rows from another table?

1102

---

What are joins, explain all types of joins?

2299

---

Explain an integrity constrains?

1151

---

How to display employee records who gets more salary than the average salary in the department?

1068

---

How to use "in out" parameter properly?

1050

---

What are the uses of Database Trigger ?

1721

---