Exam 1z0-001: Introduction to Oracle: SQL and PL/SQL
Exam Number: 1Z0-001
Associated Certifications: Oracle9i DBA OCA
Application Developer R.6i OCP
Application Developer R.9i OCA
Exam Price: $125.00 USD
Exam Registration: Register

Duration: 120 minutes
Number of Questions: 57
Passing Score: 68%
Recommended Training and Preparation
Introduction to Oracle 8i: SQL and PL/SQL – ILO
Introduction to Oracle8i: SQL and PL/SQL Self-Study CD Course (NETg)
Self-Study CD-ROMs are an excellent tool to help you prepare for your exam. SSCDs reinforce the course material and allow you to focus on sections that you need to review. Note: the SSCDs do not count towards your course requirements for certification and should be used as a study aid only.

Additional Information & Resources
Practice Exams

Oracle authorized practice exam from Self Test Software.1Z0-001 Intro to Oracle: SQL and PL/SQL
Oracle authorized practice exam from Transcender: Cert-1Z0-001 : DBCert: Introduction to SQL and PL/SQL
Candidate Guides

Oracle9i DBA Certification Exam Candidate Guide
Application Developer 6i OCP Candidate Guide
Application Developer 9i Candidate Guide
Exam Retake Policy

Exam Topics
Creating and Managing Tables
[ ] Describe the main database objects
[ ] Create tables
[ ] Describe the datatypes that can be used when specifying column definition
[ ] Alter table definitions
[ ] Drop, rename, and truncate tables

Including Constraints
[ ] Describe constraints
[ ] Create and maintain constraints

Create and maintain constraints
[ ] Describe a view
[ ] Create a view
[ ] Retrieve data through a view
[ ] Insert, update, and delete data through a view
[ ] Drop a view

Oracle Data Dictionary
[ ] Describe the data dictionary views a user may access
[ ] Query data from the data dictionary

Writing Control Structures
[ ] Identify the uses and types of control structures
[ ] Construct an IF statement
[ ] Construct and identify different loop statements
[ ] Use logic tables
[ ] Control block flow using nested loops and labels

Working with Composite Datatypes
[ ] Create user-defined PL/SQL records
[ ] Create a record with the % ROWTYPE attribute
[ ] Create a PL/SQL table
[ ] Create a PL/SQL table of records
[ ] Describe the difference between records, tables, and tables of records

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

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

Creating Views
[ ] Describe a view
[ ] Create, alter the definition, and drop a view
[ ] Retrieve data through a view
[ ] Insert, update and delete data through a view
[ ] Create and use an inline view
[ ] Perform Top ‘N’ Analysis
Other Database Objects
[ ] Describe database objects and their uses
[ ] Create, maintain, and use sequences
[ ] Create and maintain indexes
[ ] Create private and public synonyms

Controlling User Access
[ ] Create users
[ ] Create roles to ease setup and maintenance of the security model
[ ] Use the GRANT and REVOKE statements to grant and revoke object privileges

Declaring Variables
[ ] List the benefits of PL/SQL
[ ] Describe the basic PL/SQL block and its sections
[ ] Describe the significance of variables in PL/SQL
[ ] Declare PL/SQL variables
[ ] Execute a PL/SQL block

Writing Explicit Cursors
[ ] Distinguish between an implicit and an explicit cursor
[ ] Use a PL/SQL record variable
[ ] Write a cursor FOR loop

Advanced Explicit Cursor Concepts
[ ] Write a cursor that uses parameters
[ ] Determine when a FOR UPDATE clause in a cursor in required
[ ] Determine when to use the WHERE CURRENT OF clause
[ ] Write a cursor that uses a subquery

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 the 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 by using equality and nonequality joins
[ ] View data that generally does not meet a join condition by using outer joins
[ ] Join a table to itself
Writing Executable Statements
[ ] Describe the significance of the executable section
[ ] Write statements in the executable section
[ ] Describe the rules of nested blocks
[ ] Execute and test a PL/SQL block
[ ] Use coding conventions

Interacting with the Oracle Server
[ ] Write a successful SELECT statement in PL/SQL
[ ] Declare the datatype and size of a PL/SQL variable dynamically
[ ] Write DML statements in PL/SQL
[ ] Control transactions in PL/SQL
[ ] Determine the outcome of SQL DML statements

Handing Exceptions
[ ] Define PL/SQL exceptions
[ ] Recognize unhandled exceptions
[ ] List and use different types of PL/SQL exception handlers
[ ] Trap unanticipated errors
[ ] Describe the effect of exception progagation in nested blocks
[ ] Customize PL/SQL exception messages

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 iSQL*Plus
[ ] Produce queries that require a substitution variable
[ ] Produce more readable output
[ ] Create and execute script files

Manipulating Data
[ ] Describe each DML statement
[ ] Insert rows into a table
[ ] Update rows in a table
[ ] Delete rows from a table
[ ] Merge rows in a table
[ ] Control transactions

Including Constraints
[ ] Describe constraints
[ ] Create and maintain constraints

Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.
If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate’s Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate’s employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle’s authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.

Recommended Training about 1z0-001 exam PDF
The following courses are the recommended training for 1z0-001 exam PDF.
1z0-001 Q & A with Explanations
1z0-001 Audio Exam
1z0-001 Study Guide
1z0-001 Preparation Lab
1z0-001 Exam: Freetestking’s 9i Internet Application Developer Introduction to Oracle: SQL and PL/SQL PDF
The 9i Internet Application Developer Introduction to Oracle: SQL and PL/SQL PDF for preparing for the 1z0-001 exam – Freetestking’s 9i Internet Application Developer Introduction to Oracle: SQL and PL/SQL. Freetestking is your premier source for practice tests, and true testing environment. Nothing will prepare you for your next exam like a Freetestking. You find it all here at certbible.org.
QUESTION 1
You need to create a report to display the ship date and ordertotals
of your ordid table. If the orderhas not been shipped your report must display not shipped. If the total is not available your report must say not available. In the ordid table the ship date column has a data type of date the total column has a data type
of number. Which statement do you use to create this report?

A. Select ordid, shipdate “Not shipped”, total “Not available”
FROM order;
B. Select ordid, NVL (shipdate, ‘Not shipped’), NVL (total, “Not available”)
FROM order;
C. Select ordid, NVL (TO_CHAR (shipdate), ‘Not shipped’), NVL (TO_CHAR (total), ‘Not available’)
FROM order;
D. Select ordid, TO_CHAR (shipdate, ‘Not shipped’) TO_CHAR (total, ‘Not available’)
FROM order; Answer: C
Explanation:
Answer C shows correct syntax of command NVL Incorrect Answers:
A: This command will show ALL data with name substitution of columns shipdate and total.
B: Incorrect usage for NVL command, because shipdate and total are needed to be converted into VARCHAR2 type with TO_CHAR function. Both parameters of NVL command have to have the same data type.
D: Incorrect syntax. TO_CHAR command is used just to convert data type into VARCHAR2 data type, it have nothing to do with NULL values in columns. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 10-11
Chapter 1: Selecting Data from Oracle

QUESTION 2
You want to display the details of all employees whose last names
is Smith. But you are not sure in which case last names are stored. Which statement will list all the employees whose last name is Smith?

A. Select last name, first name. FROM emp
WHERE last name= ’smith’;
B. Select last name, first name. FROM emp

TK

1Z0-001

WHERE UPPER (last name)= ’smith’;
C. Select last name, first name. FROM emp
WHERE last name=UPPER (’smith’); D. Select last name, first name.
FROM emp
WHERE LOWER (last name)= ’smith’; Answer: D
Explanation:
Select last name, first name. FROM emp
WHERE LOWER (last name)= ’smith’
Answer D shows all records with last name Smith because function LOWER returns the column value passed as x into all lowercase
Incorrect Answers:
A: This command will show only records with last name ’smith’.
B: Command UPPER converts all data in last_name column into uppercase. C: This command will show only records with last name ‘SMITH’.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 22
Chapter 1: Selecting Data from Oracle

PassGuide offers free demo for Certification Exams You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products. Download links:http://demo.passguide.com/download

QUESTION 3
You need to analyze how long your orders to be shipped from the date that the order is placed. To do this you must create a report that displays the customer number, date order, date shipped and the number of months in whole numbers
from the time the order is placed to the time the order is shipped. Which statement produces the required results?

A. SELECT custid, orderdate, shipdate, ROUND(MONTHS_BETWEEN(shipdate,orderdate))
“Time Taken” FROM ord;
B. SELECT custid, orderdate, shipdate, ROUND(DAYS_BETWEEN(shipdate,orderdate))/30. FROM ord;
C. SELECT custid, orderdate, shipdate,
ROUND OFF (shipdate-orderdate) “Time Taken” FROM ord;
D. SELECT custid, orderdate, shipdate, MONTHS_BETWEEN (shipdate,orderdate) “Time Taken”. FROM ord;

Answer: A

TK

1Z0-001

Explanation:
Answer A shows the number of months (rounded to integer) between the date of order and the date of shipment.
Incorrect Answers:
B: Function, function DAYS_BETWEEN shows number of days between shipping date and order date.
C: Incorrect function ROUND OFF.
D: This command will show not rounded to integer value, like 8.6451613. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 30
Chapter 1: Selecting Data from Oracle

QUESTION 4
The employee table contains these columns: Last_name Varchar2 (25)
First_name Varchar2 (25) Salary Number7, 2
You need to display the names of employees on more than an average salary of all employees. Evaluate the SQL statement.
SELECT LAST_NAME, FIRST_NAME from employee where salary

A. Change the function in the Where clause.
B. Move the function to the select clause and add a group clause.
C. Use a sub query in the where clause to compare the average salary value.
D. Move the function to the select clause and add a group by clause and a having clause. Answer: C
Explanation:
Answer C shows the correct way to change query, because function
AVG can not be used in WHERE clause. Incorrect Answers:
A: Usage of function AVG is correct
B: This query does not require grouping to extract correct information from the table.
D: This query does not require to use GROUP BY and HAVING clauses to extract correct information from table
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 57
Chapter 2: Advanced Data Selection in Oracle

QUESTION 5
The employee table contains these columns: FIRST-NAME VARCHER2(25) COMISSION NUMBER(3,2)
Evaluate this SQL statement SELECT first-name,commission FROM employee

Interactive Testing 9i 1z0-001 Engine Included!
131 Questions
Updated : 09/18/2008
Price : $87.99 $79.99
Exam Number/Code:1z0-001
Exam Name: 9i Internet Application Developer Introduction to Oracle: SQL and PL/SQL

Testking 1z0-001 Exam will provide you with exam simulation questions and actual answers that reflect the actual exam
Preparing for the Testking 1z0-001 exam?Searching 1z0-001 Test Questions,
1z0-001 Practice Exam,1z0-001 Braindumps ? 1z0-001 practice exam covers all the practice test objectives to pass 1z0-001 exam.

Pass your exam at first attempt with our Testking 1z0-001 study guide,1z0-001 Braindumps, As well Audio exam, Realistic Practice Labs, and Interactive Testing Engine.

Our Testking practice test covers the information associated with each 1z0-001 exam topics in details and includes information found in no other practice test sites on the web.

Our challenging questions with Correct Answers built to simulate the actual exam. Unlimited, FREE auto-updates so you’re never behind on any topic. The whole package comes as an automatic download so there’s no waiting or shipping. Our most questions and answers along with explanations. Our practice test will determine you to take your 1z0-001 certification exam and pass the official exam on your first try, guaranteed

Now guaranteed Testking 1z0-001 exam training is available in various formats to best suit your needs and learning style. Whether you are a hands-on tactile learner, visually or even a textbook training veteran, Real-Exams has the 1z0-001 pdf vce format resources that will enable you to pass your 1z0-001 test with flying colors.

Comprehensive questions with complete explanations about actualtests 1z0-001 exam
download 1z0-001 exam questions accompanied by exhibits
Verified Answers Researched by Industry Experts and almost 100% correct
1z0-001 exam questions updated on regular basis

Oracle 1z0-001 Transcender Torrent
Oracle 1z0-001 P4S
Oracle 1z0-001 Study Guide
Oracle 1z0-001 Exams
Oracle 1z0-001 Braindumps
Oracle 1z0-001 Pass4sure
Oracle 1z0-001 Real Exams
Oracle 1z0-001 Exam
Oracle 1z0-001 Actual Tests
Oracle 1z0-001 Pdf

1z0-001 also gives new editions of Real Exams 1z0-001 for enhancing professional skills and knowledge. These Testking Real Practice Questions 000-710 are useful for understanding 1z0-001 exam terminologies and these brain dumps also very useful for enhancing people brain power. These Testking Real Practice Questions 1z0-001 are prepare by highly qualified and 1z0-001 professionals. 1z0-001 Certification experts’ teams always try to give you real exam environment in these 4shared training materials links.

QUESTION 1
You need to create a report to display the ship date and ordertotals
of your ordid table. If the orderhas not been shipped your report must display not
shipped. If the total is not available your report must say not available. In the ordid
table the ship date column has a data type of date the total column has a data type
of number. Which statement do you use to create this report?
A. Select ordid, shipdate “Not shipped”,
total “Not available”
FROM order;
B. Select ordid, NVL (shipdate, ‘Not shipped’),
NVL (total, “Not available”)
FROM order;
C. Select ordid, NVL (TO_CHAR (shipdate), ‘Not shipped’),
NVL (TO_CHAR (total), ‘Not available’)
FROM order;
D. Select ordid, TO_CHAR (shipdate, ‘Not shipped’)
TO_CHAR (total, ‘Not available’)
FROM order;
Answer: C
Explanation:
Answer C shows correct syntax of command NVL
Incorrect Answers:
A: This command will show ALL data with name substitution of columns shipdate and
total.
B: Incorrect usage for NVL command, because shipdate and total are needed to be
converted into VARCHAR2 type with TO_CHAR function. Both parameters of NVL
command have to have the same data type.
D: Incorrect syntax. TO_CHAR command is used just to convert data type into
VARCHAR2 data type, it have nothing to do with NULL values in columns.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 10-11
Chapter 1: Selecting Data from Oracle
QUESTION 2
You want to display the details of all employees whose last names
is Smith. But you are not sure in which case last names are stored. Which statement
will list all the employees whose last name is Smith?
A. Select last name, first name.
FROM emp
WHERE last name= ’smith’;
B. Select last name, first name.
FROM emp
WHERE UPPER (last name)= ’smith’;
C. Select last name, first name.
FROM emp
WHERE last name=UPPER (’smith’);
D. Select last name, first name.
FROM emp
WHERE LOWER (last name)= ’smith’;
Answer: D
Explanation:
Select last name, first name.
FROM emp
WHERE LOWER (last name)= ’smith’
Answer D shows all records with last name Smith because function LOWER returns the
column value passed as x into all lowercase
Incorrect Answers:
A: This command will show only records with last name ’smith’.
B: Command UPPER converts all data in last_name column into uppercase.
C: This command will show only records with last name ‘SMITH’.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 22
Chapter 1: Selecting Data from Oracle
QUESTION 3
You need to analyze how long your orders to be shipped from the date that the
order is placed. To do this you must create a report that displays the customer
number, date order, date shipped and the number of months in whole numbers
from the time the order is placed to the time the order is shipped. Which statement
produces the required results?
A. SELECT custid, orderdate, shipdate,
ROUND(MONTHS_BETWEEN(shipdate,orderdate))
“Time Taken”
FROM ord;
B. SELECT custid, orderdate, shipdate,
ROUND(DAYS_BETWEEN(shipdate,orderdate))/30.
FROM ord;
C. SELECT custid, orderdate, shipdate,
ROUND OFF (shipdate-orderdate) “Time Taken”
FROM ord;
D. SELECT custid, orderdate, shipdate,
MONTHS_BETWEEN (shipdate,orderdate) “Time Taken”.
FROM ord;
Answer: A
Explanation:
Answer A shows the number of months (rounded to integer) between
the date of order and the date of shipment.
Incorrect Answers:
B: Function, function DAYS_BETWEEN shows number of days between shipping date
and order date.
C: Incorrect function ROUND OFF.
D: This command will show not rounded to integer value, like 8.6451613.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 30
Chapter 1: Selecting Data from Oracle
QUESTION 4
The employee table contains these columns:
Last_name Varchar2 (25)
First_name Varchar2 (25)
Salary Number7, 2
You need to display the names of employees on more than an average salary of all
employees. Evaluate the SQL statement.
SELECT LAST_NAME, FIRST_NAME from employee where salary Which change should you make to achieve the desired results?
A. Change the function in the Where clause.
B. Move the function to the select clause and add a group clause.
C. Use a sub query in the where clause to compare the average salary value.
D. Move the function to the select clause and add a group by clause and a having clause.
Answer: C

Testking 1z0-001
TK Questions&Answers(Q & As with Expert Explanations): 130 Q&A
Update: 03/11/2008

Free Down: Testking 1z0-001
Free Down: Pass4sure 1z0-001

High quality IT Certification Training Exam Questions, Study Guides and Practice Tests are in Downloadable PassGuide Testing Engine,Successful for IT Certification or Full Refund for you.www.freepassguide.co.uk

Dowload PassGuide Practice Test Questions

• testking-oracle-oca-exams
• testking-oracle-OCP8 to OCP8i DBA Upgrade -exams
• testking-oracle-oca-exams
• testking-oracle-Linux-exams
• testking-oracle-9i Internet Application Developer-exams
• testking-oracle-9i DBA-exams
• testking-oracle-8i DBA-exams
• testking-oracle-11i-exams
• testking-oracle-11g-exams
• testking-oracle-10g OCA-exams
• testking-oracle-10g DBA-exams
• testking oracle 10g 1z0-311
• testking oracle OCA 1z0-301
• testking oracle 9i 1z0-147
• testking oracle 9i 1z0-141