Category: Certification

[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

• Creating and Managing Schema Objects
• Managing Schema Objects
• DESCRIBE SQL*Plus Command
• Oracle Built-in Data Types
• Creating Tables
• Managing Integrity Constraints

 

1Z0-061 Objectives List

Oracle Database 12c OCA Certification

[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