OCA12c – 1Z0-061 – Additional Reading 07

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

Chapter 7: Creating Tables and Constraints explains how to create and manage tables and constraints. It also discusses the various data types available in Oracle Database 12c to store data.

  • 10 Introduction to Data Definition Language
    • 10.1 Categorize the main database objects
    • 10.2 Explain the table structure
    • 10.3 Describe the data types that are available for columns
    • 10.4 Create a simple table
    • 10.5 Explain how constraints are created at the time of table creation
    • 10.6 Describe how schema objects work

Reading Material

 

1Z0-061 Objectives List

Oracle Database 12c OCA Certification

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

1Z0-061 Objectives List

Oracle Database 12c OCA Certification