โ† Infosys questions
Reported in a candidate post, Jul 2022

Database views, DDL/DML, joins, keys, and normalization

Filed under Infosys

The question

Explain views in DBMS and provide the command to create one. Discuss DDL vs DML commands, how to drop a column, differences between inner and outer joins, primary vs foreign keys, and explain Normalization along with 2NF and BCNF.

No write-up yet. Related questions below have one.

Related Infosys questions

Collected from public candidate posts and coding forums. Updated Nov 2026.