To execute SQL commands in a structured manner, Amit should follow a logical sequence. Here are the steps with explanations:
Following this order is crucial to ensure the SQL commands are correctly executed: (B), (A), (D), (C).
The correct order for Amit to execute the SQL commands is (B), (A), (D), (C).
Additional Context:
-- Correct execution sequence: USE DB; -- Select database CREATE TABLE Student (...); -- Create table INSERT INTO Student (...) -- Insert data VALUES (...); SELECT * FROM Student; -- View data
Correct Answer: (3) (B), (A), (D), (C)
On a relation named Loan of a bank: