Mastek Oracle Fusion HCM Functional Consultant Interview Questions and Answers

DB Architecture refers to the design and structure of a database system.

• It includes the physical and logical components of the database.

• Physical components include storage devices, memory, and processing units.

• Logical components include tables, views, indexes, and relationships.

• DB architecture can be centralized, distributed, or cloud-based.

• It is important for scalability, performance, and security of the database syst

An index is a data structure that improves the speed of data retrieval operations on a database table.

• Indexes are created on one or more columns of a table.

• They allow the database to quickly find the rows that match a search condition.

• Indexes can be unique or non-unique.

• Unique indexes ensure that no two rows have the same value in the indexed columns.

• Non-unique indexes allow duplicate values in the indexed columns.

• Inde...read more