Online Oracle Sql Worksheet eLearning Training

Oracle8 Database Administration - Manage Security ...espace quotas for users from the data dictionary by using Oracle SQL Worksheet. Display the account status of users from the data dictionary by using Oracle SQL Worksheet. Unit 2: Managing Profiles Duration: 1.5 - 2 Hour(s) Identify the uses of profiles. Identify the implications of exceeding each type of profile limit. Identify the level at which the limit of a given resource is more...

Oracle8 Database Administration - Manage Data ...racle Schema Manager. Manually allocate extents by using Oracle SQL Worksheet. Identify the characteristics of the high water mark. Validate a table structure by using Oracle SQL Worksheet. Execute the command used to detect row migration in a table by using Oracle SQL Worksheet. De-allocate the unused space in a table by using Oracle SQL Worksheet. Truncate a table by using Oracle SQL more...

Oracle8 Database Administration - Manage Storage Structures ...ber of extents and blocks allocated to a segment by using Oracle SQL Worksheet. Retrieve the information to view the extents for a given segment by using Oracle SQL Worksheet. Write a query to check the extents for a given segment by using Oracle SQL Worksheet. Unit 2: Managing Rollback Segments Duration: 1 - 2 Hour(s) Identify the purposes of rollback segments. Identify the more...

Oracle8 Database Administration - Create Databases ... Start a specified instance in the NOMOUNT mode by using Oracle SQL Worksheet. Identify the functionality of the CREATE DATABASE command options. Create a database with specified parameter values by using the CREATE DATABASE command. Identify the commonly encountered situations in which the CREATE DATABASE command fails. Identify the contents of a database after its creation. Unit 2 - more...