Answer Posted / prabhudatta barick

Automatic Optimizer Statistics Collection
By default Oracle 10g automatically gathers optimizer
statistics using a scheduled job called GATHER_STATS_JOB.

As it gathers table statistics automatically
so no need to gather table statistics before
running this query.

SELECT num_rows
FROM dba_tables
WHERE table_name = '<TABLE_NAME>';

This will give u the total no. of records in a table....

What is cross join example?

1064

---

Can we create table in function?

1017

---

Is the primary key an index?

1077

---

How to avoid duplicate records in a query?

1049

---

Can pl sql procedure have a return statement?

1071

---

How do I access sql anywhere database?

1021

---

How many types of sql are there?

1042

---

Can we join same table in sql?

1066

---

What is optimistic concurrency control? : Transact sql

1028

---

What is on delete restrict?

1068

---

What is pl sql variable?

1034

---

What can sql server reporting services do?

1162

---

write an sql query to find names of employee start with 'a'? : Sql dba

1085

---

Why is sql important?

1169

---

Is it possible to create the following trigger: before or after update trigger for each row?

1348

---