MyBiosWeb

Oracle Architecture Components Describe the Oracle Server Architecture and its main components. Oracle is basically formed from : An instance: Which is basically a set of memory structures and background processes that cache the most used data, and serve as an exchange point between the users(clients) and the datafiles that have the information on disks. Datafiles : These datafiles are located on hard disks, and they compose all the data that is stored in Oracle,control files,tablespaces, redo-log files,etc. Oracle-Software : This contains the Oracle-kernel which is much like a sub-operating system on top of the host system , because it coordinates the memory-structures and processes (Instance) and the file updates (Datafiles) on the hard drives. List the Structures involved in connecting a user to an Oracle Instance The Oracle server has a set of memory structures and operating process called "The Instance" which ...

Overview of Relational Databases, SQL and PL/SQL Discuss the Theoretical and Physical Aspects of a Relational database E.F. Codd Fathered the concept of the Relational Datamodel. A relational model organizes DATA into TABLES and only TABLES. Tables are the lingua franca of the relational model. /-------------/ /------------------/ /------------/ / Relational /--------/ Named Attributes /-----/ Tuples / / Tables / / (Columns or / / (Rows or / /-------------/ / Fields ) / / Records) / /------------------/ /------------/ A row and column intersection is called a "cell" The columns are placeholders, having data types such as character or integer.The rows themselves are the data. A relational table must meet the following criteria: The data stored in the cells must be atomic. Each cell can only hold one pie...