The 1Z0-051 exam is designed for candidates and professional who want
to make their successful career in IT industry with 1Z0-051, Oracle
Database 11g: SQL Fundamentals I. Candidate training plan for Oracle certification
examination must include on-the-job experience or hands-on practice executing
the tasks explained in the below examination subjects. Oracle University
learning courses might not involve all examination subjects and an integrated
examination training approach is suggested. Following are the subjects that
will be covered in examination.
Retrieving Data Using the SQL SELECT Statement
·
Perform a basic SELECT statement
·
List the abilities of SQL SELECT statements
Restricting and Sorting Data
·
Sort the rows that are retrieved by a query
·
Limit the rows that are retrieved by a query
·
Use ampersand substitution to sort and restrict
outcome at runtime
Using Single-Row Functions to Customize Output
·
Use number, character and date functions in
SELECT statements
·
Explain various types of functions accessible in
SQL
Using Conversion Functions and Conditional Expressions
·
Utilize the TO_DATE and TO_CHAR, TO_NUMBER
conversion functions
·
Explain different types of conversion functions
that are accessible in SQL
·
Apply conditional expressions in a SELECT
statement
Reporting Aggregated Data Using the Group Functions
·
Illustrate the utilization of group functions
·
Classify the accessible group functions
·
Include or exclude grouped rows by use of the
HAVING clause
·
Group data by use of the GROUP BY clause
Displaying Data from Multiple Tables
·
Join a table to itself by use of a self-join
·
Write SELECT statements to access data from more
than one table use of nonequijoins and equijoins
·
Create a Cartesian product of all rows from two
or more tables
·
View data that generally does not meet a join
condition by use of outer joins
Using Subqueries to Solve Queries
·
Write single-row and multiple-row subqueries
·
List the kinds of subqueries
·
Explain the kinds of issues that the subqueries
can solve
·
Describe subqueries
Using the Set Operators
·
Explain set operators
·
Control the order of rows returned
·
Use a set operator to combine multiple queries
into a single query
Manipulating Data
·
Control transactions
·
Delete rows from a table
·
Update rows in a table
·
Insert rows into a table
·
Explain each data manipulation language (DML)
statement
Using DDL Statements to generate and handle Tables
·
Explain how schema objects work
·
Clarify how constraints are created at the time
of table creation
·
Generate a simple table
·
List the data kinds that are accessible for
columns
·
Review the table structure
·
Sort the main database objects
Creating Other Schema Objects
·
Generate public and private synonyms
·
Generate and sustain indexes
·
Generate, sustain, and utilization sequences
·
Retrieve data from views
·
Generate simple and complex views
No comments:
Post a Comment