Week 5

Question 1

Database security involves measures to avoid?

Answer 1

1. Theft and fraud
2. loss of confidentiality
3. loss of privacy
4. loss of integrity
5. loss of availability

Question 2

What is Threat?

Answer 2

Threat is any situation or event, whether intentional or unintentional, that will adversely affect a system and consequently an organization.

Question 3

2 jenis approach untuk access controls dalam DBMS?

Answer 3

1. DAC (Discretionary Access Control)
   Each user is given appropriate access rights or privileges on specific database objects through the GRANT and REVOKE commands. GRANT command gives privileges to users and REVOKE command takes away privileges.
2. MAC (Mandatory Access Control)
   This approach, each database object is assigned a SECURITY CLASS and each user is assigned a CLEARANCE for a security class, and RULES are imposed on reading and writing of database objects by users.

Question 4

What is View?

Answer 4

A view is the dynamic result of one or more relational operations operating on the base relations to produce another relation.

Question 5

What is Backup?

Answer 5

The process of periodically copying of the database and log file (and possibly programs) to offline storage media.

Question 6

What is Journaling?

Answer 6

The process of keeping and maintaining a log file ( or journal) of all changes made to the database to enable recovery to be undertaken effectively in the event of a failure.

Question 7

What is Integrity?

Answer 7

Prevents data from becoming invalid, and hence giving misleading or incorrect results.

Question 8

What is Encryption?

Answer 8

The encoding of the data by a special algorithm that renders the data unreadable by any program without the decryption key.

Question 9

RAID (Redundant Array of Independent Disks)

Answer 9

RAID works on having a large disk array comprising an arrangement of several independent disks that are organized to improve reliability and at the same time increase performance.

Levels:
RAID 0 Nonredundant
RAID 1 Mirrored
RAID 0+1 Nonredundant and Mirrored
RAID 2 Memory-Style Error-Correcting Codes   RAID 3 Bit-Interleaved Parity
RAID 4 Block-Interleaved Parity
RAID 5 Block-Interleaved Distributed Parity
RAID 6 P+Q Redundancy

Question 10

What is Relation Schema?

Answer 10

relation schema is named relation defined by a set of attribute and domain name pairs

Question 11

Relational database schema?

Answer 11

set of relation schemas, each with a distinct name.

Question 12

5 relational keys?

Answer 12

1. superkey
   an attribute that uniquely identifies a tuple within a relation
2. candidate key
   superkey such that no proper subset is a superkey within the relation.
3. primary key
   candidate key selected to identify tuples uniquely within relation.
4. alternate key
   candidate key that are not selected to be primary key
5. foreign key
   attribute within one relation that matches candidate key of some relation

Question 13

4 integrity constraints?

Answer 13

1. Null
2. Entity integrity
3. referential integrity
4. general constraint

Question 14

6 jenis privileges dalam DAC (Discretionary Access Control)?

Answer 14

1. SELECT
2. INSERT
3. UPDATE
4. DELETE
5. REFERENCES
6. USAGE