1Z0-047 Oracle 10g Database SQL Expert v2.11 278 questions

1Z0-047 Oracle 10g Database SQL Expert v2.11 278 questions 

Retrieving Data Using the SQL SELECT Statement
[  ]	List the capabilities of SQL SELECT statements
[  ]	Execute a basic SELECT statement
[  ]	Describe how schema objects work

Restricting and Sorting Data
[  ]	Limit the rows that are retrieved by a query
[  ]	Sort the rows that are retrieved by a query

Using Single-Row Functions to Customize Output
[  ]	Describe various types of functions that are available in SQL
[  ]	Use character, number, and date functions in SELECT statements
[  ]	Describe the use of conversion functions

Reporting Aggregated Data Using the Group Functions
[  ]	Identify the available group functions
[  ]	Describe the use of group functions
[  ]	Group data by using the GROUP BY clause
[  ]	Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables
[  ]	Write SELECT statements to access data from more than one table using equijoins and nonequijoins
[  ]	Join a table to itself by using a self-join
[  ]	View data that generally does not meet a join condition by using outer joins
[  ]	Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries
[  ]	Define subqueries
[  ]	Describe the types of problems that subqueries can solve
[  ]	List the types of subqueries
[  ]	Write single-row and multiple-row subqueries

Using the Set Operators
[  ]	Describe set operators
[  ]	Use a set operator to combine multiple a single query
[  ]	Control the order of rows returned

Manipulating Data
[  ]	Describe each data manipulation language (DML) statement
[  ]	Insert rows into a table
[  ]	Update rows in a table
[  ]	Delete rows from a table
[  ]	Control transactions

Using DDL Statements to Create and Manage Tables
[  ]	Categorize the main database objects
[  ]	Review the table structure
[  ]	List the data types that are available for columns
[  ]	Create a simple table
[  ]	Explain how constraints are created at the time of table creation

Creating Other Schema Objects
[  ]	Create simple and complex views
[  ]	Retrieve data from views
[  ]	Create, maintain, and use sequences
[  ]	Create and maintain indexes
[  ]	Create private and public synonyms

Managing Objects with Data Dictionary Views
[  ]	Use the data dictionary views to research data on your objects
[  ]	Query various data dictionary views

Controlling User Access
[  ]	Differentiate system privileges from object privileges
[  ]	Grant privileges on tables
[  ]	View privileges in the data dictionary
[  ]	Grant roles
[  ]	Distinguish between privileges and roles

Managing Schema Objects
[  ]	Add constraints
[  ]	Create indexes
[  ]	Create indexes using the CREATE TABLE statement
[  ]	Creating function-based indexes
[  ]	Drop columns and set column UNUSED
[  ]	Perform FLASHBACK operations
[  ]	Create and use external tables

Manipulating Large Data Sets
[  ]	Manipulate data using subqueries
[  ]	Describe the features of multitable INSERTs
[  ]	Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot)
[  ]	Merge rows in a table
[  ]	Track the changes to data over a period of time

Generating Reports by Grouping Related Data
[  ]	Use the ROLLUP operation to produce subtotal values
[  ]	Use the CUBE operation to produce crosstabulation values
[  ]	Use the GROUPING function to identify the row values created by ROLLUP or CUBE
[  ]	Use GROUPING SETS to produce a single result set

Managing Data in Different Time Zones
[  ]	Use Various datetime functions

Retrieving Data Using Subqueries
[  ]	Write a multiple-column subquery
[  ]	Use scalar subqueries in SQL
[  ]	Solve problems with correlated subqueries
[  ]	Update and delete rows using correlated subqueries
[  ]	Use the EXISTS and NOT EXISTS operators
[  ]	Use the WITH clause

Hierarchical Retrieval
[  ]	Interpret the concept of a hierarchical query
[  ]	Create a tree-structured report
[  ]	Format hierarchical data
[  ]	Exclude branches from the tree structure

Regular Expression Support
[  ]	Using Meta Characters
[  ]	Regular Expression Functions
[  ]	Replacing Patterns
[  ]	Regular Expressions and Check Constraints

1Z0-047 Oracle 10g Database SQL Expert v2.11 278 questions

Download Password: 047ora