Answer Posted / prabhudatta barick

Please ignore my first answer...

as By default this job runs within a maintenance windows
between 10 P.M. to 6 A.M. week nights and all day on
weekends.

to get the exact record please use this

ANALYZE TABLE <table_name> COMPUTE STATISTICS;

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

What is primary key and unique key?

1162

---

Which one is faster ienumerable or iqueryable?

986

---

What are properties of the transaction?

1045

---

What is sql engine in oracle?

1038

---

Can instead of triggers be used to fire once for each statement on a view?

1006

---

What is attribute indicator in pl sql?

1065

---

What is the usage of distinct keyword?

1111

---

which tcp/ip port does sql server run on? : Sql dba

1079

---

What is cursor in pl sql with examples?

1087

---

What is the use of function in sql?

1147

---

Describe types of sql statements?

1102

---

What is cursor in pl sql?

1185

---

Differentiate between sga and pga.

1206

---

What are the advantages of normalization?

1127

---

What is the difference between partitioning and sharding?

1049

---