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

Questions 31–35

1. 31foundation · easy

   What is the requirement for a table to be in first normal form (1NF)?

   • AAll columns must be defined with a NOT NULL constraint
   • BAll non-key attributes must depend on the entire primary key
   • CAll attributes must be atomic and each column must contain only one value
   • DThere must be no transitive dependencies between non-key attributes
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   Which SQL statement is used to add a new row to a table?

   • ADELETE
   • BSELECT
   • CINSERT
   • DUPDATE
   Reveal Solution Discussion Select an answer first
4. 33foundation · easy

   Which of the following is a benefit of using views?

   • AThey can hide the complexity of queries and provide a simplified interface
   • BThey automatically update underlying tables when data changes
   • CThey store data redundantly for faster access
   • DThey replace the need for indexes
   Reveal Solution Discussion Select an answer first
5. 34expert · hard

   A database administrator is designing a stored procedure that will be used by multiple applications to transfer funds between two accounts. The procedure must ensure that the debit from one account and the credit to another account happen atomically. The administrator also wants to prevent other transactions from reading intermediate states. Which feature should the stored procedure use?

   • AA trigger that fires after the debit operation.
   • BA transaction with an appropriate isolation level.
   • CA view that shows both account balances.
   • DAn index on the account number column.
   Reveal Solution Discussion Select an answer first
6. 35foundation · easy

   What is the effect of the following SQL statement? UPDATE Products SET Price = 20 WHERE ProductID = 5;

   • AIt changes the Price to 20 for the product with ProductID 5
   • BIt adds a new product with ProductID 5 and Price 20
   • CIt selects the product with ProductID 5
   • DIt deletes the product with ProductID 5
   Reveal Solution Discussion Select an answer first