|
||||||
|
Locking is a procedure used to control concurrent access of the data. A lock may deny access to other transaction in order to prevent incorrect results (if multiple people are updating the same data). Locks can be of two types: – • Exclusive lock or Write lock • Shared lock or Read lock - Exclusive [...] Database Integrity is the preservation of data correctly & implies the process of keeping the dbase away from accidental deletion or alteration. There are following types of integrity constraints:- • Entity integrity constraints • Referential integrity constraints • Domain integrity constraints DATABASE SECURITY: – Database security is a measurement of confidence that the integrity of [...] Database security is the set of systems, processes, and procedures that protect a database from unintended activity. Unintended activity can be categorized as authenticated misuse, malicious attacks or inadvertent mistakes made by authorized individuals or processes. Database security is also a specialty within the broader discipline of computer security. The database is the entity where [...] The structured query language (SQL) is the language used to query and manipulate information within a SQL Server database. SQL is actually an ISO and ANSI standardised language. However, a lot of RDBMS software use their own proprietary extensions within their own Transact-SQL (T-SQL) variant of SQL. The basic building block of the structured query [...] |
||||||
|
Copyright © 2012 Learn Software Development - All Rights Reserved |
||||||
Recent Comments