Wiley OCA: Oracle Database 11g Administrator Certified Associate Study Guide: (Exams1Z0-051 and 1Z0-052) 978-0-470-39512-7 사용자 설명서

Oracle 11g is a very powerful and feature-rich relational data-
base management system (RDBMS). SQL has been adopted 
by most RDBMSs for the retrieval and management of data, 

schema creation, and access control. The American National Standards Institute (ANSI) 
has been refining standards for the SQL language for more than 20 years. Oracle, like 
many other companies, has taken the ANSI standard of SQL and extended it to include 
much additional functionality.

SQL is the basic language used to manipulate and retrieve data from the Oracle Database 

11g. SQL is a nonprocedural language, meaning it does not have programmatic constructs 
such as loop structures. PL/SQL is Oracle’s procedural extension of SQL, and SQLJ allows 
embedded SQL operations in Java code. The scope of the Oracle Database 11g SQL Funda-
mentals I test includes only SQL.

In this chapter, I will discuss Oracle SQL fundamentals such as the various types of 

SQL statements, introduce SQL*Plus and a few SQL*Plus commands, and discuss 

SELECT

 

statements.

You will learn how to write basic SQL statements to retrieve data from tables. This will 

include coverage of SQL 

SELECT

 statements, which are used to query data from the database-

storage structures, such as tables and views. You will also learn how to limit the information 
retrieved and to display the results in a specific order.

Exam objectives are subject to change at any time without prior notice and 
at Oracle’s sole discretion. Please visit Oracle’s Training and Certification 
website at 

http://education.oracle.com/pls/web_prod-plq-dad/ 

db_pages.getpage?p_exam_id=1Z0_051

 for the most current exam 

objectives.

SQL Fundamentals

SQL is the standard language to query and modify data as well as manage databases. SQL is 
the common language used by programmers, database administrators, and users to access and 
manipulate data as well as to administer databases. To get started with SQL in this chapter, 
I will show how to use the sample 

HR

 schema supplied with the Oracle Database 11g.

95127c01.indd   4

2/18/09   6:37:06 AM