OCA: Oracle Database 11g Administrator Certified Associate- P1

Nhờ đầu tiên để Jeff Kellum và Sybex cho niềm tin vào tôi để viết cuốn sách này. Tôi cũngcảm ơn những người tuyệt vời sau đây tại Sybex cho hỗ trợ của họ, kiên nhẫn với tôislipping lịch trình, và làm việc tốt: Denise Santoro Lincoln (phát triển của biên tập) cho cô ấygiá trị các ý kiến, chỉnh sửa chu đáo, kiên nhẫn, và đảm bảo các chương có một mịndòng chảy; Eric Charbonneau (sản xuất biên tập) cho việc bảo đảm các phần khác nhau của cuốn sách tievới nhau; Candace tiếng Anh cho proofreading; và Pete...
Nội dung trích xuất từ tài liệu:
OCA: Oracle Database 11g Administrator Certified Associate- P1 Covers Both the 1Z0-051 and 1Z0-052 Exams! Includes Real-World Scenarios, Hands-On Exercises, and Leading-Edge Exam Prep Software Featuring: • Custom Test Engine • Hundreds of Sample Questions • Electronic Flashcards for PCs, Pocket PCs, and Palm Handhelds • Entire Book in PDFOCAOracle Database 11g ®Administrator CertifiedAssociateSTUDY GUIDE Exams 1Z0-051 Biju Thomas and 1Z0-052 SERIOUS SKILLS.OCA: Oracle Database 11g Administrator CertifiedAssociate Study Guide1Z0-051 Exam ObjectivesObjective chapterretrieving Data Using the SQL SeLect Statement List the capabilities of SQL SELECT statements 1 Execute a basic SELECT statement 1restricting and Sorting Data Limit the rows that are retrieved by a query 1 Sort the rows that are retrieved by a query 1 Use ampersand substitution to restrict and sort output at runtime 1Using Single-row Functions to customize Output Describe various types of functions available in SQL 2 Use character, number, and date functions in SELECT statements 2Using conversion Functions and conditional expressions Describe various types of conversion functions that are available in SQL 2 Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions 2 Apply conditional expressions in a SELECT statement 2reporting aggregated Data Using the Group Functions Identify the available group functions 3 Describe the use of group functions 3 Group data by using the GROUP BY clause 3 Include or exclude grouped rows by using the HAVING clause 3Displaying Data from Multiple tables Write SELECT statements to access data from more than one table using 4 equijoins and nonequijoins Join a table to itself by using a self-join 4 View data that generally does not meet a join condition by using outer joins 4 Generate a Cartesian product of all rows from two or more tables 4Using Subqueries to Solve Queries Define subqueries 4 Describe the types of problems that the subqueries can solve 4 List the types of subqueries 4 Write single-row and multiple-row subqueries 4 Exam specifications and content are subject to change at any time without prior notice and at Oracle’s sole discretion. Please visit Oracle’s website ( http:// education.oracle.com) for the most current information on their exam content.Objective chapterUsing the Set Operators Describe set operators 4 Use a set operator to combine multiple queries into a single query 4 Control the order of rows returned 4Manipulating Data Describe each data manipulation language (DML) statement 5 Insert rows into a table 5 Update rows in a table 5 Delete rows from a table 5 Control transactions 5Using DDL Statements to create and Manage tables Categorize the main database objects 6 Review the table structure 6 List the data types that are available for columns 6 Create a simple table 6 Explain how constraints are created at the time of table creation 6 Describe how schema objects wo ...