Database Security

What is required for controlling concurrent execution of the operations that take place on a database?

• Serializable

• Schedule

• Concurrency Control

• Lock Point

----------- algorithm starts by finding log records for operations that were not written to disk on crash and then replays all of them.

• Shadow Paging

• Two Phase Locking

• Serial Schedules

• ARIES

In which lock the data item can be both reads as well as written by the transactions.

• Exclusive Lock

• Shared Lock

• Two Phase Locking

• Strict Two Phase Locking

In which situation where in two or more transactions are waiting for each other to be finished but none of the task is willing to give up the resources that other task needs.

• ARIES

• Shadow Paging

• Deadlock

• Two Phase Locking

Which refers to the array of controls, tools, and procedures designed to ensure and safeguard confidentiality, integrity, and accessibility.

• Database Security

• SQL Injection Attacks

• SQLi Attack Avenues

• All the above

what serve as the first line of defense in DiD database security.

• Data encryption

• Authentication

• Firewalls

• Authorization

----------- is code injection technique that can compromise your database.

• SQLi Attack Avenues

• Data encryption

• Auditing

• SQL Injection

----------- Injections obtain information about the database structure from error messages issued by the database server.

• Union-Based SQL

• Error-Based SQL

• Blind Boolean-Based SQL

• Blind Time-Based SQL

----------- Injection works by submitting a SQL query to the database and forcing the application to produce a different response depending on whether the query returns TRUE or FALSE.

• Blind Boolean-Based SQL Injections

• Blind Time-Based SQL Injections

• Union-Based SQL Injections

• Error-Based SQL Injections

----------- is both network-based and host-based. It can be tuned to detect SQL injection attacks.

• Web Application Firewall

• Threat detection

• Data encryption

• Intrusion Detection System