OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

3

Manipulating Data

CERTIFICATION OBJECTIVES

3.01     Truncate Data

3.02     Insert Rows into a Table

3.03     Update Rows in a Table

3.04     Delete Rows from a Table

3.05     Control Transactions

   ✓        Two-Minute Drill

Q&A     Self Test

This chapter begins to look at that part of SQL known as Data Manipulation Language. We’ll get some perspective by looking at DML with regard to where it fits into the larger context of SQL. Then we will review DML statements and their usage and look at some specific examples. Finally we will review some supplemental statements that are used to control transactions involving DML.

CERTIFICATION OBJECTIVE ...