CTS Consulting & Technical Support Interview Questions, Process, and Tips

Collections in Oracle are data structures that store and manipulate groups of data.

• Collections can be used to store data in arrays, lists, or sets.

• They can be used to pass data between PL/SQL blocks or between PL/SQL and SQL.

• Examples of collections include VARRAYs, nested tables, and associative arrays.

Partitions in Oracle are a way to divide a large table into smaller, more manageable pieces.

• Partitions allow for faster querying and maintenance of large tables

• They can be based on a range of values, a list of values, or a hash function

• Partitioning can be done on tables, indexes, and materialized views

• Examples of partitioning include partitioning by date, region, or customer ID

Singleton pattern can be broken using reflection, serialization, and cloning.

• Reflection can be used to access the private constructor and create multiple instances.

• Serialization can create multiple instances when the object is deserialized.

• Cloning can create a new instance of the singleton object.

Bean life cycle refers to the stages a Java bean goes through from creation to destruction.

• Bean is instantiated using a constructor or a factory method

• Bean properties are set using setters or dependency injection

• Bean is initialized using the init method

• Bean can be used for its intended purpose

• Bean is destroyed using the destroy method