|
9i: Introduction - SQL
(1106) |
|
Return to Search Results | Request More Information | View Comments | Recommend this Test Prep |
 |
Summary:
Exam 1Z0-007 validates the testers knowledge to an introduction of data server technology. The exam covers the concepts of both relational and object relational databases and the powerful SQL programming language. Candidates will be tested on how to create and maintain database objects and to store, retrieve, and manipulate data.
Exam 1Z0-007 is designed for those individuals who are working on the Oracle 9i: Database Administrator exam, System Administrators, Application Developers, Designers and Developers. |
|
Test Prep Offered By:
|
|
Test Prep Cost:
$109.00
|
Financing:
Financing is not available |
|
Description:
Exam 1Z0-007 validates the testers knowledge to an introduction of data server technology. The exam covers the concepts of both relational and object relational databases and the powerful SQL programming language. Candidates will be tested on how to create and maintain database objects and to store, retrieve, and manipulate data.
Exam 1Z0-007 is designed for those individuals who are working on the Oracle 9i: Database Administrator exam, System Administrators, Application Developers, Designers and Developers.
This product is part of the following certification paths:
* Oracle8i OCP - Oracle8i Certified Professional Database Administrator
* Oracle9i DBA OCA - Oracle9i DBA Certified Associate
* Oracle9i PL/SQL - Oracle9i PL/SQL Developer Certified Associate
CORE TESTS:
Oracle 9i: (1Z0-007) Introduction - SQL
This test includes 151 questions and covers the following objectives
* Writing Basic SQL Select Statements - 14 questions
* Restricting and Sorting Data - 6 questions
* Single-Row Functions - 20 questions
* Displaying Data from Multiple Tables - 7 questions
* Aggregating Data using Group Functions - 14 questions
* Subqueries - 9 questions
* Producing Readable Output with iSQL*Plus - 11 questions
* Manipulating Data - 15 questions
* Creating and Managing Tables - 12 questions
* Including Constraints - 9 questions
* Creating Views - 17 questions
* Creating Other Database Objects - 6 questions
* Controlling User Access - 11 questions
This test includes references to the following media:
* 163
* Introduction to Oracle9i: SQL
DISTRIBUTION TYPES:
30 Day Online Usage: $79.00
60 Day Online Usage: $89.00
CD-ROM: $109.00
Download: $109.00
|
|
Applicable Vendor Technologies:
Oracle
|
|
Associated Disciplines:
Databases
Software
|
|
RECOMMEND THIS COURSE
You must be logged in as a Candidate to recommend courses
|
|
|
|
