COMPUTER FUNDAMENTALS

EMERGING TRENDS IN COMPUTING

CLOUD COMPUTING

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
How can data be secured in a database?
A
Decryption
B
With a key
C
Encryption
D
A padlock
Explanation: 

Detailed explanation-1: -Open the database in Exclusive mode. How do I open a database in Exclusive mode? On the File tab, click Info, and then click Encrypt with Password. The Set Database Password dialog box appears. Type your password in the Password box, type it again in the Verify box, and then click OK. Notes:

Detailed explanation-2: -Data is encrypted when saved, and decrypted when opened given that the user knows the private key. Thus if the data is to be shared through a database the receiving individual must have a copy of the secret key used by the sender in order to decrypt and view the data.

Detailed explanation-3: -The two types of data encryption methods are Symmetric Encryption and Asymmetric Encryption. Symmetric encryption is also known as private-key cryptography or secret key algorithm and requires both the parties of sender and receiver to have access to the same key to decrypt the data.

Detailed explanation-4: -The four major types of database encryption are: Business Application Encryption (BA), DBMS Application Encryption (DA), DBMS Package Encryption (DP), and DBMS Engine Encryption (DE). Each database encryption takes place at separate layers and often have different functionality and requirements.

There is 1 question to complete.