Urgent help needed @IZ0-007 [message #327132] |
Sat, 14 June 2008 02:51 |
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 #331468 is a reply to message #327358] |
Thu, 03 July 2008 08:58 |
|
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.
|
|
|