Senior SAP ABAP Consultant Trainee Interview Questions and Answers

A primary key is a unique identifier for a record in a table, while a foreign key is a reference to a primary key in another table.

• Primary key ensures uniqueness of a record in a table

• Foreign key establishes a relationship between two tables

• Primary key can be used as a foreign key in another table

• Foreign key can have null values if the relationship is optional

DDIC objects are used to define and manage data in SAP systems.

• Tables

• Views

• Data elements

• Domains

• Search helps

• Lock objects

• Match code objects

• Table maintenance generator

• Function modules

• Class pools

Normalization is the process of organizing data in a database to minimize redundancy and dependency.

• Normalization helps to eliminate data redundancy and inconsistencies.

• It involves breaking down a table into smaller tables and defining relationships between them.

• Normalization is divided into several normal forms, each with its own set of rules.

• The most commonly used normal forms are first normal form (1NF), second normal form (2NF), and third normal form (3NF).