Home » Other » Training & Certification » Urgent help needed @IZ0-007
Urgent help needed @IZ0-007 [message #327132] Sat, 14 June 2008 02:51 Go to next message
ruchika19840
Messages: 7
Registered: June 2008
Junior Member
Below are few queries which are answered differently everywhere.
Google also could nt help much.
Please somebody give Concrete answers.


Question: 1

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables.
EMPLOYEES
EMPLOYEE_ID NUMBER NOT 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
theLOCATIONS table
LOCATIONS
Exam Name: Introduction to Oracle9i: SQL
Exam Type: Oracle Exam Code: 1Z0-007
Doc. Type: Q & A with explanations Total Questions 295
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
WHEREsalary > 10000;

D. SELECT emp_name, department_name, city
FROM employees e, departments d, locations 1
WHEREe.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
WHEREsalary > 10000;




WHy A is wrong. if it is then please explain.
Because JOIN and USING will work together.
then what is wrong?

Some ONE please reply SOON.



________________________________________________________________

Question: 2

SELECT *
FROM orders

You use this statement to retrieve data for ______

1) update
2) viewing
3) deleting
4) inserting
5) truncating


How come Update is in the answer.

Some one tell me the correct anwers for the above query.

____________________________________________________________________________________________________---

Question: 3

Which three statements about subqueries are true? (Choose three)
A. A single row subquery can retrieve only one column and one row.
B. A single row subquery can retrieve only one row but many columns.
C. A multiple row subquery can retrieve multiple rows and multiple columns.
D. A multiple row subquery can be compared by using the “>” operator.
E. A single row subquery can use the IN operator.
F. A multiple row subquery can use the “=” operator.

Except B & C ,which is the 3rd correct answer?
Its either D or E
And also please give the explanation for the same.
_______________________________________________________________________________________

Question: 4


Which three are true regarding the use of outer joins? (Choose three.)
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without
matching rows, to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the
OR operator.

E & F , which is the 3rd correct answer?
Its either D or A
And also please give the explanation for the same for better understanding.
_____________________________________________________________________________________________________


Question: 5

Which two statements complete a transaction? (Choose two)
A. DELETE employees;
B. DESCRIBE employees;
C. ROLLBACK TO SAVEPOINT C;
D. GRANT SELECT ON employees TO SCOTT;
E. ALTER TABLE employees
SET UNUSED COLUMN sal;
F. Select MAX(sal)
FROM employees
WHERE department_id = 20;

Ans: C, E

How come its C, It should be D.
Grant is a DCL command which does not require explicit COMMIT.

SomeOne please clear this confusion
____________________________________________________________________________________________

Question: 6

Which four are attributes of functions? (Choose four.)
A. cannot be nested
B. manipulate data items
C. act on each row returned
D. return one result per row
E. accept only one argument and return only one value
F. accept arguments which can be a column or an expression

Ans: b,c,d and ?
“?” must be either F or E and why?
With explanation PLEASE
______________________________________________________________________________________

Question: 7


In which four clauses can a subquery be used? (Choose four.)
A. in the INTO clause of an INSERT statement
B. in the FROM clause of a SELECT statement
C. in the GROUP BY clause of a SELECT statement
D. in the WHERE clause of a SELECT statement
E. in the SET clause of an UPDATE statement
F. in the VALUES clause of an INSERT statement

Answer: B, D, E, F

Its Should be B,D,E,A

Why evry where its written A instead of F.
Please conclude in getting it correctly.

___________-_____________________________________

Question: 8

In truncate the table structure will be remain. Then how come Truncate releases storage space?

EXPLAIN
_______________________________________________________-

Question: 9

What is the difference between iSql*plus and Sql*plus?
________________________________________


Question: 10

Which is a valid CREATE TABLE statement?
A. CREATE TABLE EMP9$# AS (empid number(2));
B. CREATE TABLE EMP*123 AS (empid number(2));
C. CREATE TABLE PACKAGE AS (packid number(2));
D. CREATE TABLE 1EMP_TEST AS (empid number(2));

I marked A but the correct answer given was C
Please anyone Explain
____________________________________________

Question: 11

Which three are true? (Choose three.)
A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
C. A MERGE statement can be used to insert new rows into a table.
D. A MERGE statement can be used to update existing rows in a table.

Answer: A, B, C or A,C,D

______________________________________
Question: 12.
Which two statements about subqueries are true? (Choose two.)
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its
subquery, unless table B is included in the main query's FROM clause.
C. A SQL query statement can display data from table B that is referred to in its subquery,
without including table B in its own FROM clause.
D A single row subquery can retrieve data from more than one table.
E. A single row subquery cannot be used in a condition where the LIKE operator is used for
comparison.
F. A multiple-row subquery cannot be used in a condition where the LIKE operator is used for
comparison.
Answer: B & D

But what about C and F
[ Option C as date department_name retirve without being part of FROM clause of main query

SELECT last_name,(SELECT department_name FROM department D WHERE D.department_id = E.department_id)
FROM employees E ]

And F is also TRUE

Please clarify expalin.


Re: Urgent help needed @IZ0-007 [message #327136 is a reply to message #327132] Sat, 14 June 2008 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read SOON OraFAQ Forum Guide.

You must format your queries, don't use words like urgent or soon, post your own answer and why...

Also always post your Oracle version (4 decimals).

Regards
Michel
Re: Urgent help needed @IZ0-007 [message #327137 is a reply to message #327132] Sat, 14 June 2008 03:29 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Question for you:
Go to this page and see if you can find what is said about using "urgent" in your topic title.

I stopped reading your post at question 1.
Why not simply test this?!
Re: Urgent help needed @IZ0-007 [message #327294 is a reply to message #327132] Mon, 16 June 2008 00:00 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
Is it a part of your (home) assignment?

If yes, please try to explore yourself.
Re: Urgent help needed @IZ0-007 [message #327358 is a reply to message #327294] Mon, 16 June 2008 03:58 Go to previous messageGo to next message
ruchika19840
Messages: 7
Registered: June 2008
Junior Member
nope ...i am having certification exam this sat.
and not able to get the correct answer for these que.
if you can help before fri then it might be of great use

[Updated on: Mon, 16 June 2008 04:00]

Report message to a moderator

Re: Urgent help needed @IZ0-007 [message #331402 is a reply to message #327132] Thu, 03 July 2008 04:34 Go to previous messageGo to next message
mahesh_oracledba
Messages: 1
Registered: July 2008
Location: pune
Junior Member
Laughing

U study hard and try to read the books on pl/sql


Regard's

Mahesh
Re: Urgent help needed @IZ0-007 [message #331468 is a reply to message #327358] Thu, 03 July 2008 08:58 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ruchika19840 wrote on Mon, 16 June 2008 01:58
nope ...i am having certification exam this sat.
and not able to get the correct answer for these que.
if you can help before fri then it might be of great use


Assuming above is true, then perhaps you should postpone the test until after you can answer these questions.
Previous Topic: Trigger
Next Topic: best book for Iz0 007 OCA exam
Goto Forum:
  


Current Time: Fri Mar 29 00:55:49 CDT 2024