You are writing a database application to run on your DBMS. You do not want your users to be able to view the underlying table structures. At the same time you want to allow certain update operations. Referring to the above scenario, what structure will you deploy?

  1. Cursor table

  2. Table filter

  3. Dynamic procedure

  4. View

  5. Summary table


Correct Option: D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Cursor table - This option is incorrect because a cursor table is used to hold the result set of a query temporarily and does not provide any control over the visibility of underlying table structures.

Option B) Table filter - This option is incorrect because a table filter is used to limit the rows displayed in a result set based on specified conditions, but it does not provide control over the visibility of table structures.

Option C) Dynamic procedure - This option is incorrect because a dynamic procedure is used to execute a sequence of SQL statements dynamically, but it does not provide control over the visibility of table structures.

Option D) View - This option is correct because a view is a virtual table that is based on the result of a query. It allows users to interact with the data without directly accessing the underlying table structures. Views can be used to restrict access to certain columns or rows, providing control over what data users can see. In this scenario, using a view would allow the users to perform update operations while hiding the underlying table structures.

Option E) Summary table - This option is incorrect because a summary table is created by aggregating data from one or more tables to provide summary information. It does not provide control over the visibility of underlying table structures.

The correct answer is D) View. This option is correct because it allows users to interact with the data without directly accessing the underlying table structures, while still allowing certain update operations.

Find more quizzes: