Answer / Harish Kumar Yadav

Oracle does not allow the use of PCTUSED with indexes because it is intended for tables, not indexes. PCTUSED helps maintain space efficiency for tables by freeing unused blocks when they reach a specified threshold (PCTFREE). However, since indexes are used to locate data within tables and not to store data themselves, setting PCTUSED on an index would have no practical benefit.

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

how can you implement fine-grained auditing?

1 Answers   Oracle,

---

What view would you use to look at the size of a data file?

3 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

1 Answers  

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

wat is global index and local indes

1 Answers   Oracle,

---

How do you add a data file to a tablespace?

3 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

---

What are the different types of indexes available in sql server? : sql server DBA

1 Answers  

---

what are the differences of where and if in SAS?

1 Answers  

---