What are the components of Logical database structure of
ORACLE database?

Answers were Sorted based on User's Feedback



What are the components of Logical database structure of ORACLE database?..

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

What are the components of Logical database structure of ORACLE database?..

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

What are the components of Logical database structure of ORACLE database?..

Answer / chaudhry

Tablespaces and the Database's Schema Objects

Is This Answer Correct ?    8 Yes 9 No

What are the components of Logical database structure of ORACLE database?..

Answer / nishi

There are tablespaces and database's schema objects.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle General Interview Questions

Name the various constraints used in oracle?

0 Answers  


How different is ms access and oracle?

0 Answers  


what is null value?

11 Answers   KITS, Oracle,


What do you mean by group by clause?

0 Answers  


What is a trigger and what are its types?

0 Answers  


Difference between open_form and call_form in oracle.

0 Answers  


What are the different types of trigger and explain its various uses and functions?

0 Answers  


How to end the current transaction in oracle?

0 Answers  


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,


Can you assign multiple query result rows to a variable?

0 Answers  


how can we store any pdf file in oracle

0 Answers  


How to filter out duplications in the returning rows using oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)