OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition

CHAPTER 6

DML and Concurrency

Exam Objectives

In this chapter, you will learn to

• 061.9.1    Describe Each Data Manipulation Language (DML) Statement

• 061.9.2    Insert Rows into a Table

• 061.9.3    Update Rows in a Table

• 061.9.4    Delete Rows from a Table

• 061.9.5    Control Transactions

• 062.9.1    Explain DML and Undo Data Generation

• 062.9.2    Monitor and Administer Undo Data

• 062.9.3    Describe the Difference between Undo Data and Redo Data

• 062.9.4    Configure Undo Retention

• 062.10.1    Describe the Locking Mechanism and Data Concurrency Management

• 062.10.2    Monitor and Resolve Locking Conflicts

Data in a relational ...