O'Reilly logo

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052) by John Watson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

10 Managing Data and Concurrency

CERTIFICATION OBJECTIVES

10.01 Manage Data Using DML

10.02 Identify and Administer PL/SQL Objects

10.03 Monitor and Resolve Locking Conflicts

image Two-Minute Drill

image Self Test

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required