Answer Posted / ashu_deepu

in short
authorisation means giving the authority to a person to have access to resources.
but

authentication means checking whether that person have the access to resources.

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

1033

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1904

---

How to use group functions in the select clause using oracle?

1021

---

How to start a new transaction in oracle?

1014

---

What is an index associated with a constraint?

973

---

List the various oracle database objects?

993

---

is there a tool to trace queries, like profiler for sql server?

1076

---

What is key preserved table?

955

---

What is an oracle wallet?

878

---

Please explain joins in oracle?

1007

---

How to drop a stored function?

1082

---

What do you understand by a database object? Can you list a few of them?

969

---

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

1812

---

How can I see all tables in oracle?

949

---