10+ Premsons Motor Udyog Interview Questions and Answers

Components of logical database structure in Oracle include tables, views, indexes, sequences, and synonyms.

• Tables: Store data in rows and columns.

• Views: Virtual tables based on SQL query results.

• Indexes: Improve query performance by providing quick access to rows.

• Sequences: Generate unique numbers for primary key values.

• Synonyms: Alias for database objects to simplify queries.

Function overloading is the ability to have multiple functions with the same name but different parameters.

• Function overloading allows multiple functions with the same name but different parameter types or number of parameters.

• It helps in writing cleaner and more readable code by providing a way to perform similar operations on different data types.

• Example: Overloading the 'add' function to work with both integers and floating-point numbers.