Evaluation Schedule DBA-08 WinSum

First Period Evaluation
701 Wednesday, February 20th
702 Thursday, February 21th

Second Period Evaluation
701 Monday, March 10th
702 Tuesday, March 11th

Questionnaires Database Administration-Oracle

Q#1

Covers following sections of Oracle's B14220 document:
Part II-Section 2-Data blocks,extents and segments
Part II-Section 3-Tablespaces, Datafiles and Control Files
Part II-Section 4-Transaction Management
Part II-Section 5-Schema Objects
You must read all material, download the questionnaire #1 and respond every question.
Discussion Date
701 Wednesday, February 13th
702 Thursday, February 14th

Q#2

Covers following sections of Oracle's B14220 document:
Part II-Section 7-The Data Dictionary
Part II-Section 8-Memory Architecture
Part II-Section 9-Process Architecture
Part II-Section 11-Oracle Utilities
Part II-Section 12-Database and Instance Startup and Shutdown
You must read all material, download the questionnaire #2 and respond every question.
Discussion Date
701 Monday, February 18th
702 Tuesday, February 19th

Today beggins the "Phrase of the Week" section

Every week , I'll change the motivational phrase of the blog. Historical archive of phrases will be available here.

Cada semana, reemplazaré la frase motivacional del blog. El archivo historico de frases estara disponible aqui.

Assignments Operating Systems I

Assignment #1

Research the Operating Systems history, and delivery a 3 pages summary with a 2 paragraph personal conclusion about the advances on this area.
Focus on: operating system names, technical improvements and time reference.
Due Date(Fecha de Entrega)
502 Friday (Viernes) January 25th
503 Friday (Viernes) February 1st

Assignment #2

Write a program that simulates the life cycle of n (randomly generated) processes, given that only two may be on execution at the same time and their time-share is 30 seconds. Also randomly mark one process as I/O type and change status accordingly.
(Escriba un programa que simule el ciclo de vida de n (numero aleatorio de) procesos, dado que solo dos de estos pueden estar en ejecucion al mismo tiempo y que el tiempo de ejecucion es de 30 segundos. Tambien simule que de vez en cuando uno de los procesos hara una peticion de I/O y su estado cambiara de acuerdo a eso.)
-Programming Language: free to choose (Logo,C,C++,Visual.NET,etc).
-Personal
-Extrictly forbidden to copy, exchange or plagiate code
Due Date(Fecha de Entrega)
502 Wednesday (Miercoles) February 6th
503 Tuesday (Martes) February 5th

Graduate Studies (Posgrados) and Financial Aid

If you've wondered how to finance your studies or study abroad, you may read following article Ofrece Sofes credito para estudios and check the BritishCouncil page, whom by the way is going to organize the Feria Educativa 2008 at Mexico City next February 9th and 10th. You should go and see for your future...

Laboratories and Practice

Laboratory #1

Follow the Oracle Database Installation Guide for Linux (Document B15660-01) instructions that we started to review on class, and complete an Oracle installation and database creation. Remember to follow carefully required section 2-Preinstallation tasks in order to begin with 3-Installation Tasks.
Due Date
702 Tuesday (Martes) February 5th
701 Wednesday (Miercoles) February 6th

Assignments Database Administration-Oracle

Assignment #1

Download and read the section Part 1-Section 1 "Introduction to the Oracle Database" of document Oracle Database Concepts 10gRelease 2 (B14220-01 ). We will discuss the reading on January 30th and 31th.

Reference: Oracle Technical Library
and Oracle Server 10g Release 2 Documentation

Assignment #2

Identify every Database Physical component (Page 1-6 to 1-8 of B14220-01) on a real Oracle database.
1) Document where and how are defined during database creation
2) Document the full path (folder) where are located and usual name they take.
Hint: during your Oracle installation (Laboratory #1) there is a screen where you instruct the installer to create a database besides installing the software.
Due Date
702 Tuesday (Martes) February 5th
701 Wednesday (Miercoles) February 6th

Assignment #3

Research on what platforms (Hardware and Operating System) we can install Oracle Server, and which are the requirements for every HW-OS combination.
(Investigar en que plataformas (HW y SO) se puede instalar Oracle y que requerimientos tiene para cada una de las combinaciones.)
Due Date
701 Monday (Lunes) February 18th
702 Tuesday (Martes) February 19th

Assignment #4
Research which Oracle Server versions have been released, and which new features offered.
(Investigar cuales son las diferentes versiones de Oracle y que caracteristicas o funcionalidades las distinguieron.)
Due Date
701 Monday (Lunes) February 25th
702 Tuesday (Martes) February 26th