Answer Posted / preethi raju

Yes you can create a view for retrieving data of deptno=10 employees and you can create a synonym for it.

create or replace view v2 as select *from emp where deptno=10;

CREATE OR REPLACE SYNONYM sv2
FOR v2;

select *from sv2;

Point out the difference between user tables and data dictionary?

734

---

How to convert times to characters in oracle?

787

---

What is oracle sid?

665

---

does the query needs a hint to access a materialized view?

1638

---

Explain an index?

844

---

---

Whats the benefit of dbms_stats over analyze?

1686

---

How to grant create session privilege to a user in oracle?

756

---

What are named parameters?

778

---

Explain the function of optimizer in oracle?

762

---

What is a read only transaction in oracle?

791

---

Can we convert a date to char in oracle and if so, what would be the syntax?

746

---

What is meant by a deadlock situation?

781

---

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

807

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

795

---

what is the difference between substr and instr function in oracle?

786

---