Answer Posted / daid kuamr

Implicite index is created by oracle Internally
ex: when we make a primary key in a Column then implicit
Index created which is Clustered Type index(Default)
while Explicite index created by "Create Index Command'
User

How to write an inner join with the where clause in oracle?

1047

---

How to name query output columns in oracle?

1190

---

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

1061

---

How to create a new table in your schema?

1082

---

How to apply filtering criteria at group level in oracle?

1045

---

Oracle

2380

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1049

---

What is a database table in oracle?

1026

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2015

---

Whats the benefit of dbms_stats over analyze?

2005

---

What are the advantages of oracle 12c?

1182

---

What are the different types of trigger and explain its various uses and functions?

1099

---

What is system global area (sga) in oracle?

996

---

What is the difference between post-database commit and post-form commit?

1206

---

What are a query and state the different types of queries and their uses?

1019

---