GIAC
GSSP-.NET · Question #202
GSSP-.NET Question #202: Real Exam Question with Answer & Explanation
Sign in or unlock GSSP-.NET to reveal the answer and full explanation for question #202. The question stem and answer options stay visible for context.
Question
- (Topic 2) You work as a Database Developer for a Web based music company named Music2Music. You are designing a database for online order management application. The customers use the company's Web site to place orders for the music CDs. Orders details are first inserted into an online database named OrdersData. The Orders database includes a table named Orders and a table named OrderDetails. The Orders table contains basic information about the orders. The OrderDetails table contains information about the individual items in the orders. Fragments of the Orders database is given below: Requirements of the database design are given below: l Customers must be able to use the company's Web site to view orders stored in the OrdersData database. l Customers should be able to see only their own orders. l Customers should not be able to modify the orders. l The primary key values of the orders are not relevant to the customers and should not be visible. What will you do?
Options
- ACreate a view that displays the order information for a customer.
- BCreate a stored procedure that retrieves the order information for a customer.
- CGrant SELECT permissions on the Orders and OrderDetails tables to the customers
- DCreate a scalar user-defined function that retrieves the order information for a customer.
Unlock GSSP-.NET to see the answer
You've previewed enough free GSSP-.NET questions. Unlock GSSP-.NET for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.