What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 12945 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jidnesh
The Logical Database Structure of an Oracle include the
schema objects, data blocks, extents, segments and tablespaces.
schema objects means table, index, synonyms, sequences etc.
Data blocks are the smallest part of the oracle database
defined by DB_BLOCK_SIZE parameter.
A group of data blocks forms an extent.
An extents groups tends to segments, and lastly a group of
segment forms a tablespace.
| Is This Answer Correct ? | 26 Yes | 4 No |
Answer / rameshkumar.k
The logical DB contains shared pool(library cache,data dictionary cache),data buffer cache,redolog buffer,java buffer and large pool.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nishi
There are tablespaces and database's schema objects.
| Is This Answer Correct ? | 0 Yes | 1 No |
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is Hash Cluster ?
definition of cluster and non-clustered index?
How to create lov dynamically at runtime & attach to text field?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
What is meant by joins?
How to use group functions in the select clause using oracle?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Explain the relationship among Database, Tablespace and Data file?
From the database level, how can you tell under which time zone a database is operating?
Explain the types of exception?
when loggined as SYSTEM,how to display all the users of database using sql query?
Oracle General 
