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.