After completing this course you should be able to:
- Describe the Oracle server architecture
- Start and close the database
- Create a complete database
- Describe the operations to access and update data
- Describe the principles of transaction concurrency and read consistency
- Adjust the database by changing the initialization parameter
- Manage the structure of the database tablespaces
- Manage the allocation of space and increasing segment of the database
- Manage the database space for tables, indexes, clusters, and clustered hash index
- Manage the withdrawal of the segments and temporary segments
- Ensure data integrity
- Create, monitor and delete users
- Control system resource database users
- Allocate, monitor and control the permissions on the database
- Perform tasks related to national language support (NLS)
- Describe, on and off track
- Describe advanced server architecture
- Describe the procedures and database options
- Manage the database using Server Manager tool
to be continued...
No comments:
Post a Comment