[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