MyResearchInstitute.Com Home Notes Library Braindumps Software Marketing

Oracle Braindumps, Oracle exam 1Z0-001, Oracle 8i SQL and PL/SQL. Passing this exam plus four others makes you an Oracle-certified DBA for Oracle 8i (an OCP-DBA). Exam topics include, SQL, various SQL language elements, security, PL/SQL, the data dictionary, and SQL*Plus.

Exam #:   1Z0-001

Status: Active

Time Limit: 120 min. 

Avg. Time: 53 min.

Passing Score: 68

# of Questions: 57

Format: Form-based

Difficulty: 3

Certifications: Oracle Certified Professional – DBA

Oracle Braindumps, Microsoft Braindumps, SunBrain Bumps, Cisco Braindumps,

CitrixBraindumps, CIWBraindumps, ComptiaBraindumps, NovellBraindumps

Overview of Relational Databases, SQL and PL/SQL

[1]  Discuss the theoretical and physical aspects of a relational database 

[2]  Describe the Oracle implementation of the RDBMS and ORDBMS

[3]  Describe the use and benefits of PL/SQL

Writing Basic SQL Statements 

[1]  List the capabilities of SQL SELECT statements 

[2]  Execute a basic SELECT statement 

[3]  Differentiate between SQL statements and SQL*Plus commands 

Restricting and Sorting Data 

[1]  Limit the rows retrieved by a query 

[2]  Sort the rows retrieved by a query 

Single Row Functions 

[1]  Describe various types of functions available in SQL

[2]  Use character, number, and date functions in SELECT statements 

[3]  Describe the use of conversion  functions  Displaying Data from Multiple Tables 

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

[5]  View data that generally does not  meet a join condition by using outer joins

[6]  Join a table to itself

Aggregating Data Using Group Functions

[1]  Identify the available group functions

[2]  Describe the use of group functions 

[3]  Group data using the GROUP BY clause 

[4 ]  Include or exclude grouped rows by using the HAVING clause

Subqueries 

[1]  Describe the types of problems that subqueries can solve  

[2]  Define subqueries 

[3]  List the types of subqueries

[4]  Write single-row and multiple-row subqueries Multiple-Column Subqueries

[5]  Write multiple-column subqueries

[6]  Describe and explain the behavior of subqueries when null values are retrieved  

[7]  Write subqueries in a FROM clause 

Managing Rollback Segments 

[1]  Produce queries that require an input variable

[2]  Customize the SQL*Plus environment 

[3]  Produce more readable output

[4]  Create and execute script files

[5]  Save customizations 

Manipulating Data 

[1]  Describe each DML statement 

[2]  Insert rows into a table

[3]  Update rows in a table 

[4]  Delete rows from a table 

[5]  Control transactions 

Creating and Managing 

Tables

[1]  Describe the main database objects

[2]  Create tables 

[3]  Describe the datatypes that can be used when specifying column definition

[4]  Alter table definitions 

[5]  Drop, rename, and truncate tables

Including Constraints 

[1]  Describe constraints

[2]  Create and maintain constraints.

Exam Questions