Database Security

Database Security Database security is concerned with authorization rules, user- defined procedures, and data encryption and authentication scheme. These are the database security rules Authentication Rules Authentication rules are restriction…

Continue Reading Database Security

Deadlock In Database

Deadlock In Database Deadlock In Database: Record locking mechanism may create an undesirable situation where two or more users are waiting for the completion of each other’s actions. This situation…

Continue Reading Deadlock In Database

Record Locking In Database

Record Locking In Database Record Locking In Database: Record Locking mechanism is the most common method to implement the concurrency control in DBMS. Locking means record or set of records…

Continue Reading Record Locking In Database

SQL as Data Manipulation Language

SQL as Data Manipulation Language   SQL as Data Manipulation Language: Besides of retrieving data from database using SELECT statement, SQL also provide the statements to manipulate the data of…

Continue Reading SQL as Data Manipulation Language

Aggregate Function

Aggregate Function Aggregate Function: The aggregate function is also required in many database applications for generating reports. SQL provides this feature also. SQL provides built-in aggregate functions that are mostly…

Continue Reading Aggregate Function