Testking Oracle 9i DBA Exam 1z0-007
- Tuesday, July 15, 2008, 6:44
- Cert Tests
- 841 views
- 3 comments
ineroduction to oracle9l:sql : 1z0-007 ExamOracle: 1z0-007 Exam
Interactive Testing Engine Included!
204 Questions
Updated : 03/07/2008
Price : $76.99 $69.99
Passed
I passed the exam 1z0-007 from your dump. Thanks for that.
– Oct 11, 2007
Passed
I just wanted to take the time to tell you how happy I am with your product.
– Jan 16, 2008
Oracle 1z0-007 Exam
Exam 1z0-007: Introduction to Oracle9i: SQL
By passing this exam you can prove that you are able to work with Oracle9i. The technician will have enough knowledge about the program to work with it. The test contains 52 questions and takes roughly 120 minutes to complete. You would need a passing score of 71% to pass and get your certification.
Exam Name: Introduction to Oracle9i: SQL
Exam Type: Oracle Exam Code: 1Z0-007
Doc. Type: Q & A with explanations Total Questions 301
Contents
Objective
A. Writing Basic SQL Select Statements
B. Restricting and Sorting Data
C. Single-Row Functions & Group Functions.
D. Displaying Data from Multiple Tables
E. Subquerie
F. Creating and Managing Tables
G. Including Constraints
H. Manipulating Data
I. Creating Views
J. Creating Other Database Objects
K. Controlling User Access
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.
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’s data-manipulation language (DML) command.
B: UPDATE is not a SQL*Plus command. It’s data-manipulation language (DML) command.
C: SELECT is not a SQL*Plus command.
E: DELETE is not a SQL*Plus command. It’s data-manipulation language (DML) command.
F: RENAME is not a SQL*Plus command.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 43
Chapter 1: Overview of Oracle Databases
Question: 5. (A)
You need to produce a report for mailing labels for all customers. The mailing label must have
only the customer name and address. The CUSTOMERS table has these columns:
CUST_ID NUMBER(4) NOT NULL
CUST_NAME VARCHAR2(100)
CUST_ADDRESS VARCHAR2(150)
CUST_PHONE VARCHAR2(20)
Which SELECT statement accomplishes this task?
A. SELECT*
FROM customers;
B. SELECT name, address
FROM customers;
C. SELECT id, name, address, phone
FROM customers;
D. SELECT cust_name, cust_address
FROM customers;
E. SELECT cust_id, cust_name, cust_address, cust_phone
FROM customers;.
Answer: D
Explanation:
This answer provides correct list of columns for the output.
Incorrect Answers
A: This answer does not provide correct list of columns for the output. It is not required to show
all columns of the table. Symbol “*” is used in the SELECT command to substitute a list of all
columns of the table.
B: This answer does not provide correct list of columns for the output. There are not NAME and
ADDRESS columns in the CUSTOMERS table.
C: This answer does not provide correct list of columns for the output. There are not ID, NAME,
ADDRESS or PHONE columns in the CUSTOMERS table.
E: This answer does not provide correct list of columns for the output. It is not required to show all
columns of the table.
OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 20-24
Chapter 1: Overview of Oracle Databases
Question: 6. (A)
Evaluate this SQL statement:
SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME.
FROM EMP e, DEPARTMENT d
WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?
A. Selection, projection, join
B. Difference, projection, join
C. Selection, intersection, join
D. Intersection, projection, join
E. Difference, projection, product
Answer: A
free down1:Testking Oracle 9i DBA Exam 1z0-007
free down2:pass4sure oracle 1z0-007
password:www.certbible.org
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.Contact Us:Sales@PassGuide.com|
Type |
Exam Bible | New Questions & Answers |
Latest Updated |
Download link |
| All Certbible 's Exam Dumps |
597 |
1 days ago | Available |
PassGuide Training Materials & Practice Tests
About the Author
Free Certification Exam Download has written 10018 stories on this site.
If you have any doubts about legality of content or you have another suspicions, feel free to contact us:CertGuard@Gmail.com
Write a Comment
Gravatars are small images that can show your personality. You can get your gravatar for free today!
