You need to modify Production.ProductDetails_Insert to comply with the application requirements. Which code segment should you execute?
A. ADD SIGNATURE TO Production.ProductDetails_Insert BY CERTIFICATE DBCERT;
B. OPEN PRODUCTSCERT; ALTER PROCEDURE Production.ProductDetails_Insert WITH ENCRYPTION; CLOSE PRODUCTSCERT;
C. OPEN DBCERT; ALTER PROCEDURE Production.ProductDetails_Insert WITH ENCRYPTION; CLOSE DBCERT;
D. ADD SIGNATURE TO Production.ProductDetails_Insert BY CERTIFICATE PRODUCTSCERT;
Answer:B
You need to modify Production.ProductDetails_Insert to comply with the application requirements. Which code segment should you execute?
A. ADD SIGNATURE TO Production.ProductDetails_Insert BY CERTIFICATE DBCERT; B. OPEN PRODUCTSCERT; ALTER PROCEDURE Production.ProductDetails_Insert WITH ENCRYPTION; CLOSE PRODUCTSCERT; C. OPEN DBCERT; ALTER PROCEDURE Production.ProductDetails_Insert WITH ENCRYPTION; CLOSE DBCERT; D. ADD SIGNATURE TO Production.ProductDetails_Insert BY CERTIFICATE PRODUCTSCERT;