Oracle DBA Interview Questions -3

1. What is an Extent? An Extent is a specific number of contiguous data blocks, obtained in a single allocation, and used to store a specific type of information. 2. What is a Segment? A segment is a set of extents allocated for a certain logical structure. 3. What is the different type of Segments? Data Segment, Index Segment, Rollback Segment and Temporary Segment. 4. What is a Data Segment? Each Non-clustered table has...

Read More

Oracle DBA Interview Questions Part-2

1. What is an Index? An Index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table. 2. How is Indexes Update? Indexes are automatically maintained and used by ORACLE. Changes to table data are automatically incorporated into all relevant indexes. 3. What are Clusters? Clusters are...

Read More

Oracle DBA Interview Questions Part I

                                                                              A database is an organized collection of information treated as a unit. The purpose of a database is to collect, store, and retrieve related information for use by database applications.  ...

Read More

What is Oracle Incentive Compensation (OIC):

Overview: Sales jobs have a significant, measurable impact on the revenue of your business. Keeping your employees motivated and happy is very important for the long-term health of your enterprise. Oracle Incentive Compensation plays a part in determining cash and other tangible rewards. You can use Oracle Incentive Compensation to pay employees, partners, customers, and any non-employee role. Key terms Used in building compensation plan within OIC Module: • Products are user-defined categories of sales for which your organization...

Read More