xii
OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)
OracCertPrs8/Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)/O’Hearn/161421-4/
Front Matter
2 Using DDL Statements to Create and
Manage Tables ................................ 45
Categorize the Main Database Objects ........................ 46
What Are Database Objects? ........................ 46
Schemas ....................................... 48
Create a Simple Table .................................... 50
Naming a Table or Other Object ...................... 51
The SQL Statement CREATE TABLE ................. 58
Review the Table Structure ................................ 59
List the Data Types That Are Available for Columns ............. 60
Character ...................................... 61
Numeric ....................................... 62
Date .......................................... 63
Large Objects (LOBs) ............................. 65
Explain How Constraints Are Created at the Time of Table Creation ... 67
Creating CONSTRAINTS in the CREATE TABLE
Statement .................................... 67
The Types of CONSTRAINTS ...................... 72
Certification Summary ................................... 81
3 Two-Minute Drill ................................. 82
Q&A Self Test ....................................... 84
Self Test Answers ................................. 89
3 Manipulating Data ............................ 93
Describe Each Data Manipulation Language (DML) Statement ...... 94
SQL Statement Overview .......................... 94
DML Statement Descriptions ........................ 98
Insert Rows into a Table .................................. 98
Default Column List .............................. 99
Enumerated Column List ........................... 103
Update Rows in a Table .................................. 106
Expressions ..................................... 108
Constraints ..................................... 108
The WHERE Clause .............................. 110
Delete Rows from a Table ................................. 111
Control Transactions .................................... 112
COMMIT ...................................... 112
ROLLBACK .................................... 116
- 1
- 2
前往页