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

Questions 26–30

1. 26application · easy

   A database has two tables: Customer (CustomerID, CustomerName) and Order (OrderID, CustomerID, OrderDate). The database administrator wants to ensure that an order cannot be created for a customer that does not exist. Which constraint should be added to the Order table?

   • AAn index on Order.CustomerID.
   • BA primary key on Order.CustomerID.
   • CA unique constraint on Order.CustomerID.
   • DA foreign key on Order.CustomerID referencing Customer.CustomerID.
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   Which of the following is a benefit of using stored procedures?

   • AThey eliminate the need for database backups
   • BThey improve security by allowing controlled access to data
   • CThey prevent all SQL injection attacks
   • DThey automatically create indexes on tables
   Reveal Solution Discussion Select an answer first
4. 28foundation · easy

   What is a stored procedure in a relational database?

   • AA security policy for database access
   • BA backup of database data
   • CA set of SQL statements that can be saved and reused
   • DA type of index for speeding up queries
   Reveal Solution Discussion Select an answer first
5. 29foundation · easy

   Which clause in a SELECT statement is used to filter rows based on a condition?

   • AHAVING
   • BORDER BY
   • CWHERE
   • DGROUP BY
   Reveal Solution Discussion Select an answer first
6. 30foundation · easy

   Which of the following is a key feature of relational data?

   • AData is stored in flat files with no structure
   • BData is stored in nested JSON documents
   • CData is stored as graphs of nodes and edges
   • DData is organized into tables with rows and columns
   Reveal Solution Discussion Select an answer first