Title: Chapter 10 Managing Data and Concurrency
Course: RITA MC - ORACLE ADMINISTRATION I > Section: Unit 2 - Database Administration I

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 examinations, but DML is assumed knowledge for the DBA curriculum. It is unlikely that
SQL syntax will be tested in the DBA OCP examinations, but a thorough understanding of how DML
statements are executed and of commit processing is essential.

Chapter 10 Learning Outcomes:

- How to Manage Data Using DML
- Ability to Identify and Administer PL/SQL Objects
- How to Monitor and Resolve Locking Conflicts

*Quizzes for Chapters 6 through 11 are all open until Exam 2 date.

One of the most important things to be successful in this course is to learn to navigate and locate assignments and information.  When in doubt, go to Modules!