Describe Relational Concepts DP-900 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A company has a business rule that when a new order is placed, the inventory quantity must be decremented and an audit record must be inserted. Multiple applications need to perform this exact sequence. To ensure consistency and avoid duplicating code, what should the database team create?

   • AA stored procedure that performs the insert, update, and audit insert in a transaction.
   • BA view that shows the inventory and orders.
   • CA trigger that fires on every SELECT statement.
   • DAn index on the inventory table.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which problem does normalization primarily solve in a relational database?

   • AData anomalies caused by redundant data
   • BLoss of data during power outages
   • CSlow query performance due to large indexes
   • DUnauthorized access to sensitive data
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   What is a trigger in a relational database?

   • AA type of index that automatically updates itself
   • BA backup that runs on a schedule
   • CA view that refreshes automatically
   • DA stored procedure that runs automatically in response to a database event
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which SQL statement is used to change the value of an existing column in a table?

   • ADELETE
   • BUPDATE
   • CINSERT
   • DSELECT
   Reveal Solution Discussion Select an answer first
6. 25expert · hard

   A bank has a business process to transfer money between accounts. The process must deduct from one account and credit another, and if either step fails, the entire transfer must be rolled back. The bank wants to ensure that all applications use the same logic and that the transfer is atomic. What is the best approach?

   • ACreate a trigger that fires after each UPDATE to perform the second UPDATE.
   • BHave each application run two separate UPDATE statements.
   • CCreate a view that shows both account balances.
   • DCreate a stored procedure that performs both UPDATE statements inside a transaction with error handling that rolls back on failure.
   Reveal Solution Discussion Select an answer first