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

What is define in oracle?

0 Answers  


What is transaction control statement and how many types of transaction control statement in Oracle?

0 Answers   MCN Solutions,


Explain oracle insert into command?

0 Answers  


Difference between hot backup vs. Cold backup?

0 Answers  


When can Hash Cluster used ?

1 Answers  


Explain the function of optimizer in oracle?

0 Answers  


How can you merge two tables in oracle?

0 Answers  


What is Hash Index?

1 Answers  


Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

0 Answers  


What are operators in oracle?

0 Answers  


From the database level, how can you tell under which time zone a database is operating?

1 Answers  


sql query to get zero records from a table

7 Answers   CTS,


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)