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 sql entity?

1108

---

what is 'mysqld'? : Sql dba

973

---

Does execute immediate commit?

1223

---

What is synchronized subquery?

1172

---

what are the nonstandard string types? : Sql dba

1144

---

What are the three forms of normalization?

1045

---

How can the performance of a trigger be improved?

1047

---

Describe types of sql statements?

1061

---

how does a local variable is defined using t-sql? : Transact sql

1019

---

Can we rollback after truncate?

1033

---

Why we use join in sql?

979

---

What is the use of function in sql?

1096

---

What is structural independence and why is it important?

1031

---

Explain what is a view?

1066

---

Is it possible to create startup or shutdown trigger for on-schema?

1030

---