LEADER 05196nam 22006614a 450 001 9910778843903321 005 20230607212351.0 010 $a1-280-65252-7 010 $a9786610652525 010 $a0-585-47721-3 010 $a0-7821-5250-3 035 $a(CKB)111035898498542 035 $a(EBL)275863 035 $a(OCoLC)476021388 035 $a(SSID)ssj0000213375 035 $a(PQKBManifestationID)11175705 035 $a(PQKBTitleCode)TC0000213375 035 $a(PQKBWorkID)10150537 035 $a(PQKB)10486056 035 $a(MiAaPQ)EBC275863 035 $a(Au-PeEL)EBL275863 035 $a(CaPaEBR)ebr10152552 035 $a(CaONFJC)MIL65252 035 $a(EXLCZ)99111035898498542 100 $a20011211d2002 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOCA/OCP$b[electronic resource] $eintroduction to Oracle9i SQL : study guide /$fChip Dawes, Biju Thomas 205 $a1st ed. 210 $aSan Francisco, CA $cSybex$d2002 215 $a1 online resource (611 p.) 300 $a"Exam 1Z0-007"--Cover. 311 $a0-7821-4062-9 327 $aOCA/OCP: Introduction to Oracle9i SQL; Acknowledgments; Contents at a Glance; Contents; Introduction; Why Become an Oracle Certified Professional?; What Does This Book Cover?; How to Contact the Authors; Assessment Test; Answers to Assessment Test; Chapter 1: Basic SQL SELECT Statements; SQL Fundamentals; Writing Simple Queries; Other Operators; Sorting Rows; Using Expressions; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 2: SQL*Plus Overview; SQL*Plus Fundamentals; Producing More Readable Output 327 $aAccepting Values at RuntimeUsing iSQL*Plus; Summary; Exam Essentials; Key Terms; Commands Used in This Chapter; Review Questions; Answers to Review Questions; Chapter 3: Single-Row Functions; Single-Row Function Fundamentals; NULLs and Single-Row Functions; Using Single-Row Character Functions; Using Single-Row Numeric Functions; Using Single-Row Date Functions; Using Single-Row Conversion Functions; Using Other Single-Row Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 4: Aggregating Data And Group Functions; Group Function Fundamentals 327 $aUsing Group FunctionsNesting Functions; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 5: Joins and Subqueries; Multiple-Table Queries; Subqueries; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 6: Modifying Data; Using DML Statements; Inserting into Multiple Tables; Updating Rows in a Table; Merging Rows into a Table; Deleting Rows from a Table; Truncating a Table; Selecting Rows; Locking a Table; Understanding Transaction Control; Summary; Exam Essentials; Key Terms; Review Questions 327 $aAnswers to Review QuestionsChapter 7: Managing Tables and Constraints; Database Objects Review; Built-in Datatypes; Creating Tables; Modifying Tables; Managing Constraints; Creating Constraints; Dropping Constraints; Enabling and Disabling Constraints; Deferring Constraint Checks; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 8: Managing Views; Creating and Modifying Views; Using Views; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 9: Other Database Objects; Creating and Managing Sequences 327 $aCreating and Managing SynonymsCreating and Managing Indexes; Calling Stored Programs; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Chapter 10: User Access and Security; Creating and Modifying User Accounts; Creating and Using Roles; Granting and Revoking Privileges; Managing User Groups with Profiles; Summary; Exam Essentials; Key Terms; Review Questions; Answers to Review Questions; Index 330 $aHere's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i:* In-depth coverage of official exam objectives* Practical information on using SQL in a real-world Oracle9i environment* Hundreds of challenging review questions, in the book and on the CDAuthoritative coverage of all exam objectives, including:* Writing basic SQL SELECT statements* Restricting and sorting data* Displaying data from multiple tables* Aggregating data using group functions* Producing readable output with iSQL*Plus* Creating and managing tables* Controlling 606 $aElectronic data processing personnel$xCertification 606 $aDatabase management$xExaminations$vStudy guides 606 $aSQL (Computer program language) 615 0$aElectronic data processing personnel$xCertification. 615 0$aDatabase management$xExaminations 615 0$aSQL (Computer program language) 676 $a005.75/85 700 $aDawes$b Chip$01505689 701 $aThomas$b Biju$01505690 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910778843903321 996 $aOCA$93735423 997 $aUNINA