SQL DDL, DML, DCL Commands | Dataford Interview Questions

Write commands of types DDL, DML, DCL, TCL

Asked in the Technical stage. Implement a Python function that returns representative SQL commands grouped by these four command types. Use the supplied safe table name in every table-specific command.

Input and Output

table_name is a lowercase identifier containing letters and underscores. Return a dictionary with keys DDL, DML, DCL, and TCL. Each value must be a list of SQL command strings.

Constraints

1 <= len(table_name) <= 30
table_name contains only lowercase letters and underscores
Each category contains at least two commands
The function returns commands as strings and does not execute them

Function Signature

def generate_sql_commands(table_name):

Your question is SQL DDL, DML, DCL Commands. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem