testking oracle 9i 1z0-007
Visited 6490 times, 11 so far today
Exam 1z0-007: Introduction to Oracle9i: SQL
Exam Number: 1Z0-007
Associated Certifications: Oracle9i DBA OCA
Application Developer R.6i OCP
Application Developer R.9i OCA
Exam Price: $95.00 USD
Exam Registration: Register
Exam available online
Duration: 120 minutes
Number of Questions: 52
Passing Score: 71%
Recommended Training and Preparation
One of the following classes recommended to prepare for exam:
Introduction to Oracle9i: SQL
or Oracle Database 10g: Introduction to SQL
or Oracle Database 10g: SQL Fundamentals I
The Introduction to Oracle 9i SQL course covers additional topics that are not covered on the exam.
Introduction to Oracle9i: SQL Self-Study CD Course (NETg Oracle)
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-007 Introduction to Oracle9i: SQL
Oracle authorized practice exam from Transcender: Cert-1Z0-007 : DBCert: Introduction to 9i: 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
Writing Basic SQL Select Statements
[ ] List the capabilities of SQL SELECT statements
[ ] Execute a basic SELECT statement
[ ] Differentiate between SQL statements and iSQL*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
Subqueries
[ ] Describe the types of problems that subqueries can solve
[ ] Define subqueries
[ ] List the types of subqueries
[ ] Write single-row and multiple-row subqueries
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
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
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
Creating Other Database Objects
[ ] Create, maintain and use sequences
[ ] Create and maintain indexes
[ ] Create private and public synonyms
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-007 exam PDF
The following courses are the recommended training for 1z0-007 exam PDF.
1z0-007 Q & A with Explanations
1z0-007 Audio Exam
1z0-007 Study Guide
1z0-007 Preparation Lab
1z0-007 Exam: Freetestking’s ineroduction to oracle9l:sql PDF
The ineroduction to oracle9l:sql PDF for preparing for the 1z0-007 exam – Freetestking’s ineroduction to oracle9l: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. (A)
Which SELECT statement should you use if you want to display unique combinations of the
POSITION and MANAGER values from the EMPLOYEE table?
A. SELECT DISTINCT position, manager
FROM employee;
B. SELECT position, manager DISTINCT FROM employee;
C. SELECT position, manager
FROM employee;
D. SELECT position, DISTINCT manager
FROM employee;
Answer: A Explanation:
To display a unique values in the result you can use the DISTINCT key word this will eliminate the duplicate values from the result of the query.
Question: 2. (A)
Which two are attributes of iSQL*Plus? (Choose two)
A. iSQL*Plus commands cannot be abbreviated.
B. iSQL*Plus commands are accesses from a browser.
C. iSQL*Plus commands are used to manipulate data in tables.
D. iSQL*Plus commands manipulate table definitions in the database.
E. iSQL*Plus is the Oracle proprietary interface for executing SQL statements.
Answer: B, E Question: 3. (A)
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.
You want to look at the definition of the view (the SELECT statement on which the view was
create.)
How do you obtain the definition of the view?
A. Use the DESCRIBE command in the EMP_DEPT VU view.
B. Use the DEFINE VIEW command on the EMP_DEPT VU view.
C. Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
D. Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E. Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F. Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
Answer: D Explanation:
To look on the view definition you need to query the USER_VIEWS data dictionary view and search for the EMP_DEPT_VU view.
Incorrect Answers
A: You cannot see the definition of the view using the DESCRIBE command.
B: There is no DEFINE VIEW command in Oracle.
C: There is no DESCRIBE VIEW command in Oracle.
TK
Exam Name: Introduction to Oracle9i: SQL
Exam Type: Oracle Exam Code: 1Z0-007
Doc. Type: Q & A with explanations Total Questions 301
E: You cannot use the USER_SOURCE data dictionary view to see the definition of your view: it
is used to store system objects definitions only.
F: You can find record about view in the USER_OBJECTS, but it does not contain the definition
of the view itself.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 291-301
Chapter 7: Creating Other Database Objects in Oracle
Question: 4. (A)
Which is an /SQL*Plus command?
A. INSERT B. UPDATE C. SELECT
D. DESCRIBE E. DELETE
F. RENAME
Answer: D Explanation:
There is only one SQL*Plus command in this list: DESCRIBE. It cannot be used as SQL
command. This command returns a description of tablename, including all columns in that table, the datatype for each column, and an indication of whether the column permits storage of NULL values.
Incorrect Answers
A: INSERT is not a SQL*Plus command. It
Dowload PassGuide Practice Test Questions
9 Comments on “testking oracle 9i 1z0-007”