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

What are the oracle built-in data types?

1001

---

What do you mean by a deadlock?

1008

---

What is the minimum client footprint required to connect c# to an oracle database?

1016

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1872

---

What is the string concatenation operator in oracle?

1090

---

What happens if variable names collide with table/column names?

1097

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

---

Please explain compound trigger in oracle?

992

---

State the difference between a primary key and foreign key?

885

---

what is port in oracle? how is it related to database application.

1892

---

How to use existing values in update statements using oracle?

1009

---

What are joins, explain all types of joins?

2215

---

In oracle there is column command, how will you explain that?

964

---

6. Display the client name and order date for all orders using the traditional method.

2237

---

How to work with data objects interactively?

919

---