Topic: Oracle Certified Professional Exams (OCP & OCA) >> Correction for 1z0-007 ....Plz help
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Correction for 1z0-007 ....Plz help |
| gill123 |
Posted: Jun 21, 2007 04:40:06 PM |
Total Post: 12
Joined: Jun, 2007
|
For the following questions I found confusing answers from the dump:
QUESTION NO: 32
Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS
tables.
EMPLOYEES
EMPLOYEE_ID NUMBER NOT NULL, Primary Key
EMP_NAME VARCHAR2 (30)
JOB_ID VARCHAR2 (20)
SALARY NUMBER
MGR_ID NUMBER References EMPLOYEE_ID column
DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table
DEPARTMENTS
DEPARTMENT_ID NUMBER NOT NULL, Primary Key
DEPARTMENT_NAME VARCHAR2(30)
MGR_ID NUMBER References NGR_ID column of the EMPLOYEES table
LOCATION_ID NUMBER Foreign key to LOCATION_ID column of the LOCATIONS table
LOCATIONS
LOCATION_ID NUMBER NOT NULL, Primary Key
CITY VARCHAR2 |30)
Which two SQL statements produce the name, department name, and the city of all the
employees who earn more then 10000? (Choose two)
A. SELECT emp_name, department_name, city
FROM employees e
JOIN departments d
USING (department_id)
JOIN locations 1
USING (location_id)
WHERE salary > 10000;
B. SELECT emp_name, department_name, city
FROM employees e, departments d, locations 1
JOIN ON (e.department_id = d.department id)
AND (d.location_id =1.location_id)
AND salary > 10000;
C. SELECT emp_name, department_name, city
FROM employees e, departments d, locations 1
WHERE salary > 10000;
D. SELECT emp_name, department_name, city
FROM employees e, departments d, locations 1
WHERE e.department_id = d.department_id
AND d.location_id = 1.location_id
AND salary > 10000;
E. SELECT emp_name, department_name, city
FROM employees e
NATURAL JOIN departments, locations
WHERE salary > 10000;
Answer: B, D
This is the answer I found in Actualtest. And in Testking the answer is A, D. Actually both A and B(along with D) looks correct to me.
Can anybody plz confirm which one is the correct answer.
-------------------------------------------------------------------------
-------------------------------------------------------------------------
QUESTION NO: 37
Which two are true about aggregate functions? (Choose two.)
A. You can use aggregate functions in any clause of a SELECT statement.
B. You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
C. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D. You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E. You can use aggregate functions on a table, only by grouping the whole table as one single group.
F. You cannot group the rows of a table by more than one column while using aggregate functions.
Answer: C, D
IS THIS ANSWER CORRECT....PLEASE CONFIRM.
|
|
|
 KS |
| Posted: Jun 22, 2007 12:46:14 AM |  |
|
Total Post: 60
Joined: Nov, 2006
|
For QUESTION NO: 32
A and D is the correct option,
Sol :
-----
create the tables and test the options.
-Sri
|
|
|
|
|
| gill123 |
| Posted: Jun 22, 2007 02:47:08 AM | |
|
Total Post: 12
Joined: Jun, 2007
|
Thanks.
Actually I do not have the oracle installed so I have to learn from reading the books and other materials.
BTW...do you know the answer for the other question?
Another thing....do you have the softcopy for OCP Introduction to Oracle9I: SQL Exam Guide, by Jason Couchman?
Thanks for your help.
|
|
|
|
|
| KS |
| Posted: Jun 22, 2007 03:06:49 AM | |
|
Total Post: 60
Joined: Nov, 2006
|
Hi,
What I suggest is , install oracle and work on SQL, without working on SQL you will not get the clear concept of how the SQL statements works.
-Sri
|
|
|
|
|
| gill123 |
| Posted: Jun 23, 2007 01:08:43 AM | |
|
Total Post: 12
Joined: Jun, 2007
|
Sri....thanks for the advice. I will try to do it. But since I am also following the dump, there are some confusions which I am trying to clear.
Thanks.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 242 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| Bishal Khetan | 169 |
|
|
