没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
Oracle
®
Database 11g
Administrator Certifi ed
Associate
STUDY GUIDE
Biju Thomas
Covers Both the 1Z0-051 and 1Z0-052 Exams!
OCA
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 PDF
Exams 1Z0-051
and 1Z0-052
SERIOUS SKILLS.
OCA
Oracle
®
Database 11g
Administrator Certifi ed Associate
STUDY GUIDE
Thomas
FEATURED ON THE CD
ISBN: 978-0-470-39512-7
Study, practice, and review for OCA certifi cation in Oracle 11g,
Oracle’s new release of its top-selling database software. Inside
this in-depth guide, you’ll fi nd full coverage of essential topics
for two required OCA certifi cation exams: SQL Fundamentals I
(1Z0-051) and Administration I (1Z0-052). Explore topics such as
basic SQL SELECT statements, group functions, creating schema
objects, restricting and sorting data, and much more with this
essential two-in-one guide. Inside, you’ll fi nd:
Full coverage of all exam objectives in a systematic approach, so you
can be confi dent you’re getting the instruction you need for the exam
Practical hands-on exercises to reinforce critical skills
Real-world scenarios that put what you’ve learned in the context
of actual job roles
Challenging review questions in each chapter to prepare you for
exam day
Exam Essentials, a key feature in each chapter that identifi es critical
areas you must become profi cient in before taking the exam
A handy tear card that maps every offi cial exam objective to the
corresponding chapter in the book, so you can track your exam prep
objective by objective
Biju Thomas,
OCA, OCP, is a senior database administrator with more than 15 years
of Oracle application development and database management experience. He has
coauthored fi ve Oracle certifi cation books published by Sybex and has written articles
for multiple Oracle technical publications.
Prepare for two OCA certifi cation
exams with this one book
$89.99 US
$107.99 CN
ABOUT THE AUTHOR
Look inside for complete coverage
of all exam objectives.
www.sybex.com
SYBEX TEST ENGINE:
Test your knowledge with advanced
testing software. Includes all chapter
review questions and bonus exams.
ELECTRONIC FLASHCARDS:
Reinforce your understanding with
fl ashcards that can run on your PC,
Pocket PC, or Palm handheld.
Also on CD, you’ll fi nd the entire
book in searchable and printable PDF.
Study anywhere, any time, and
approach the exam with confi dence.
CATEGORY
COMPUTERS/Certifi cation Guides
Exam 1Z0-051
Exam 1Z0-052
95127bindex.indd 1086 2/18/09 6:41:41 AM
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.
OCA: Oracle Database 11g Administrator Certified
Associate Study Guide
1Z0-051 Exam Objectives
OBJECTIVE CHAPTER
Retrieving Data Using the SQL SELECT Statement
List the capabilities of SQL SELECT statements 1
Execute a basic SELECT statement 1
Restricting 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 1
Using Single-Row Functions to Customize Output
Describe various types of functions available in SQL 2
Use character, number, and date functions in SELECT statements 2
Using 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 2
Reporting 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 3
Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table using
equijoins and nonequijoins
4
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 4
Using 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
95127bperfcard.indd 1 2/17/09 5:08:51 PM
OBJECTIVE CHAPTER
Using 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 4
Manipulating 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 5
Using 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 work 6
Creating Other Schema Objects
Create simple and complex views 7
Retrieve data from views 7
Create, maintain, and use sequences 7
Create and maintain indexes 7
Create private and public synonyms 7
1Z0-052 Exam Objectives
OBJECTIVE CHAPTER
Exploring the Oracle Database Architecture
Explain the Memory Structures 8
Describe the Process Structures 8
Overview of Storage Structures 8
Preparing the Database Environment
Identify the tools for Administering an Oracle Database 8
Plan an Oracle Database installation 8
Install the Oracle software by using Oracle Universal Installer (OUI) 8
95127bperfcard.indd 2 2/17/09 5:08:51 PM
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 CHAPTER
Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA) 9
Managing the Oracle Instance
Setting database initialization parameters 9
Describe the stages of database startup and shutdown 9
Using alert log and trace files 9
Using data dictionary and dynamic performance views 9
Configuring the Oracle Network Environment
Configure and Manage the Oracle Network 11
Using the Oracle Shared Server architecture 11
Managing Database Storage Structures
Overview of tablespace and datafiles 10
Create and manage tablespaces 10
Space management in tablespaces 10
Administering User Security
Create and manage database user accounts 12
Grant and revoke privileges 12
Create and manage roles 12
Create and manage profiles 12
Managing Schema Objects
Create and Modify tables 10
Manage Constraints 10
Create indexes 10
Create and use temporary tables 10
Managing Data and Concurrency
Manage data using DML 13
Identify and administer PL/SQL objects 13
Monitor and resolve locking conflicts 13
Managing Undo Data
Overview of Undo 13
Transactions and undo data 13
Managing undo 13
Implementing Oracle Database Security
Database Security and Principle of Least Privilege 12
Work with Standard Database Auditing 12
95127bperfcard.indd 3 2/17/09 5:08:51 PM
剩余1152页未读,继续阅读
资源评论
- 只要开心就好2014-09-23不错,好东西,谢谢分享
littlecat2
- 粉丝: 0
- 资源: 12
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于串口通信的光通信上位机,包括运动控制和通信协议
- 串口与以太网文件传送协议(或自定义控制协议)
- Qt开发windows系统安装教程与代码实例.txt
- QT6实现的附带文件传输协议的串口终端
- 一个串口通讯类和调用Demo 通过设置串口、设置串口自定义协议,可方便对串口发送数据与接收数据
- 华为OD模拟题及参考答案.仅供学习和模拟考试使用
- stm32f103c8t6基于modbus协议和使用串口读取温湿度
- 英雄联盟LOL金克斯4K电脑壁纸
- Microbrain道闸产品上位机,以MahApps库为基础搭建界面,集成了串口(UART)、CAN、WIFI通信,十六进制协议
- Android串口通讯, 支持发送数据回调, 支持并发处理, 自定义协议, CRC校验, 自动粘包, 自动去除冗余的干扰数据
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功