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

1Z0-001

Oracle Certified Associate Database Administrator
Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL
 
1Z0-001 Braindumps
 
 

Overview of Relational Databases, SQL and PL/SQL

  • Discuss the theoretical and physical aspects of a relational database

  • Describe the Oracle implementation of the RDBMS and ORDBMS

  • Describe the use and benefits of PL/SQL

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

  • Describe the use of 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

Aggregating Data Using Group Functions

  • Identify the available group functions

  • Describe the use of group functions

  • Group data using the GROUP BY clause

  • Include or exclude grouped rows by using the HAVING clause

Subqueries

  • Describe the types of problems that subqueries can solve

  • Define subqueries

  • List the types of subqueries

  • Write single-row and multiple-row subqueries

Multiple-Column Subqueries

  • Write multiple-column subqueries

  • Describe and explain the behavior of subqueries when null values are retrieved

  • Write subqueries in a FROM clause

Producing Readable Output with SQL*Plus

  • Produce queries that require an input variable

  • Customize the SQL*Plus environment

  • Produce more readable output

  • Create and execute script files

  • Save customizations

Manipulating Data

  • Describe each DML statement

  • Insert rows into a table

  • Update rows in a table

  • Delete rows from a table

  • Control transactions

 
 

Index
 

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