Câu 7: PEGACRSA80V1: Certified Robotics System Architect (CRSA) 80V1

You have a requirement that must return the OrderDate, OrderStatus, and OrderAmount for all orders for a given customer account in a SQL database. How should the SQL query be specified in the CommandText property of the SqlQuery component?

1. A. SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber={accountNumber} — đáp án hiện tại
2. B. SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber=?accountNumber
3. C. SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber={0}
4. D. SELECT OrderDate, OrderStatus, OrderAmount FROM Orders where AccountNumber=@accountNumber