Sold Out
Book Categories |
Introduction | xv | |
Self-Assessment | xxv | |
Chapter 1 | Oracle OCP Certification Exams | 1 |
Assessing Exam-Readiness | 2 | |
The Testing Situation | 3 | |
Test Layout And Design | 4 | |
Using Oracle's Test Software Effectively | 6 | |
Taking Testing Seriously | 7 | |
Question-Handling Strategies | 7 | |
Mastering The Inner Game | 8 | |
Additional Resources | 9 | |
Chapter 2 | DML: Using The INSERT, UPDATE, And DELETE Commands | 13 |
DML Elements | 14 | |
DML Commands | 36 | |
Practice Questions | 50 | |
Need To Know More? | 56 | |
Chapter 3 | DML: Using The SELECT Command | 57 |
The SELECT Command | 58 | |
Examples Using The SELECT Command | 65 | |
Practice Questions | 86 | |
Need To Know More? | 93 | |
Chapter 4 | DDL: Using the CREATE Command For All Objects | 95 |
The CREATE Command | 96 | |
Oracle8 Object Tables | 116 | |
Practice Questions | 123 | |
Need To Know More? | 130 | |
Chapter 5 | DDL: Object Manipulation Commands | 131 |
Nontable CREATE Commands | 132 | |
Additional Data Structure CREATE And DDL Commands | 149 | |
Practice Questions | 159 | |
Need To Know More? | 164 | |
Chapter 6 | DDL: Using The ALTER, COMMENT, And DROP Commands | 165 |
The ALTER Command | 166 | |
The COMMENT Command | 190 | |
The DROP Command | 191 | |
Practice Questions | 193 | |
Need To Know More? | 200 | |
Chapter 7 | DCL Commands | 201 |
Users | 202 | |
Grants | 207 | |
Roles | 222 | |
Special Roles | 227 | |
Profiles | 230 | |
Practice Questions | 240 | |
Need To Know More? | 246 | |
Chapter 8 | The Oracle Data Dictionary | 247 |
Overview Of The Oracle Data Dictionary | 248 | |
Oracle C Structs And V$ Views | 248 | |
Practice Questions | 269 | |
Need To Know More? | 274 | |
Chapter 9 | Database Design And Modeling | 275 |
The Five-Step System Development Cycle | 276 | |
Database Design | 278 | |
Oracle And The Object Paradigm | 282 | |
Practice Questions | 296 | |
Need To Know More? | 302 | |
Chapter 10 | PL/SQL | 305 |
The PL/SQL Engine | 306 | |
PL/SQL Basics | 306 | |
DML And PL/SQL | 320 | |
Changes For Oracle8 | 324 | |
Practice Questions | 326 | |
Need To Know More? | 335 | |
Chapter 11 | Sample Test | 337 |
Questions, Questions, Questions | 338 | |
Picking Correct Answers | 338 | |
Decoding Ambiguity | 339 | |
Working Within The Framework | 340 | |
Preparing For The Test | 341 | |
Taking The Test | 341 | |
Sample Test | 343 | |
Chapter 12 | Answer Key | 371 |
Glossary | 385 | |
Index | 397 |
Login|Complaints|Blog|Games|Digital Media|Souls|Obituary|Contact Us|FAQ
CAN'T FIND WHAT YOU'RE LOOKING FOR? CLICK HERE!!! X
You must be logged in to add to WishlistX
This item is in your Wish ListX
This item is in your CollectionOracle8 DBA: SQL and PL/SQL Exam Cram
X
This Item is in Your InventoryOracle8 DBA: SQL and PL/SQL Exam Cram
X
You must be logged in to review the productsX
X
X
Add Oracle8 DBA: SQL and PL/SQL Exam Cram, Contains material previously only available in training materials from Oracle, including key terms and definitions. Includes all technologies covered on the Introduction to Oracle: SQL and PL/SQL examination. Provides practice questions with detailed expl, Oracle8 DBA: SQL and PL/SQL Exam Cram to the inventory that you are selling on WonderClubX
X
Add Oracle8 DBA: SQL and PL/SQL Exam Cram, Contains material previously only available in training materials from Oracle, including key terms and definitions. Includes all technologies covered on the Introduction to Oracle: SQL and PL/SQL examination. Provides practice questions with detailed expl, Oracle8 DBA: SQL and PL/SQL Exam Cram to your collection on WonderClub |