locked
Saving answers of exam tests more securly RRS feed

  • Question

  • User-1228297939 posted

    Hi guys!

    i am developing exam test web based project on .net C#. Currently,i am getting some troubles saving test answers in database.

    I wanna save test answers such as no one can understand when open tables from database, I mean i dont want to save just adding a column using "IsCorrect": True/False. I think you already understood what i meant.

     I know u all very smart developers. U will have any unique idea to solve this problem!

    Thanks, A

    Sunday, September 7, 2014 11:43 AM

Answers

  • User197322208 posted

    1. you can name fields as fieldA, fieldB and so on. Make a mapping

    2. You can put data in XML format and encrypt 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, September 7, 2014 2:39 PM
  • User-1151753377 posted

    Hi Aziz,

    wanna save test answers such as no one can understand when open tables from database

    Based on my understanding, I agreed with what @ignatandrei said, you could use the encryption technology.

    Something like this:

    USE encrypt_test;
    GO
    -- Opens the symmetric key for use
    OPEN SYMMETRIC KEY SymmetricKey1
    DECRYPTION BY CERTIFICATE Certificate1;
    GO
    UPDATE Customer_data
    SET Credit_card_number_encrypt = EncryptByKey (Key_GUID('SymmetricKey1'),Credit_card_number)
    FROM dbo.Customer_data;
    GO
    -- Closes the symmetric key
    CLOSE SYMMETRIC KEY SymmetricKey1;
    GO

    More information about the encryption technology, please refer to the links below:

    http://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/

    If there’s anything you’d like to know, don’t hesitate to ask.

    Best Regards,

    Summer

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 10, 2014 3:23 AM

All replies

  • User197322208 posted

    1. you can name fields as fieldA, fieldB and so on. Make a mapping

    2. You can put data in XML format and encrypt 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, September 7, 2014 2:39 PM
  • User-1151753377 posted

    Hi Aziz,

    wanna save test answers such as no one can understand when open tables from database

    Based on my understanding, I agreed with what @ignatandrei said, you could use the encryption technology.

    Something like this:

    USE encrypt_test;
    GO
    -- Opens the symmetric key for use
    OPEN SYMMETRIC KEY SymmetricKey1
    DECRYPTION BY CERTIFICATE Certificate1;
    GO
    UPDATE Customer_data
    SET Credit_card_number_encrypt = EncryptByKey (Key_GUID('SymmetricKey1'),Credit_card_number)
    FROM dbo.Customer_data;
    GO
    -- Closes the symmetric key
    CLOSE SYMMETRIC KEY SymmetricKey1;
    GO

    More information about the encryption technology, please refer to the links below:

    http://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/

    If there’s anything you’d like to know, don’t hesitate to ask.

    Best Regards,

    Summer

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 10, 2014 3:23 AM