Applied Materials Oracle Interview Questions & Answers

Oracle 10g Tutorial

Overview Of Administering An Oracle Database

• Types Of Oracle Database Users
• Tasks Of A Database Administrator
• Identifying Your Oracle Database Software Release
• Database Administrator Security And Privileges
• Database Administrator Authentication
• Creating And Maintaining A Password File
• Server Manageability

Creating An Oracle Database

• Deciding How To Create An Oracle Database
• Manually Creating An Oracle Database
• Understanding The Create Database Statement
• Initialization Parameters And Database Creation
• Troubleshooting Database Creation
• Dropping A Database
• Managing Initialization Parameters Using A Server Parameter File
• Defining Application Services For Oracle Database 10g
• Considerations After Creating A Database
• Viewing Information About The Database

Starting Up And Shutting Down

• Starting Up A Database
• Altering Database Availability
• Shutting Down A Database
• Quiescing A Database
• Suspending And Resuming A Database

Managing Oracle Database Processes

• About Dedicated And Shared Server Processes
• Configuring Oracle Database For Shared Server
• About Oracle Database Background Processes
• Managing Processes For Parallel Sql Execution
• Managing Processes For External Procedures
• Terminating Sessions
• Monitoring The Operation Of Your Database

Managing Control Files

• What Is A Control File?
• Guidelines For Control Files
• Creating Control Files
• Troubleshooting After Creating Control Files
• Backing Up Control Files
• Recovering A Control File Using A Current Copy
• Dropping Control Files
• Displaying Control File Information

Managing The Redo Log

• What Is The Redo Log?
• Planning The Redo Log
• Creating Redo Log Groups And Members
• Relocating And Renaming Redo Log Members
• Dropping Redo Log Groups And Members
• Forcing Log Switches
• Verifying Blocks In Redo Log Files
• Clearing A Redo Log File
• Viewing Redo Log Information

Managing Archived Redo Logs

• What Is The Archived Redo Log?
• Choosing Between Noarchivelog And Archivelog Mode
• Controlling Archiving
• Specifying The Archive Destination
• Specifying The Mode Of Log Transmission
• Managing Archive Destination Failure
• Controlling Trace Output Generated By The Archivelog Process
• Viewing Information About The Archived Redo Log

Managing Tablespaces

• Guidelines For Managing Tablespaces
• Creating Tablespaces
• Specifying Nonstandard Block Sizes For Tablespaces
• Controlling The Writing Of Redo Records
• Altering Tablespace Availability

Managing Datafiles And Tempfiles

• Guidelines For Managing Datafiles
• Creating Datafiles And Adding Datafiles To A Tablespace
• Changing Datafile Size
• Altering Datafile Availability
• Renaming And Relocating Datafiles
• Dropping Datafiles
• Verifying Data Blocks In Datafiles
• Copying Files Using The Database Server
• Mapping Files To Physical Devices
• Viewing Datafile Information

Managing The Undo Tablespace

• What Is Undo?
• Introduction To Automatic Undo Management
• Sizing The Undo Tablespace
• Managing Undo Tablespaces
• Monitoring The Undo Tablespace
• Flashback Features And Undo Space
• Migration To Automatic Undo Management
• Best Practices

Using Oracle-managed Files

• What Are Oracle-managed Files?
• Enabling The Creation And Use Of Oracle-managed Files
• Creating Oracle-managed Files
• Behavior Of Oracle-managed Files
• Scenarios For Using Oracle-managed Files

Using Automatic Storage Management

• What Is Automatic Storage Management?
• Overview Of The Components Of Automatic Storage Management
• Administering An Asm Instance
• Configuring The Components Of Automatic Storage Management
• Using Automatic Storage Management In The Database
• Viewing Information About Automatic Storage Management

Managing Space For Schema Objects

• Managing Space In Data Blocks
• Managing Space In Tablespaces
• Managing Storage Parameters
• Managing Resumable Space Allocation
• Reclaiming Unused Space
• Understanding Space Usage Of Datatypes
• Displaying Information About Space Usage For Schema Objects
• Capacity Planning For Database Objects

Managing Tables

• About Tables
• Guidelines For Managing Tables
• Creating Tables In Oracle10g
• Inserting Data Into Tables Using Direct-path Insert
• Automatically Collecting Statistics On Tables
• Altering Tables
• Redefining Tables Online
• Auditing Table Changes Using Flashback Transaction Query
• Recovering Tables Using The Flashback Table Feature
• Dropping Tables
• Using Flashback Drop And Managing The Recycle Bin
• Managing Index-organized Tables
• Managing External Tables
• Viewing Information About Tables

Managing Indexes

• About Indexes
• Guidelines For Managing Indexes
• Creating Indexes
• Altering Indexes
• Monitoring Space Use Of Indexes
• Dropping Indexes
• Viewing Index Information
• When To Use Composite Range-list Partitioning

Managing Partitioned Tables And Indexes

• About Partitioned Tables And Indexes
• Partitioning Methods
• Creating Partitioned Tables
• Maintaining Partitioned Tables
• Partitioned Tables And Indexes Example
• Viewing Information About Partitioned Tables And Indexes

Managing Clusters

• About Clusters
• Guidelines For Managing Clusters
• Creating Clusters
• Altering Clusters
• Dropping Clusters
• Viewing Information About Clusters Table

Managing Hash Clusters

• About Hash Clusters
• When To Use Hash Clusters
• Creating Hash Clusters
• Altering Hash Clusters
• Dropping Hash Clusters
• Viewing Information About Hash Clusters

Managing Views, Sequences, And Synonyms

• Managing Views
• Managing Sequences
• Managing Synonyms
• Viewing Information About Views, Synonyms, And Sequences

General Management Of Schema Objects

• Creating Multiple Tables And Views In A Single Operation
• Analyzing Tables, Indexes, And Clusters
• Truncating Tables And Clusters
• Enabling And Disabling Triggers
• Managing Integrity Constraints
• Renaming Schema Objects
• Managing Object Dependencies
• Managing Object Name Resolution
• Switching To A Different Schema
• Displaying Information About Schema Objects

Detecting And Repairing Data Block Corruption

• Options For Repairing Data Block Corruption
• About The Dbms_repair Package
• Using The Dbms_repair Package
• Dbms_repair Examples

Managing Users And Securing The Database

• The Importance Of Establishing A Security Policy For Your Database
• Managing Users And Resources
• Managing User Privileges And Roles
• Auditing Database Use

Managing Automatic System Tasks Using The Maintenance Window

• Maintenance Windows
• Automatic Statistics Collection Job
• Resource Management In Oracle

Using The Database Resource Manager

• What Is The Database Resource Manager?
• Administering The Database Resource Manager
• Creating A Simple Resource Plan
• Creating Complex Resource Plans
• Managing Resource Consumer Groups
• Enabling The Database Resource Manager
• Putting It All Together: Database Resource Manager Examples
• Monitoring And Tuning The Database Resource Manager
• Interaction With Operating-system Resource Control
• Viewing Database Resource Manager Information

Moving From Dbms_job To Dbms_scheduler

• Moving From Dbms_job To Dbms_scheduler

Overview Of Scheduler Concepts

• Overview Of The Scheduler
• Basic Scheduler Concepts
• Advanced Scheduler Concepts
• Scheduler Architecture

Using The Scheduler

• Scheduler Objects And Their Naming
• Administering Jobs
• Administering Programs
• Administering Schedules
• Administering Job Classes
• Administering Windows
• Administering Window Groups
• Allocating Resources Among Jobs

Administering The Scheduler

• Configuring The Scheduler
• Monitoring And Managing The Scheduler
• Import/export And The Scheduler
• Examples Of Using The Scheduler

Distributed Database Concepts

• Distributed Database Architecture
• Database Links
• Distributed Database Administration
• Transaction Processing In A Distributed System
• Distributed Database Application Development
• Character Set Support For Distributed Environments

Managing A Distributed Database

• Managing Global Names In A Distributed System
• Creating Database Links
• Using Shared Database Links
• Managing Database Links
• Viewing Information About Database Links
• Creating Location Transparency
• Managing Statement Transparency
• Managing A Distributed Database: Examples

Developing Applications For A Distributed Database System

• Managing The Distribution Of Application Data
• Controlling Connections Established By Database Links
• Maintaining Referential Integrity In A Distributed System
• Tuning Distributed Queries
• Handling Errors In Remote Procedures

Distributed Transactions Concepts

• What Are Distributed Transactions?
• Session Trees For Distributed Transactions
• Two-phase Commit Mechanism
• In-doubt Transactions
• Distributed Transaction Processing: Case Study

Managing Distributed Transactions

• Specifying The Commit Point Strength Of A Node
• Naming Transactions
• Viewing Information About Distributed Transactions
• Deciding How To Handle In-doubt Transactions
• Manually Overriding In-doubt Transactions
• Purging Pending Rows From The Data Dictionary
• Manually Committing An In-doubt Transaction: Example
• Data Access Failures Due To Locks
• Simulating Distributed Transaction Failure
• Managing Read Consistency

All Tutorials

All Practice Tests