In principle, the expected answer is correct, but since the stored procedure is not executed at all in the sample code, the expected answer is still incorrect.

In my opinion, the answer given as correct one, is wrong. Stored Procedures Parameters have to be read from sys.parameters.

The correct Answer choice was not available

The correct answer should be "Create Certificate". There is no LOAD CERTIFICATE Command.

The question is not formulated correctly and therefore gives a wrong answer

"Transparent data encryption" remains an Enterprise Edition Feature and isn't available on Standard Edition

How do you use the statment? With a correct Syntax there is no error

Returns a value cast to the specified data type, if the cast succeeds. Otherwise, NULL ist returned.

The Statement doesn't return Errors

🙂

the correct answer should be 5 🙂

Hi all

The suggested Answer is wrong