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 a system database and what is a user database? : sql server DBA

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

how can you schedule a job in database?

0 Answers   Oracle,

---

how do see how much space is used and free in a tablespace

2 Answers   Genpact,

---

What is fill factor? : sql server DBA

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---