You need to provide the ability to query race results without allowing access to other information in the database

You are developing a database that other programmers will query to display race results.
You need to provide the ability to query race results without allowing access to other
information in the database.
What should you do?

You are developing a database that other programmers will query to display race results.
You need to provide the ability to query race results without allowing access to other
information in the database.
What should you do?

A.
Disable implicit transactions.

B.
place the query jnt0 a stored procedure.

C.
Create an index on the result table.

D.
Add an AFTER UPDATE trigger on the result table to reject updates.



Leave a Reply 5

Your email address will not be published. Required fields are marked *


R

R

It should be letter B. 🙂

Anar BHOS

Anar BHOS

Please dont write only letter variant.exlapin if possible.who see your writing a or letter b or c,dont know whether to choose your answer or answer above

Ayaz_Samadli

Ayaz_Samadli

Tamam,Anar,tamam

DB7

DB7

B – Stored Procedure controls access (whether reading or writing)