MyBiosWeb

Backup and Recovery Considerations Define requirements for a backup and recovery strategy A thurough understanding of the business,operational, and technical requirements this will help develop an effective backup and recovery strategy that will protect the database from different types of failures and insure high availability, minmal downtime and complete data recovery. Regularly test the backup and recovery strategy, because it ensures integrity of backups, the validity of the backup and recovery methods,and the reduction of problems before they occur in a production database. Articulate the importance of management concurrence for the strategy It ensures that there will always be an on-line duplicate (hot backup) of the database and also helps avoid a CLI (Career Limiting Incident) !!. Identify the components of a disaster recovery plan A disaster recovery plan consists of preparing for unlikely events, but depending on what part of the world you are, this could be more than...

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...