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>';

Are dml statements autocommit?

984

---

Is it possible to read/write files to-and-from PL/SQL?

1036

---

What is anonymous block in sql?

1074

---

what is view? : Sql dba

912

---

Is big data nosql?

886

---

What is compilation error in pl sql?

920

---

How many aggregate functions are available there in sql?

929

---

what is bcp? When is it used?

1047

---

How would you convert date into julian date format?

947

---

how to concatenate two character strings? : Sql dba

1030

---

What is lookup table in sql?

980

---

What are procedures used for?

922

---

tell me about various levels of constraint. : Sql dba

989

---

What is pl sql architecture?

922

---

What is crud sql?

921

---