• Oracle database query from one table or more than one using various joining conditions.
• Single row sub-query and multi row sub-query
• Performing DML, DDL, DCL, TCL on oracle database tables.
• Use of WITH clause and making column UNUSED to improve performance of query.
• Creating simple and complex view to restrict data access.
• Creating sequence to generate unique number to populate primary key column of table.
• Viewing the data dictionary through various views.
• Installing the Oracle on Linux and Windows platform.
• Daily monitoring the database alert log file & trace files for any default and non default parameters, periodic checking tablespaces, rollback segments & index status.
• Creation of new databases by using DBCA and manually
• Creation of database storage objects like tablespaces, tables and indexes.
• Tuning the database parameters.
• Diagnosis of database problems by using AWR and ADDM reports ALERT File.
• Creating database users / Database security
• Plan, test and implement the database Backup & Recovery strategy depending on the database size. Checking the daily, weekly, monthly backup status.
• Making tablespaces available to users, adding data files to the tablespaces and resizing of data files.
• Used FLASHBACK technology for object, statements and database recovery.
• Logical backup and restoring the database using DATAPUMP.
• Backups using RMAN, Cold, Hot and Logical options.
• Recovery of database.
• AUDITING