Sunday, April 30, 2006

Oracle 9i - Index of notes

Credits & Disclaimer : The following are my Oracle 9i SQL notes prepared during the course of my preparation for Oracle DBA 9i Exam 1Z0-007 and mostly referenced from various Oracle publications. These are meant for my personal use.

In past I have prepared notes on paper many times but seldom have i been able to use them. As layers of dust settle on them, it gets kind of messy to touch them :) This blog, an online notebook, seems like an ideal solution to me, to be referenced on the move without need to carry bulky books.

Part I :
  1. Data Query
  2. Logical Operators (AND, OR, NOT etc) & Single row Functions
  3. DML & Locks
  4. DDL & Constraints
  5. Views & Top-N Analysis
  6. Sequences
  7. Database Link (note : scoll to bottom of privilege notes)
Part II:
  1. Creating Database manually / Restoring backed-up database
  2. Password authentication setup : Operating System authentication / password file authentication
  3. Control Files
  4. Redo Log Files
  5. Segments & Data Blocks - INITRANS-MAXTRANS / PCTFREE-PCTUSED-FREELIST
  6. Tablespaces
  7. Managing User (Create-Alter-Drop)
  8. Profiles
  9. Privileges (Grant-Revoke) & Database Link
  10. Roles(Create-Alter-Set-Drop)
  11. Auditing(Audit-Noaudit)
  12. Password Management script utlpwdmg.sql
  13. Views : Storage relationships (Segments & Extents)
  14. Views : Users-Quota-Profile-Resource cost-Resource Limit-Privileges

Comments: Post a Comment

Links to this post:

Create a Link



<< Home
Advertisements

eBay.in - The World's Online Marketplace

ARCHIVES
  • March 2006
  • April 2006
  • May 2006
  • June 2006
  • July 2006
  • August 2006
  • September 2006

This page is powered by Blogger. Isn't yours?

Recent Postings

Google