GeekInterview.com
Series: Subject: Topic:
Question: 51 of 83

What is Data Block ?

ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

Asked by: Interview Candidate | Asked on: Sep 5th, 2004
Showing Answers 1 - 3 of 3 Answers
gaurav_varma

Answered On : Jan 10th, 2007

View all answers by gaurav_varma

Data Block:

At the finest level of granularity, Oracle stores data in data blocks (also called logical blocks, Oracle blocks, or pages). One data block corresponds to a specific number of bytes of physical database space on disk.

  
Login to rate this answer.
C.Ramesh

Answered On : Oct 27th, 2007

Oracle Data Blocks is logical storage unit of Oracle and One Oracle Data Blocks containts multiple of Operating system Blocks. Data blocks contains contigous of Bytes.

  
Login to rate this answer.
matabrez

Answered On : Jan 10th, 2011

View all answers by matabrez

Smallest logical of Oracle database. In Oracle 10g default data block size is 8192 byres means 8k.

Other data block size are 2k, 4k, 8k, 16k, 32k
We have only these available data blocks in oracle database.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.