Answer / Chandra Kumar Misra

To analyze table partitions in Oracle Database, one can use the DBMS_STATS package to gather statistics on each partition. You can execute the following command: DBMS_STATS.GATHER_TABLE_STATS(ownname => '<owner>', tabname => '<table_name>', estimate_percentage => '<estimate percentage>', method_opt => 'FOR ALL PARTITIONS');

What is pct free/pct used/pct increase parameter in segment? What is growth factor?

1 Answers  

---

What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?

1 Answers  

---

What are the different types of backup available in the oracle?

1 Answers  

---

What is a dba certification?

1 Answers  

---

Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?

1 Answers  

---

You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?

1 Answers  

---

What are the five main functions of a database administrator?

1 Answers  

---

How can be determining the size of the log files?

1 Answers  

---

What is the finger command?

1 Answers  

---

Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

1 Answers  

---

When should you increase copy latches? What parameters control copy latches?

1 Answers  

---

What is a production dba?

1 Answers  

---