User name:
Password:
 

 

Copyright © 2006.
cisco-certificatiom.co.uk
All Rights Reserved
Oracle9i SQL 1Z0-007 Series: Database Objects and User Security
Product Code: or0709 Time: 4.0 hour(s) CEUs: Available

Summary:

This course examines how to create database objects including sequences, synonyms, and indexes in Oracle9i SQL. It also covers sharing table data with other users through privileges and roles.

Objectives:

  • Create, modify, and delete sequences
  • Create, modify, and delete synonyms
  • Create, modify, and delete indexes
  • Create, modify, and delete users
  • Grant and revoke system and object privileges
  • Create, grant, revoke, enable, disable, and delete roles


Topics:

  • Working with sequences
  • Working with synonyms
  • Understanding indexes
  • Working with indexes
  • Understanding users
  • Working with users
  • Granting privileges
  • Revoking privileges
  • Creating, granting, and revoking roles
  • Enabling, disabling, and dropping roles

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Copyright � 2006 Webteks. All rights reserved.