10 Managing Data and Concurrency
CERTIFICATION OBJECTIVES
10.02 Identify and Administer PL/SQL Objects
10.03 Monitor and Resolve Locking Conflicts
Data in a relational database is managed with the DML (data manipulation language) commands of SQL. These are INSERT, UPDATE, DELETE, and (with more recent versions of SQL) MERGE. Associated with these are the transaction control statements COMMIT and ROLLBACK. These commands are dealt with in detail in the SQL curriculum and tested in the appropriate ...
Get OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.