Get free 1Z0-007, exam, test, oracle, braindumps, cheat, sheet, braindumps, sheets,
brain dumps, cheet, cheetsheets, testking, cheetsheet, cheatsheet, test questions, exam study guides.

1Z0-007

Oracle Certified Associate Database Administrator
Exam #1Z0-007: Introduction to Oracle 9i: SQL
 
1Z0-007 Braindumps
 
 

Writing Basic SQL Statements

  • List the capabilities of SQL SELECT statements

  • Execute a basic SELECT statement

  • Differentiate between SQL statements and SQL*Plus commands

Restricting and Sorting Data

  • Limit the rows retrieved by a query

  • Sort the rows retrieved by a query

Single Row Functions

  • Describe various types of functions available in SQL

  • Use character, number, and date functions in SELECT statements

  • Use conversion functions

Displaying Data from Multiple Tables

  • Write SELECT statements to access data from more than one table using equality and nonequality joins

  • View data that generally does not meet a join condition by using outer joins

  • Join a table to itself using a self join.

Aggregating Data Using Group Functions

  • Identify the available group functions

  • Use group functions

  • Group data using the GROUP BY clause

  • Include or exclude grouped rows by using the HAVING clause.

 
 

Index
 

1Z0-001  |  1Z0-007  |  1Z0-031