Oracle Database 11g: SecureFiles and Miscellaneous New Features
Recognize the steps for enhancing the performance of large objects, caching query results, and performing other miscellaneous tasks in Oracle Database 11g.
Oracle Database 11g: Securing Domain and Data in Oracle Secure Backup
Oracle Secure Backup (OSB) maintains its own catalog of OSB and their rights on the administrative server. You can preauthorize users for the use of the obtool command line, RMAN, or both. You can ...
Oracle Database 11g: Storage Enhancements
recognize ways in which storage has been enhanced in Oracle Database 11g using Automatic Storage Management's (ASM's) commands and extensions.
Oracle Database 11g: Storage Structures and User Security
identify the steps for maintaining storage structures and automating storage management in Oracle Database 11g, and for managing privileges, roles, and other security features for users.
Oracle Database 11g: Subprograms, Packages, and Exception Handling
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
Oracle Database 11g: Subprograms, Packages, and Exception Handling in PL/SQL
To identify the steps for designing, debugging, invoking, and bundling PL/SQL subprograms, procedures and functions, and also for handling their exceptions.
Oracle Database 11g: Subqueries and Regular Expressions
To recognize the steps for retrieving data using subqueries and using regular expressions to search for, match, and replace strings.
Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
To identify the steps for manipulating queries to return the data you need, using subqueries and set operators, and also for manipulating the actual data using INSERT, UPDATE, DELETE and other data ...
Oracle Database 11g: Supporting RMAN and Using Flashback Technology
To recognize the steps for making sure that you can recover data quickly by tuning RMAN to avoid bottlenecks, and also for making sure that any changes to a database can be easily reversed, if ...
Oracle Database 11g: Tape Vaulting, Duplication, and Tuning
Oracle Secure Backup uses a volume rotation policy to track a backup volume as it moves from its originating location to a storage location and is eventually recycled. This process is known as ...