Interested to Buy Any Domain ? << Click Here >> for more details...
What are the components of Logical database structure of
ORACLE database?
- 4 Answers
- 14643 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 |
What do you mean by cdb and pdb in oracle 12c?
What is an Index ?
Explain the types of exception?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
Explain the use of control file?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
How to fetch the row which has the max value for a column?
How to import one table back from a dump file?
Explain drop constraint oracle?
What do you mean by group by clause?
What is flashback Query ? And Use ?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
Oracle General 
