Answer / wafa

data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database object.

Answer / gaya

The oracle server manages the storage space in the datafiles
in units called oracle blocks or data blocks.

A segment is the space allocated for a specific logical
storage structure within a tablespace.

Space is allocated to a segment by extents.One or more
extents make up a segments.

What is replication? : sql server DBA

0 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

Give the reasoning behind using an index.

2 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

what are the benefits of flashback feature?

0 Answers   Oracle,

---

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---