What are elements of database logical layers?


What are elements of database logical layers?

<<Previous  Next>>

Oracle - What are elements of database logical layers? - June 27, 2009 at 11:00 AM

What are elements of database logical layers?  

The logical layer of the database consists of the following elements:

One or more tablespaces.
The database schema that comprises of items such as tables, clusters, indexes, views, stored procedures, database triggers, and sequences.

Oracle architecture

Describe Oracle architecture in brief, What is the function of SMON?, Explain different types of segment, Explain SGA memory structures..............

Oracle auditing

Session auditing, Statement auditing, Privilege auditing, Object auditing.............

Oracle processes

User process – User process is used in invocation of application software, Data writing process - A database writer process is used to write buffer content into a datafile. They are specifically used to write “dirty block” to data files from the buffer...............

What are layers in Oracle Architecture?

The Oracle database has a logical layer and a physical layer. The physical layer consists of the files that reside on the disk and logical layer map the data to these files of physical...........

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring