Answer / Ramandeep Singh

To manage the free space in index pages, you can use the FILLFACTOR and PAD_INDEX options when creating or rebuilding an index. The FILLFACTOR option specifies the percentage of pages to fill during index creation or rebuild. A lower value leaves more free space but increases the number of pages required; a higher value uses less space but may fragment the index.

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

1 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

What is the default fill factor value? : sql server DBA

1 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

What is transparent data encryption? : sql server DBA

1 Answers  

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

1 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

Why does Oracle not permit the use of PCTUSED with indexes?

1 Answers  

---

Explain materialized views and how they are used.

1 Answers  

---

why we use cursors

1 Answers  

---

Where would you look for errors from the database engine?

1 Answers   IBM,

---