OCA12c – 1Z0-061 – Additional Reading 06

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.

Chapter 6: Manipulating Data explores how to manipulate data – adding, removing, and updating data. The chapter also covers how transaction control works.

• 9 Managing Tables Using DML Statements
  • 9.1 Truncate data
  • 9.2 Insert rows into a table
  • 9.3 Update rows in a table
  • 9.4 Delete rows from a table
  • 9.5 Control transaction

Reading Material

• DML Statements and Transactions
• TRUNCATE Table
• TRUNCATE vs DELETE
• INSERT Statement
• UPDATE Statement
• DELETE Statement
• Transaction Management
• Overview of Transaction Control
• Transaction Control Statements
• Transactions
• Automatic Locks in DML Operations
• Overview of SQL Statements

1Z0-061 Objectives List

Oracle Database 12c OCA Certification