By Chip Dawes
This article covers the 1st examination within the DBA song in Oracle's certification programme. It encompasses a self-assessment try, key-terms sections, evaluate questions, and perform checks, plus an more desirable CD with checking out software program.
Read Online or Download OCP: Oracle8i DBA SQL and PL-SQL study guide PDF
Similar oracle books
Oracle Database 11g New Features
FOREWORD through Tom Kyte Your Must-Have advisor to every little thing New in Oracle Database 11gRealize the entire strength of Oracle Database 11g with aid from the specialists. Written by means of Robert G. Freeman, and with insightful observation all through from Arup Nanda, this Oracle Press advisor deals complete info at the architectural alterations, database management enhancements, availability and restoration revisions, safeguard improvements, and programming thoughts.
Oracle Database 10g, A Beginner's Guide
Presents starting DBAs and builders with a superb origin within the database management and programming fundamentals had to embark on an Oracle occupation. the point of interest is on Oracle Database 10g, yet you’ll get the basics acceptable to all Oracle database releases.
Pro Oracle Database 12c Administration
Professional Oracle Database 12c management is a booklet concerned with effects. writer Darl Kuhn attracts from a good of expertise over a decade deep to put out real-world suggestions that result in luck as an Oracle Database administrator. He provides transparent factors on easy methods to practice serious projects. He weaves in thought the place priceless with out bogging you down in unneeded element.
Oracle Application Express for Mobile Web Applications
Oracle software exhibit is celebrated within the Oracle group as a useful gizmo for growing internet purposes compatible for machine browsers. positive aspects have now been further to open up the area of cellular searching, bringing the simplicity and expressiveness of Appliction convey to endure in constructing purposes to run with an almost-native feel and appear on structures reminiscent of iOS, Android, and home windows telephone.
- Oracle Text Reference (Part No A90121-01) (Release 9 0 1)
- Cost-Based Oracle Fundamentals
- Oracle SNMP. Support Reference Guide (Part No. A88768-01) (Release 9.0.1)
- Teach Yourself Oracle8 in 21 Days
- JD Edwards EnterpriseOne, The Complete Reference
- Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database
Additional resources for OCP: Oracle8i DBA SQL and PL-SQL study guide
Example text
4 SQL Statement Categories SQL Category Description Data Definition Data definition language (DDL) statements are used to define, alter, or drop database objects. Examples are CREATE TABLE, ALTER INDEX, GRANT, REVOKE, TRUNCATE, ANALYZE, and so on. Data Manipulation Data manipulation language (DML) statements are used to access, create or manipulate data in the existing structures of the database. Examples are SELECT, INSERT, UPDATE, DELETE, LOCK TABLE, EXPLAIN, and so on. Transaction Control Transaction control statements manage the changes made by the DML statements, whether to save them or discard them.
1 Application Development Cycle Strategy & Analysis Design Building & Documentation Testing Implementation The Logical Model In the design phase of the system development cycle, a logical model of the database is created. A logical model of an RDBMS is typically a block diagram of entities and relationships, referred to as an ER diagram. An ER model has Entities Relationships Attributes An ER model is visual, showing the structure, characteristics, and interactions within and around the data being modeled.
14. C. The ALTER TABLE statement is used to create and remove constraints. Option D would work if it included the keyword constraint between drop and pk_books. Chapter 6 discusses constraints. 15. A, B. Option A uses the correct positional notation; Option B uses the correct named notational styles. For more information about positional and named notation, see Chapter 6. 16. A. This kind of question, which quizzes you on precise syntax, really does appear on the exam. Especially for sequences, know the syntactical spelling.