Security in Databases

Communicator
Tools
Profile Settings

Loading, please wait ...

Open its course - Database Systems

Short Questions for Security in Databases

1 Which security measures are associated with DBMSs on the Web?

Answer
Proxy servers, firewalls, message digest algorithms and digital signatures, digital certificates, kerberos, Secure Sockets Layer (SSL) and Secure HTTP (S-HTTP), Secure Electronic Transactions (SET) and Secure Transaction Technology (SST), Java security, and ActiveX security.
2 What is Discretionary Access Control (DAC)?

Answer
It is an approach to manage privileges. The SQL standard supports DAC through the GRANT and REVOKE commands. The GRANT command gives privileges to users, and the REVOKE command takes away privileges.
3 What are the computer-based security controls in a multi-user environment?
Answer

authorization
access controls
views
backup and recovery
integrity
encryption
RAID technology
4 List down some common know threats for database security?
Answer
Common known threats are:
Using another person’s means of access
Unauthorized amendment or copying of data
Program alteration
Inadequate policies and procedures that allow a mix of confidential and normal output
Wire tapping
Illegal entry by hacker
Blackmail
Creating ‘trapdoor’ into system
Theft of data, programs, and equipment
Failure of security mechanisms, giving greater access than normal
Staff shortages or strikes
Inadequate staff training
Viewing and disclosing unauthorized data
Electronic interference and radiation
Data corruption owing to power loss or surge
Fire (electrical fault, lightning strike, arson), flood, bomb
Physical damage to equipment
Breaking cables or disconnection of cables
Introduction of viruses
5 In which situations database security should be considered important?
Answer
We consider database security in relation to the following situations:
Theft and fraud
Loss of confidentiality
Loss of privacy
Loss of integrity
Loss of availability
6 Types Of Locks??

Answer
1. Shared Lock When a shared lock is applied on data item, other transactions can only read the item, but can't write into it. 2. Exclusive Lock When an exclusive lock is applied on data item, other transactions can't read or write into the data item.

Subject Expert

Learn, Evaluate and Optimize

Home

Click to open

Courses

Short Questions for Security in Databases

1 Which security measures are associated with DBMSs on the Web?

2 What is Discretionary Access Control (DAC)?

3 What are the computer-based security controls in a multi-user environment?

4 List down some common know threats for database security?

5 In which situations database security should be considered important?

6 Types Of Locks??

Subject Expert

Learn, Evaluate and Optimize