Sunday 27 February 2011

ORACLE ARCHITECTURE


1)      State E.F.Codds’s 12 rules of RDBMS.
2)      What is database? Explain processes.
3)      Explain database support processes (or server processes).
4)      List and explain oracle background processes.
5)      Define blocks, segments and extents.
6)      Explain control files and redo log files.
7)      Explain types of tablespace in oracle.
8)      Explain initialization parameter (or init.ora) file.
9)      The logical and physical structure of oracle database.
10)  List and explain responsibilities of DBA.
11)  Explain oracle instance.
12)  Explain oracle memory structure.
13)  Explain SGA with its components.
14)  Explain PGA.
15)  Explain difference between DDL and DML.
16)  Explain E-R diagram and types of relationship.
17)  What is Entity? Explain type of relationship between entities with diagram.
18)  What is transaction? Explain with a facility to undo the changes.
19)  Explain SQL*Loader.
20)  Explain IMPORT & EXPORT facility in oracle.

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Grants For Single Moms